a
    KmÍiH  ã                   @   s@   d dl m Z  d dlmZ G dd„ dejƒZG dd„ dejƒZdS )é    )Údatetime)Údbc                   @   s  e Zd ZdZejejddZejeje d¡ddZ	eje 
d¡ddZe ej¡Ze e 
d¡¡Ze ej¡Ze ej¡Ze ej¡Ze ej¡Ze ej¡Ze ej¡Ze ej¡Ze ej¡Ze ej¡Zeje 
d¡d	d
Zejejejd
ZejdddddZ ejdddddZ!dS )ÚDatasetÚdatasetsT©Úprimary_keyzusers.idF©Únullableéÿ   é   Z
processing)ÚdefaultÚ	DataPointZdatasetÚdynamiczall, delete-orphan)ÚbackrefÚlazyÚcascadeÚAnalysisRunN)"Ú__name__Ú
__module__Ú__qualname__Ú__tablename__r   ÚColumnÚIntegerÚidÚ
ForeignKeyÚuser_idÚStringÚnameÚTextÚdescriptionZoriginal_filenameZnum_animalsZ	num_fixesÚDateTimeZ
time_startZtime_endÚFloatZbbox_min_latZbbox_min_lonZbbox_max_latZbbox_max_lonÚJSONÚcolumn_mappingZupload_statusr   ÚutcnowÚ
created_atÚrelationshipÚdata_pointsÚanalysis_runs© r)   r)   úK/home/japhy/trackingScienceReplication.artiswrong.com/app/models/dataset.pyr      s.   ÿÿr   c                   @   sÒ   e Zd ZdZejejddZejeje 	d¡ddZ
eje d¡ddZejejddZejejddZejejddZe ej¡Ze ej¡Ze ej¡Ze ej¡Ze dd	¡e d
d	d¡e dd	d¡fZdS )r   r'   Tr   zdatasets.idFr   r
   Zidx_dp_datasetÚ
dataset_idZidx_dp_animalÚ	animal_idZidx_dp_timeÚ	timestampN)r   r   r   r   r   r   Ú
BigIntegerr   r   r   r+   r   r,   r    r-   r!   ZlatZlonr"   Zsensor_dataZspeedZstep_lengthZturning_angleÚIndexÚ__table_args__r)   r)   r)   r*   r   #   s   
ýr   N)r   Úapp.extensionsr   ÚModelr   r   r)   r)   r)   r*   Ú<module>   s   