
    ;h                        d dl mZ d dlmZmZmZmZmZmZm	Z	m
Z
mZmZmZ d dlmZ  G d de      Z G d de      Z G d d	e      Z G d
 de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d  d!e      Z G d" d#e      Z G d$ d%e      Z G d& d'e      Z  G d( d)e      Z! G d* d+e      Z" G d, d-e      Z# G d. d/e      Z$ G d0 d1e      Z% G d2 d3e      Z& G d4 d5e      Z' G d6 d7e      Z( G d8 d9e      Z) G d: d;e      Z* G d< d=e      Z+ G d> d?e      Z, G d@ dAe      Z- G dB dCe      Z. G dD dEe      Z/ G dF dGe      Z0 G dH dIe      Z1 G dJ dKe      Z2 G dL dMe      Z3 G dN dOe      Z4 G dP dQe      Z5 G dR dSe      Z6 G dT dUe      Z7 G dV dWe      Z8 G dX dYe      Z9 G dZ d[e      Z: G d\ d]e      Z; G d^ d_e      Z< G d` dae      Z= G db dce      Z> G dd dee      Z? G df dge      Z@ G dh die      ZA G dj dke      ZB G dl dme      ZC G dn doe      ZD G dp dqe      ZE G dr dse      ZF G dt due      ZG G dv dwe      ZH G dx dye      ZI G dz d{e      ZJ G d| d}e      ZK G d~ de      ZL G d de      ZM G d de      ZN G d de      ZO G d de      ZP G d de      ZQ G d de      ZR G d de      ZS G d de      ZT G d de      ZU G d de      ZV G d de      ZW G d de      ZX G d de      ZY G d de      ZZ G d de      Z[ G d de      Z\ G d de      Z] G d de      Z^ G d de      Z_ G d de      Z` G d de      Za G d de      Zb G d de      Zc G d de      Zd G d de      Ze G d de      Zf G d de      Zg G d de      Zh G d de      Zi G d de      Zj G d de      Zk G d de      Zl G d de      Zm G d de      Zn G dĄ de      Zo G dƄ de      Zp G dȄ de      Zq G dʄ de      Zr G d̄ de      Zs G d΄ de      Zt G dЄ de      Zu G d҄ de      Zv G dԄ de      Zw G dք de      Zx G d؄ de      Zy G dڄ de      Zz G d܄ de      Z{ G dބ de      Z| G d de      Z} G d de      Z~ G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d  de      Z G d de      Z G d de      Z G d de      Z G d d	e      Z G d
 de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Zy(      )Base)ColumnIntegerStringDateTimeDate
ForeignKeyFloatBooleanTextNumericUniqueConstraint)datetimec                   P   e Zd ZdZ eed      Z e ed            Z e ed            Z	 ee      Z
 ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z e e             Z e e             Zy)BranchOfficeModelbranch_officesTprimary_key   N)__name__
__module____qualname____tablename__r   r   idr   branch_officeaddress	region_id
commune_id
segment_idzone_idprincipal_idgetaway_machine_id	status_idvisibility_idbasement_idopening_datedte_codeprincipal_supervisorr   
added_dateupdated_date     </var/www/jisbackend.com/public_html/app/backend/db/models.pyr   r      s    $M	T	*B6#;'MVC[!GwIJJWoG'?LwI7OM/K'?LgH!'?
#J(*%Lr,   r   c                      e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z ee      Z ee      Z ee      Z ee      Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e e             Z e e             Zy)DemarcationModeldemarcationsTr   r   N)r   r   r   r   r   r   r   branch_office_idmaterial_costslabor_costsmade_arrowsmade_pedestrian_crossingmade_disabilitymade_islandmade_pregnant	made_wallr   file_made_arrowsfile_made_pedestrian_crossingfile_made_disabilityfile_made_islandfile_made_pregnantfile_made_wallr   r)   r*   r+   r,   r-   r/   r/      s    "M	T	*BgG_N/K/K%gWoO/K7OMwIfSk*$*6#;$7!!&+.fSk*s,F3K(N
#J(*%Lr,   r/   c                   \    e Zd ZdZ eed      Z e ed            Z e ed            Z	y)SupplierModel	suppliersTr   r   N
r   r   r   r   r   r   r   r   rutsupplierr+   r,   r-   rA   rA   0   s/    M	T	*B

CfSk"Hr,   rA   c                   \    e Zd ZdZ eed      Z e ed            Z e ed            Z	y)Supplier2Model
suppliers2Tr   r   NrC   r+   r,   r-   rG   rG   7   s/     M	T	*B

CfSk"Hr,   rG   c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 ee      Z
 ee      Z e ed            Z e ed            Z	 ee      Z ee      Zy)ExpenseTypeModelexpense_typesTr   r   N)r   r   r   r   r   r   r   capitulation_visibility_idr   accounting_accounteerr_visibility_idtrack_visibility_idexpense_typetypegroup_detailr+   r,   r-   rJ   rJ   >   so    #M	T	*B!'s, /&+&Ls,'?D'?Lr,   rJ   c                   @    e Zd ZdZ eed      Z e ed            Zy)GroupDetailModelgroup_detailsTr   r   N)	r   r   r   r   r   r   r   r   rR   r+   r,   r-   rT   rT   K   s!    #M	T	*B&+&Lr,   rT   c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)	ZoneModelzonesTr   r   N)r   r   r   r   r   r   r   r   zoner   r)   r*   r+   r,   r-   rW   rW   Q   s9    M	T	*B&+D
#J(*%Lr,   rW   c                       e Zd ZdZ eed      Z e ed            Z e ed            Z	 e e
             Z e e
             Zy)GenderModelgendersTr   r   N)r   r   r   r   r   r   r   r   gendersocial_law_coder   r)   r*   r+   r,   r-   r[   r[   Y   sG    M	T	*BF3K FVC[)O
#J(*%Lr,   r[   c                   2   e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 e e
             Z e ed            Z e ed            Z e ed            Z ee      Z ee      Z e ed            Z e e             Z e e             Zy)MeshDatumModel	mesh_dataTr   r   N)r   r   r   r   r   r   r   turn_iddocument_employee_idrD   r   dater   total_hoursstartendweekweek_dayperiodr   r)   r*   r+   r,   r-   r`   r`   b   s    M	T	*BWoG!'?
/C$&>D%K6#;E

C'?DgHF3K F
#J(*%Lr,   r`   c                   j    e Zd ZdZ eed      Z ee      Z e ed            Z	 e e
             Zy)	MeshModelmeshesTr   r   N)r   r   r   r   r   r   r   rD   r   rj   r   r)   r+   r,   r-   rl   rl   s   s6    M	T	*B
/CF3K F
#Jr,   rl   c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z ee      Z e e             Z e e             Zy)MeshDetailModelmesh_detailsTr   N)r   r   r   r   r   r   r   mesh_idrb   week_id
is_working	is_sundayrD   r   rd   r)   r+   r,   r-   ro   ro   z   sa    "M	T	*BWoGWoGWoGJwI
/C(*D
#Jr,   ro   c                   z    e Zd ZdZ eed      Z ee      Z ee      Z e e	d            Z
 e e             Zy)HolidayModelholidaysTr   r   N)r   r   r   r   r   r   r   holiday_type_idinalienable_idr   holidayr   rd   r+   r,   r-   rv   rv      s?    M	T	*BWoOG_NVC[!G(*Dr,   rv   c                       e Zd ZdZ eed      Z ee      Z ee      Z e e	             Z
 e e	             Z e ed            Z e e             Z e e             Zy)PreEmployeeTurnModelpre_employees_turnsTr   r   N)r   r   r   r   r   r   r   rb   rD   r   
start_dateend_dater   rj   r   r)   r*   r+   r,   r-   r|   r|      sa    )M	T	*BWoG
/CJdf~HF3K F
#J(*%Lr,   r|   c                       e Zd ZdZ eed      Z e ed            Z ee      Z	 e e
             Z e e
             Zd Zy)NationalityModelnationalitiesTr   r   c                     | j                   | j                  | j                  | j                  r| j                  j	                  d      nd | j
                  r| j
                  j	                  d      dS d dS )N%Y-%m-%d %H:%M:%S)r   nationalityprevired_coder)   r*   )r   r   r   r)   strftimer*   selfs    r-   as_dictzNationalityModel.as_dict   so    ''++!//KO??$//223FG`dOSO`O`D--667JK
 	

 gk
 	
r,   N)r   r   r   r   r   r   r   r   r   r^   r   r)   r*   r   r+   r,   r-   r   r      sG    #M	T	*B%KWoO
#J(*%L
r,   r   c                       e Zd ZdZ eed      Z e ed            Z ee      Z	 e ed            Z
 e ed            Z ee      Z e e             Z e e             Zy)PentionModelpentionsTr   r   N)r   r   r   r   r   r   r   r   pentionr^   rD   amountr   r   r)   r*   r+   r,   r-   r   r      sg    M	T	*BVC[!GWoO

CF3K F7OM
#J(*%Lr,   r   c                   z    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zd Zy)	BankModelbanksTr   r   c                     | j                   | j                  | j                  | j                  r| j                  j	                  d      nd | j
                  r| j
                  j	                  d      dS d dS )Nr   )r   r$   bankr)   r*   )r   r$   r   r)   r   r*   r   s    r-   r   zBankModel.as_dict   sm    ''!//IIKO??$//223FG`dOSO`O`D--667JK
 	

 gk
 	
r,   N)r   r   r   r   r   r   r   r   r   r   r)   r*   r   r+   r,   r-   r   r      s>    M	T	*B&+D
#J(*%L
r,   r   c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)AccountTypeModelaccount_typesTr   r   N)r   r   r   r   r   r   r   r   account_typer   r)   r*   r+   r,   r-   r   r      9    #M	T	*B&+&L
#J(*%Lr,   r   c                       e Zd ZdZ eed      Z ee ed            Z ee      Z	 e e
             Z e e
             Zy)SupervisorModelsupervisorsTr   branch_offices.idN)r   r   r   r   r   r   r   r	   r1   rD   r   r)   r*   r+   r,   r-   r   r      sG    !M	T	*Bgz2E'FG
/C
#J(*%Lr,   r   c                       e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Z e ed            Z e e             Z e e             Zy)NewModelnewsTr   r   N)r   r   r   r   r   r   r   r   titler   descriptionmarkdown_descriptionpicturer   r)   r*   r+   r,   r-   r   r      s^    M	T	*B6#;E.K!$&>VC[!G
#J(*%Lr,   r   c                       e Zd ZdZ eed      Z e ed            Z ee      Z	 e e
             Z e e
             Zy)RegionModelregionsTr   r   N)r   r   r   r   r   r   r   r   regionregion_remuneration_coder   r)   r*   r+   r,   r-   r   r      sC    M	T	*BF3K F%g
#J(*%Lr,   r   c                   T    e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	y)TotalVacationDaysModeltotal_vacation_daysTr   N)
r   r   r   r   r   r   r   
total_daystotal_no_valid_daystotal_employee_vacation_daysr+   r,   r-   r   r      s0    )M	T	*BJ /#)'? r,   r   c                      e Zd ZdZ eed      Z ee      Z e ed            Z	 e ed            Z
 e ed            Z e ed            Z ee      Z ee      Z ee      Z e ed            Z e ed            Z e e             Z e ed            Z e ed            Z e e             Z e e             Zy)EmployeeModel	employeesTr      r   d   N)r   r   r   r   r   r   r   rD   r   
visual_rutnamesfather_lastnamemother_lastname	gender_idnationality_idsignature_type_idpersonal_email	cellphoner   	born_dater   	signaturer   r)   r*   r+   r,   r-   r   r      s    M	T	*B
/Cr
#J6#;EVC[)OVC[)OwIG_NwF3K(Nvc{#ItvIVC[!Gvc{#I
#J(*%Lr,   r   c                   
   e Zd ZdZ eed      Z ee ed            Z ee      Z	 ee      Z
 ee      Z ee      Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z ee      Z ee      Z e e             Z e e             Zy)	TurnModelturnsTr   employee_types.idr   N)r   r   r   r   r   r   r   r	   employee_type_idgroup_idgroup_day_idfree_day_group_idr$   r   turnworkingbreakingrf   rg   start_entry_time_thresholdend_entry_time_thresholdstart_exit_time_thresholdend_exit_time_thresholdstart_collation_time_thresholdend_collation_time_thresholdtotal_week_hours	day_hoursr   r)   r*   r+   r,   r-   r   r     s   M	T	*Bgz2E'FGgH'?Lw7OM&+DVC[!GfSk"H6#;E

C!'s!4%fSk2 &vc{ 3$VC[1%+F3K%8"#)&+#6 gwI
#J(*%Lr,   r   c                       e Zd ZdZ eed      Z ee      Z ee      Z e e	d            Z
 e e	d            Z e e	d            Z ee      Z e e             Z e e             Zy)ScheduleModelscheduleTr   r   N)r   r   r   r   r   r   r   rb   week_schedule_idr   horary_namerf   rg   dayr   r)   r*   r+   r,   r-   r   r   $  sq    M	T	*BWoGg%K6#;E

C
/C
#J(*%Lr,   r   c                       e Zd ZdZ eedd      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z ee      Z ee      Z e e             Z e e             Zy)
FolioModelfoliosTr   autoincrementN)r   r   r   r   r   r   r   folior1   
cashier_idfolio_segment_idrequested_status_idused_status_idbilled_status_idr   r)   r*   r+   r,   r-   r   r   1  sp    M	T	>B7OEgJg /G_Ng
#J(*%Lr,   r   c                       e Zd ZdZ eedd      Z e ed            Z e ed            Z	 e ed            Z
 e ed            Z ee      Zy)FolioReportModelfolio_reportTr   r   Nr   r   r   r   r   r   r   r   cashierr   rustdeskanydeskavailable_foliosr+   r,   r-   r   r   >  sW    "M	T	>BVC[!G6#;'MfSk"HVC[!Ggr,   r   c                       e Zd ZdZ eedd      Z e ed            Z e ed            Z	 e ed            Z
 e ed            Z ee      Zy)FolioQuantityPerCashierModeltotal_folios_per_cashierTr   r   Nr   r+   r,   r-   r   r   G  sW    .M	T	>BVC[!G6#;'MfSk"HVC[!Ggr,   r   c                       e Zd ZdZ eedd      Z ee      Z ee      Z e e	d            Z
 e e	d            Z e e             Zy)RemunerationModelremunerationsTr   r   N)r   r   r   r   r   r   r   r1   rM   r   r   rj   r   r)   r+   r,   r-   r   r   P  sQ    #M	T	>BgF3K FF3K F
#Jr,   r   c                      e Zd ZdZ eedd      Z ee      Z ee      Z ee      Z	 e e
d            Z e e
d            Z e e
d            Z ee      Z ee      Z ee      Z e e             Z e e             Zy)CashierModelcashiersTr   r   N)r   r   r   r   r   r   r   r1   r"   r   r   r   r   r   transbank_status_idvisibility_status_idr   r   r)   r*   r+   r,   r-   r   r   Y  s    M	T	>BggVC[!GVC[!GfSk"H /!'?g
#J(*%Lr,   r   c                       e Zd ZdZ eedd      Z e ed            Z e ed            Z	 e ed            Z
 e ed            Zy)LatestUpdateCashierModellatest_update_cashiersTr   r   N)r   r   r   r   r   r   r   r   r   r   r   last_updated_dater+   r,   r-   r   r   h  sN    ,M	T	>BVC[!GVC[!GfSk"Hvc{+r,   r   c                   p    e Zd ZdZ eedd      Z ee      Z ee      Z ee      Z	 e e
             Zy)TransbankTotalModeltransbank_totalTr   N)r   r   r   r   r   r   r   r1   totaltotal_ticketsr   r)   r+   r,   r-   r   r   p  s<    %M	T	>Bg7OE7OMJr,   r   c                       e Zd ZdZ eedd      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z e e             Z e e             Zy)TotalGeneralCollectionModeltotal_general_collectionsTr   N)r   r   r   r   r   r   r   r1   r   r   card_total_collectionsr   r   r)   r*   r+   r,   r-   r  r  x  s\    /M	T	>BgJ7OE#G_7OM
#J(*%Lr,   r  c                       e Zd ZdZ eedd      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z e e             Zy)TotalCollectionModeltotal_collectionsTr   N)r   r   r   r   r   r   r   r1   r   
cash_total
card_totalr   r   r)   r+   r,   r-   r  r    sO    'M	T	>BgJJJ7OM
#Jr,   r  c                       e Zd ZdZ eedd      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z ee      Z ee      Z ee      Z e e             Zy)TotalDetailCollectionModeltotal_detail_collectionsTr   N)r   r   r   r   r   r   r   r1   r   r  r  r   dtes_cash_totaldtes_card_totaldtes_total_ticketsr   r)   r+   r,   r-   r
  r
    sk    .M	T	>BgJJJ7OMWoOWoO
#Jr,   r
  c                      e Zd ZdZ eedd      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z  ee      Z! ee      Z" ee      Z# ee      Z$ ee      Z% ee      Z& ee      Z' ee      Z( ee      Z) ee      Z* e e+             Z, e e+             Z-y)DteModeldtesTr   N).r   r   r   r   r   r   r   r1   dte_version_idr   dte_type_idchip_idr#   expense_type_idpayment_type_id	reason_idr   payment_daterD   r   denied_foliocash_amountcard_amountsubtotaltaxdiscountpayment_amountr   ticket_serial_numberticket_hourticket_transaction_numberticket_dispenser_numberticket_numberticket_station_number	ticket_saticket_correlativeentrance_hour	exit_hourrj   commentpayment_commentpayment_numbersupportr   r)   r*   r+   r,   r-   r  r    sn   M	T	>BgG_NJ/KWoGwIWoOWoOwI&>L
.C7OE'?L/K/KgH
/CgHG_N7OE!'?.K &w$Wo7OM"7OvI6NMvIF^FVnGVnOF^NVnG
#J(*%Lr,   r  c                      e Zd ZdZ eed      Z ee ed            Z ee      Z	 ee      Z
 e ed            Z e ed            Z e e             Z e e             Z e e             Z e e             Zy)	UserModelusersTr   zrols.idr   N)r   r   r   r   r   r   r   r	   rol_idrD   r1   r   	full_nameemailr   phonehashed_passwordr   r)   r*   r+   r,   r-   r/  r/    s    M	T	*BGZ	23F
/Cgvc{#I6#;E46NETVnO
#J(*%Lr,   r/  c                      e Zd ZdZ eed      Z e ed            Z ee      Z	 e ed            Z
 e ed            Z ee      Z ee      Z ee      Z ee      Z e ed            Z e ed            Z ee      Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e e             Z e e             Zy)CapitulationModelcapitulationsTr   r   N)r   r   r   r   r   r   r   r   document_dater#   supplier_rutdocument_numberdocument_type_idcapitulation_type_idr1   r  user_rutr   r   r-  why_was_rejectedr  r,  payment_supportrj   r   r)   r*   r+   r,   r-   r7  r7    s    #M	T	*B6#;'MwI&+&LVC[)Og!'?gWoOfSk"H%KG_FVC[!GfSk*&+&LF3K(NVC[)OF3K F
#J(*%Lr,   r7  c                   l    e Zd ZdZ eed      Z e ed            Z e ed            Z	 ee      Z
y)TotalAcceptedCapitulationstotal_accepted_capitulationsTr   r   N)r   r   r   r   r   r   r   r   rD   r2  r   r+   r,   r-   rB  rB    s8    2M	T	*B

Cvc{#IG_Fr,   rB  c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 e e
             Z e e
             Zy)CashReserveModelcash_reservesTr   N)r   r   r   r   r   r   r   r1   r   r   r   r)   r*   r+   r,   r-   rE  rE    sG    #M	T	*BgJG_F
#J(*%Lr,   rE  c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 e e
             Z e e
             Zy)IntershipModel
intershipsTr   r   N)r   r   r   r   r   r   r   r1   r   internr   r)   r*   r+   r,   r-   rH  rH    sC     M	T	*BgF3K F
#J(*%Lr,   rH  c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 e ed            Z
 e ed            Z e e             Z e e             Zy)EmployeeIntershipModelemployees_intershipsTr   r   N)r   r   r   r   r   r   r   r1   r   rJ  observationsr-  r   r)   r*   r+   r,   r-   rL  rL    s_    *M	T	*BgF3K F&+&LVC[!G
#J(*%Lr,   rL  c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 e e
             Z e e
             Zy)EmployeeIntershipAnswerModelemployees_interships_answersTr   N)r   r   r   r   r   r   r   intership_idquestion_id	answer_idr   r)   r*   r+   r,   r-   rP  rP    sF    2M	T	*B'?L/KwI
#J(*%Lr,   rP  c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 e e
d            Z e e
d            Z e e             Z e e             Zy)IntershipAnswerModelinterships_answersTr   r   N)r   r   r   r   r   r   r   rR  rS  rT  r   observationr-  r   r)   r*   r+   r,   r-   rV  rV    sb    (M	T	*B'?L/KwI%KVC[!G
#J(*%Lr,   rV  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)ContractTypeModelcontract_typeTr   r   N)r   r   r   r   r   r   r   r   r[  r   r)   r*   r+   r,   r-   rZ  rZ  &  s9    #M	T	*B6#;'M
#J(*%Lr,   rZ  c                   @    e Zd ZdZ eed      Z e ed            Zy)ContractTypesModelcontract_typesTr   r   N)	r   r   r   r   r   r   r   r   r[  r+   r,   r-   r]  r]  .  s!    $M	T	*B6#;'Mr,   r]  c                       e Zd ZdZ eed      Z e ed            Z e ed            Z	 e e
             Z e e
             Zy)TaxModeltaxesTr   r   N)r   r   r   r   r   r   r   r   rj   r-  r   r)   r*   r+   r,   r-   r`  r`  4  sG    M	T	*BF3K FVC[!G
#J(*%Lr,   r`  c                   4    e Zd ZdZ eed      Z ee      Zy)
MonthModelmonthsTr   N)r   r   r   r   r   r   r   monthr+   r,   r-   rc  rc  =  s    M	T	*B7OEr,   rc  c                   b   e Zd ZdZ eed      Z ee      Z ee      Z e e	d            Z
 e e	d            Z e e             Z e e             Z e e             Z e e	d            Z e e	d            Z ee      Z e e	d            Z e e             Z e e             Zy)ContractModel	contractsTr   r   N)r   r   r   r   r   r   r   r1   contract_type_idr   rD   clientr   r~   r   renovation_dater   currencyr   r-  r   r)   r*   r+   r,   r-   rg  rg  C  s    M	T	*Bgg

CF3K FJdf~HTVnOVC[!GfSk"HG_FVC[!G
#J(*%Lr,   rg  c                       e Zd ZdZ eed      Z e ed            Z ee      Z	 ee      Z
 e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e e             Z e e             Zy)CustomerModel	customersTr   r   Nr   r   r   r   r   r   r   r   rD   r   r   customerr3  r4  activityr   r   r)   r*   r+   r,   r-   rn  rn  U  s    M	T	*B

CwIJfSk"H6#;E6#;EfSk"HVC[!G
#J(*%Lr,   rn  c                       e Zd ZdZ eed      Z e ed            Z ee      Z	 ee      Z
 e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e e             Z e e             Zy)Customer2Model
customers2Tr   r   Nrp  r+   r,   r-   rt  rt  d  s     M	T	*B

CwIJfSk"H6#;E6#;EfSk"HVC[!G
#J(*%Lr,   rt  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)CivilStateModelcivil_statesTr   r   N)r   r   r   r   r   r   r   r   civil_stater   r)   r*   r+   r,   r-   rw  rw  s  9    "M	T	*B%K
#J(*%Lr,   rw  c                       e Zd ZdZ eed      Z ee ed            Z e e	d            Z
 ee      Z e e             Z e e             Z e e             Zy)UniformModeluniformsTr   zuniform_types.idr   N)r   r   r   r   r   r   r   r	   uniform_type_idr   sizerD   r   delivered_dater   r)   r*   r+   r,   r-   r|  r|  {  s_    M	T	*BWj1C&DEO&+D
/CDF^N
#J(*%Lr,   r|  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)EmployeeTypeModelemployee_typesTr   r   N)r   r   r   r   r   r   r   r   employee_typer   r)   r*   r+   r,   r-   r  r    9    $M	T	*B6#;'M
#J(*%Lr,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)LetterTypeModelletter_typesTr   r   N)r   r   r   r   r   r   r   r   letter_typer   r)   r*   r+   r,   r-   r  r    rz  r,   r  c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 e ed            Z
 eeej                        Z eeej                        Zy)PayrollOtherIndicatorModelpayroll_other_indicatorsTr   r   )default)onupdateN)r   r   r   r   r   r   r   other_type_idr   other_valuerj   r   r   nowr)   r*   r+   r,   r-   r  r    sX    .M	T	*B7OM%KF3K F(,,7J(X\\:Lr,   r  c                      e Zd ZdZ eed      Z ee      Z ee ed            Z	 ee ed            Z
 e ed            Z ee ed            Z ee ed            Z ee ed	            Z ee ed
            Z ee ed            Z ee ed            Z ee      Z ee ed            Z ee ed            Z ee      Z ee      Z e e             Z e e             Z e e             Z e e             Z ee      Z ee      Z ee      Z e ed            Z  ee      Z! e ed            Z" e e#             Z$ e e#             Z%y)EmployeeLaborDatumModelemployee_labor_dataTr   zcontract_type.idr   r   
regions.idcommunes.idcivil_states.id
healths.idpentions.idjob_positions.idr   
regimes.idN)&r   r   r   r   r   r   r   rD   r	   ri  r1   r   r   r   r   civil_state_id	health_id
pention_idjob_position_idextra_health_payment_type_idr   	regime_idr#   health_payment_idr   entrance_pentionentrance_companyentrance_healthexit_companysalary	collation
locomotionextra_health_amountapv_payment_type_id
apv_amountr   r)   r*   r+   r,   r-   r  r    s   )M	T	*B
/Cgz2D'EFgz2E'FGVC[!Gw
< 89IM!:;JGZ0A%BCNw
< 89IM!:;JWj1C&DEO#)'? gz2E'FGw
< 89IwIwtvtvTVnO46NLG_FwIJ - /s$J
#J(*%Lr,   r  c                   @   e Zd ZdZ eed      Z ee      Z ee      Z ee e	d            Z
 ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z e e             Z e e             Z e e             Zy)EmployeeExtraModelemployee_extrasTr   r   Nr   r   r   r   r   r   r   rD   extreme_zone_idr	   r   young_job_status_id
be_paid_idsuplemental_health_insurance_idpensioner_iddisability_idprogressive_vacation_level_idrecognized_yearsprogressive_vacation_status_idr   progressive_vacation_dater   r)   r*   r+   r,   r-   r  r    s    %M	T	*B
/CWoOgz2E'FG /J&,Wo#'?L7OM&,Wo#$*7O!g%+G_" &tv
#J(*%Lr,   r  c                   @   e Zd ZdZ eed      Z ee      Z ee      Z ee e	d            Z
 ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z e e             Z e e             Z e e             Zy)OldEmployeeExtraModelold_employee_extrasTr   r   Nr  r+   r,   r-   r  r    s    )M	T	*B
/CWoOgz2E'FG /J&,Wo#'?L7OM&,Wo#$*7O!g%+G_" &tv
#J(*%Lr,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)RegimeModelregimesTr   r   N)r   r   r   r   r   r   r   r   regimer   r)   r*   r+   r,   r-   r  r    s9    M	T	*BF3K F
#J(*%Lr,   r  c                      e Zd ZdZdddiiZ eed      Z ee      Z e e	d            Z
 e e	d            Z e e	d            Z e e	d            Z e e	d            Z ee      Z e e	d            Z ee      Z e e	d            Z e e	d            Z e e	d            Z e e             Z e e	d            Z e e	d            Z ee ed	            Z e e	d            Z ee ed
            Z e e	d            Z e e	d            Z ee ed            Z e e	d            Z  ee ed            Z! e e	d            Z" ee ed            Z# e e	d            Z$ ee ed            Z% e e	d            Z& ee ed            Z' e e	d            Z( ee ed            Z) e e	d            Z* ee ed            Z+ ee ed            Z, ee ed            Z- ee      Z. ee ed            Z/ e e             Z0 e e             Z1 e e             Z2 e e             Z3 ee      Z4 ee      Z5 ee      Z6 e e	d            Z7 e e	d            Z8 ee ed            Z9 e e	d            Z: ee      Z; ee      Z< ee      Z= ee      Z> ee      Z? ee      Z= ee      Z@ ee      ZA ee      ZB e e             ZC ee      Z@y)EmployeeViewModelemployee_detailsinfois_viewTr   r   r   r   zcontract_types.idr   r  r  r  r  r  r  zextreme_zones.idr   r  zhealth_payments.idzapv_payment_types.idN)Dr   r   r   r   __table_args__r   r   r   rD   r   r   r   r   r   nicknamer   r]   r   r   r   r   r   r   r   r   r	   ri  r[  r1   r   r   r   r   r   communer  ry  r  healthr  r   r  job_positionr  r   r  r#   r  r  r  r  r  r  r  r  company_emailr  r  r  r  r  r  r  r  r  r  r  r  r+   r,   r-   r  r    s4   &My$/0N	T	*B
/Cr
#J6#;EVC[)OVC[)OfSk"HwIF3K FG_N%KF3K(Nvc{#ItvIVC[!Gvc{#Igz2E'FG6#;'Mgz2E'FG6#;'MVC[!Gw
< 89IF3K FM!:;JVC[!GGZ0A%BCN%Kw
< 89IF3K FM!:;JVC[!GWj1C&DEO&+&LWj1C&DEOgz2E'FGw
< 89IwIw
3G(HItvtvTVnO46NLG_FwIJ6#;'M - *5K*LMs$J /J&,Wo#'?L7OM&,Wo#$*7O!g%+G_" &tv$*7O!r,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)HonoraryReasonModelhonorary_reasonsTr   r   N)r   r   r   r   r   r   r   r   honorary_reasonr   r)   r*   r+   r,   r-   r  r  0  s9    &M	T	*BVC[)O
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 e e
             Z e e
             Zy)CommuneModelcommunesTr   r   N)r   r   r   r   r   r   r   r   r   r  r   r)   r*   r+   r,   r-   r  r  8  sB    M	T	*BwIVC[!G
#J(*%Lr,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)AlertTypeModelalert_typesTr   r   N)r   r   r   r   r   r   r   r   
alert_typer   r)   r*   r+   r,   r-   r  r  A  s9    !M	T	*Bs$J
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 e e
             Z e e
             Zy)
AlertModelalertsTr   N)r   r   r   r   r   r   r   alert_user_idalert_type_idr#   r   r)   r*   r+   r,   r-   r  r  I  sD    M	T	*B7OM7OMwIJ$&>Lr,   r  c                   h    e Zd ZdZ eed      Z ee      Z e e             Z	 e e             Z
y)IndicatorTypeindicator_typesTr   N)r   r   r   r   r   r   r   indicator_typer   r)   r*   r+   r,   r-   r  r  S  s4    %M	T	*BG_N
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z e e	d            Z
 e e             Z e e             Zy)PayrollIndicatorModelpayroll_indicatorsTr   r   N)r   r   r   r   r   r   r   indicator_idindicator_type_idr   rj   r   r)   r*   r+   r,   r-   r  r  [  sL    (M	T	*B'?LwF3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z	 e e
d            Z e e             Z e e             Zy)PayrollUfIndicatorModelpayroll_uf_indicatorsTr   r   N)r   r   r   r   r   r   r   r
   uf_value_current_monthuf_value_last_monthr   rj   r   r)   r*   r+   r,   r-   r  r  e  sM    +M	T	*B#E] -F3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z	 e e
d            Z e e             Z e e             Zy)PayrollUtmUtaIndicatorModelpayroll_utm_uta_indicatorsTr   r   N)r   r   r   r   r   r   r   r
   utm_value_current_monthuta_value_current_monthr   rj   r   r)   r*   r+   r,   r-   r  r  o  sM    0M	T	*B$Um$UmF3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 e e
d            Z e e             Z e e             Zy)%PayrollTaxableIncomeCapIndicatorModel%payroll_taxable_income_cap_indicatorsTr   r   N)r   r   r   r   r   r   r   afpipsunemploymentr   rj   r   r)   r*   r+   r,   r-   r  r  y  sT    ;M	T	*B
/C
/C'?LF3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z	 ee      Z
 ee      Z e ed            Z e e             Z e e             Zy)(PayrollMiniumTaxableIncomeIndicatorModel(payroll_minium_taxable_income_indicatorsTr   r   N)r   r   r   r   r   r   r   r
   dependent_independent_workersunder_18_over_65particular_homeno_remunerationsr   rj   r   r)   r*   r+   r,   r-   r  r    s`    >M	T	*B$*5M!e}UmOe}F3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z	 e e
d            Z e e             Z e e             Zy))PayrollVoluntaryPrevitionalIndicatorModel(payroll_voluntary_previtional_indicatorsTr   r   N)r   r   r   r   r   r   r   r
   !voluntary_pension_savings_monthly voluntary_pension_savings_annualr   rj   r   r)   r*   r+   r,   r-   r  r    sM    >M	T	*B(.u%'-e}$F3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z e e	d            Z
 e e             Z e e             Zy)"PayrollAgreedDepositIndicatorModel!payroll_agreed_deposit_indicatorsTr   r   N)r   r   r   r   r   r   r   r
   agreed_depositr   rj   r   r)   r*   r+   r,   r-   r  r    sB    7M	T	*BE]NF3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z	 ee      Z
 e ed            Z e e             Z e e             Zy)(PayrollUmploymentInsuranceIndicatorModel'payroll_umployment_insurance_indicatorsTr   r   N)r   r   r   r   r   r   r   ri  r
   workeremployerr   rj   r   r)   r*   r+   r,   r-   r  r    sU    =M	T	*BgE]Fe}HF3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z	 ee      Z
 ee      Z e ed            Z e e             Z e e             Zy)PayrollAfpQuoteIndicatorModelpayroll_afp_quote_indicatorsTr   r   N)r   r   r   r   r   r   r   r  r
   dependent_rate_afpdependent_sisindependent_rate_afpr   rj   r   r)   r*   r+   r,   r-   r  r    s_    2M	T	*BJ5MM!%=F3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Z e e	             Z e e	             Zy)PayrollPeriodModelpayroll_periodsTr   r   N)r   r   r   r   r   r   r   r   rj   r   openedclosedr)   r*   r+   r,   r-   r  r    sQ    %M	T	*BF3K FHJFHJF
#J(*%Lr,   r  c                   $   e Zd ZdZ eed      Z ee      Z e ed            Z	 e ed            Z
 ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z ee      Z ee      Z ee      Z e ed            Z e ed            Z e e             Z e e             Z y)PayrollEmployeeModelpayroll_employeesTr   r   N)!r   r   r   r   r   r   r   rD   r   r   rj   ri  r1   r  r  r   r  r  r  r  r   r   r   r  r  r  r  r  r  r  r   r)   r*   r+   r,   r-   r  r    s&   'M	T	*B
/Cs$JF3K FggwIJgwIw#)'?  /6#;EVC[)OVC[)OfSk*&+&LG_FwIJ -s$J
#J(*%Lr,   r  c                   ~    e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 ee      Z
 e e             Zy)DteSettingModeldte_settingsTr   N)r   r   r   r   r   r   r   folio_quantity_to_sendfolio_quantity_sentfolio_quantity_limitstatusr   last_folio_sent_dater+   r,   r-   r  r    sG    "M	T	*B#G_ /!'?G_F!(*-r,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z ee      Z ee      Z e e             Z e e             Z e e             Zy)DteBackgroundModeldte_backgroundsTr   N)r   r   r   r   r   r   r   r1   r   status_assigned_idstatus_used_idstatus_sii_idtrack_idr   r   sii_dater)   r*   r+   r,   r-   r"  r"    sx    %M	T	*BgJG_N7OMgH7OEhj!H
#J(*%Lr,   r"  c                   P    e Zd ZdZ eed      Z ee      Z e ed            Z	y)PayrollCalculatedEmployeeModelpayroll_calculated_employeesTr   r   N)
r   r   r   r   r   r   r   employee_quantityr   rj   r+   r,   r-   r*  r*    s+    2M	T	*BwF3K Fr,   r*  c                       e Zd ZdZ edddd      fZ eed      Z ee      Z	 ee      Z
 ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z e e             Z e e             Zy	)
CollectionModelcollectionsr1   r   r)   "uk_collections_branch_cashier_date)nameTr   N)r   r   r   r   r   r  r   r   r   r1   r   cash_gross_amountcash_net_amountcard_gross_amountcard_net_amountsubscribersr   r   r)   r   r*   r+   r,   r-   r.  r.    s    !M+\<A	CN
 
T	*BgJwWoOwWoO/K7OMJ(*%Lr,   r.  c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Zy)DepositModeldepositsTr   N)r   r   r   r   r   r   r   r1   r  collection_idr#   deposited_amountr,  collection_amountr   collection_dater-  r   r)   r*   r+   r,   r-   r8  r8    sy    M	T	*BgWoO7OMwIgG_NwTlOTlGJ$<Lr,   r8  c                      e Zd ZdZ eed      Z ee      Z e ed            Z	 e ed            Z
 e ed            Z e ed            Z e ed            Z ee      Z ee      Z ee      Z ee      Z e ed            Z ee      Z ee      Z ee      Z ee      Z e ed            Z e ed            Z e ed            Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z  ee      Z! ee      Z" ee      Z# ee      Z! ee      Z$ ee      Z% ee      Z& ee'      Z( ee      Z) ee      Z* e ed            Z+ e ed            Z,y)SocialLawModelsocial_lawsTr   r   N)-r   r   r   r   r   r   r   rD   r   dvr   r   r   r]   r   payment_typeperiod_sinceperiod_untilr  r  working_days	line_typemovement_code
date_since
date_untilfamily_allowance_sectionnumber_simple_loadsnumber_maternal_loadsnumber_invalid_loadshousehold_allowanceretroactive_family_allowancereimbursement_family_chargesyoung_job_statuspention_codepention_taxable_incomepention_mandatory_contributiondisability_insurance_quotepention_voluntary_savings!pention_substitute_taxable_incomer
   substitute_agreed_rate$substitute_compensation_contributionsubstitute_period_numberssubstitute_period_sincesubstitute_period_untilr+   r,   r-   r?  r?  $  s   !M	T	*B
/C	s	BVC[)OVC[)O6#;EF3K F/K'?L'?L'?LF3K F7OM'?LwI7OMs$Js$J%fSk2 /"7O!'? / /#)'? #)'? g'?L#G_%+G_"'?L!' &w(.w%#E]+1'?( &w$VC[1$VC[1r,   r?  c                       e Zd ZdZ eed      Z ee      Z ee      Z	 ee      Z
 ee      Z e ed            Z e e             Z e e             Zy)%PayrollFamilyAsignationIndicatorModel$payroll_family_asignation_indicatorsTr   r   N)r   r   r   r   r   r   r   
section_idr
   r   minimum_value_ratetop_value_rater   rj   r   r)   r*   r+   r,   r-   r^  r^  O  s^    :M	T	*BJE]FG_NF3K F
#J(*%Lr,   r^  c                       e Zd ZdZ eed      Z e ed            Z e ed            Z	 e ed            Z
 e ed            Z e ed            Z e e             Z e e             Zy)PayrollSecondCategoryTaxModelpayroll_second_category_taxesTr   r   N)r   r   r   r   r   r   r   r   rj   sinceuntilfactorr  r   r)   r*   r+   r,   r-   rd  rd  [  sq    3M	T	*BF3K F6#;E6#;EF3K FfSk"H
#J(*%Lr,   rd  c                       e Zd ZdZ eed      Z ee      Z ee      Z	 ee      Z
 ee      Z e ed            Z e e             Z e e             Zy)#PayrollHeavyDutyQuoteIndicatorModel#payroll_heavy_duty_quote_indicatorsTr   r   N)r   r   r   r   r   r   r   duty_type_idr
   r  r
  r	  r   rj   r   r)   r*   r+   r,   r-   rj  rj  g  s]    9M	T	*B'?L%=Le}HE]FF3K F
#J(*%Lr,   rj  c                       e Zd ZdZ eed      Z e ed            Z e ed            Z	 e ed            Z
 e e             Z e e             Zy)PayrollCcafIndicatorModelpayroll_ccaf_indicatorsTr   r   N)r   r   r   r   r   r   r   r   ccaffonasarj   r   r)   r*   r+   r,   r-   rn  rn  s  sU    -M	T	*B&+DF3K FF3K F
#J(*%Lr,   rn  c                       e Zd ZdZ eed      Z e ed            Z e ed            Z	 e e
             Z e e
             Zy)HrSettingModelhr_settingsTr   r   N)r   r   r   r   r   r   r   r   percentage_honorary_billapigetaway_tokenr   r)   r*   r+   r,   r-   rs  rs  }  sI    !M	T	*B%fSk2fSk*
#J(*%Lr,   rs  c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 e e
d            Z e e             Zy)PayrollManualInputModelpayroll_manual_inputsTr   r   N)r   r   r   r   r   r   r   payroll_item_idrD   r   r   rj   r   r)   r+   r,   r-   rx  rx    sH    +M	T	*BWoO
/CG_FF3K F
#Jr,   rx  c                   D    e Zd ZdZ eed      Z ee      Z ee      Zy)HrFinalDayMonthModelhr_final_day_monthsTr   N)	r   r   r   r   r   r   r   end_dayadjustment_dayr+   r,   r-   r|  r|    s%    )M	T	*BWoGG_Nr,   r|  c                      e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z e ed            Z e ed            Z e ed            Z e e             Z e e             Z ee      Z e ed            Z e e             Z e e             Zy)HonoraryModel
honorariesTr   r   N)r   r   r   r   r   r   r   honorary_reason_idr1   foreigner_idbank_idaccount_type_idschedule_idr   r   requested_byr#   employee_to_replacereplacement_employee_rutr   replacement_employee_full_namer   account_numberr   r~   r   r   rX  r   r)   r*   r+   r,   r-   r  r    s     M	T	*Bg'?LWoGWoO/KwIJ'?LwI /%g%+F3K%8"VC[!GF3K(NJdf~HG_F%K
#J(*%Lr,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)UniformTypeModeluniform_typesTr   r   N)r   r   r   r   r   r   r   r   uniform_typer   r)   r*   r+   r,   r-   r  r    r   r,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)SegmentModelsegmentsTr   r   N)r   r   r   r   r   r   r   r   segmentr   r)   r*   r+   r,   r-   r  r    s9    M	T	*BVC[!G
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z e ed            Z e ed            Z	 e e
             Z e e
             Zy)JobPositionModeljob_positionsTr   r   N)r   r   r   r   r   r   r   r   r  	functionsr   r)   r*   r+   r,   r-   r  r    sG    #M	T	*B&+&Lvc{#I
#J(*%Lr,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)PatologyTypeModelpatology_typesTr   r   N)r   r   r   r   r   r   r   r   patology_typer   r)   r*   r+   r,   r-   r  r    r  r,   r  c                       e Zd ZdZ eed      Z e ed            Z ee      Z	 ee      Z
 e e             Z e e             Zy)DocumentTypeModeldocument_typesTr   r   N)r   r   r   r   r   r   r   r   document_typedocument_group_idorderr   r)   r*   r+   r,   r-   r  r    sL    $M	T	*B6#;'Mw7OE
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z ee      Z ee      Z ee      Z ee      Z e e             Z e e             Zy)EndDocumentModelend_documentsTr   N)r   r   r   r   r   r   r   rc   	causal_idrD   fertility_proportional_daysvoluntary_indemnityindemnity_years_servicesubstitute_compensationfertility_proportionalr   r   r)   r*   r+   r,   r-   r  r    s    #M	T	*B!'?wI
/C"(/ /#G_$Wo#G_7OE
#J(*%Lr,   r  c                   Z    e Zd ZdZ eed      Z e ed            Z e e	             Z
y)FamilyTypeModelfamily_typesTr   r   N)r   r   r   r   r   r   r   r   family_typer   r)   r+   r,   r-   r  r    s-    "M	T	*B%K
#Jr,   r  c                      e Zd ZdZ eed      Z ee ed            Z ee      Z	 ee ed            Z
 ee      Z e ed            Z e ed            Z e ed            Z e e             Z ee      Z e e             Zy)FamilyCoreDatumModelfamily_core_dataTr   zfamily_types.idz
genders.idr   N)r   r   r   r   r   r   r   r	   family_type_idemployee_rutr   rD   r   r   r   r   r   r   r   r-  r)   r+   r,   r-   r  r    s    &M	T	*BGZ0A%BCN'?Lw
< 89I
/C6#;EVC[)OVC[)Oxz"ITlG
#Jr,   r  c                   
   e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 e e
d            Z e e
d            Z e e
d            Z e e
d            Z e e
d            Z ee      Z e e             Zy)OldFamilyCoreDatumModelold_family_core_dataTr   r   N)r   r   r   r   r   r   r   r  r  r   r   rD   r   r   r   r   r   r-  r   r)   r+   r,   r-   r  r    s    *M	T	*BG_N'?LwI

C6#;EVC[)OVC[)Ovc{#ITlG
#Jr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z e e	             Z
 e e	             Z ee      Z ee      Z e ed            Z e e             Z e e             Zd Zy)VacationModel	vacationsTr   r   c                 P   | j                   | j                  t        | j                        t        | j                        t        | j                        | j
                  | j                  t        | j                        t        | j                        t        | j                        d
S )N)
r   rD   rf  rf  rg  daysno_valid_daysr-  r)   r*   )
r   rD   strrf  rg  r  r  r-  r)   r*   r   s    r-   to_dictzVacationModel.to_dict  sq    ''88___II!//4<<(doo. 1 12
 	
r,   N)r   r   r   r   r   r   r   rc   rD   r   rf  rg  r  r  r   r-  r   r)   r*   r  r+   r,   r-   r  r    sy    M	T	*B!'?
/C46NE46NE'?D7OMVC[!G
#J(*%L
r,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)SliderModelsliderTr   r   Nr   r   r   r   r   r   r   r   r-  r   r)   r*   r+   r,   r-   r  r  ,  s9    M	T	*BVC[!G
#J(*%Lr,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)	LogoModellogoTr   r   Nr  r+   r,   r-   r  r  3  s9    M	T	*BVC[!G
#J(*%Lr,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)AboutUsModelabout_usTr   r   N)r   r   r   r   r   r   r   r   textr   r)   r*   r+   r,   r-   r  r  :  s9    M	T	*B&+D
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z e ed            Z e ed            Z	 e ed            Z
 e e             Z e e             Zy)ContactModelcontactTr   r   r   N)r   r   r   r   r   r   r   r   r   r   r3  r   r)   r*   r+   r,   r-   r  r  A  sU    M	T	*BVC[!Gvc{#I6#;E
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z e ed            Z e ed            Z	 e ed            Z
 e e             Z e e             Zy)	BlogModelblogTr   r   r   N)r   r   r   r   r   r   r   r   r   r   r   r   r)   r*   r+   r,   r-   r  r  J  sU    M	T	*B6#;E%KVC[!G
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z e ed            Z e ed            Z	 e ed            Z
 e ed            Z e ed            Z e e             Z e e             Zy)PossibleEmployeesModelpossible_employeesTr   r   r   N)r   r   r   r   r   r   r   r   rD   r   r   r   r   r   r)   r*   r+   r,   r-   r  r  S  sq    (M	T	*B

C6#;EVC[)OVC[)Ovc{#I
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z e ed            Z e ed            Z	 e e
             Z e e
             Zy)FrecuentQuestionModelfrecuent_questionTr   r   r   N)r   r   r   r   r   r   r   r   questionanswerr   r)   r*   r+   r,   r-   r  r  ^  sG    'M	T	*BfSk"HF3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z e e	             Z
 e e	             Z ee      Z ee      Z e ed            Z e e             Z e e             Zy)ProgressiveVacationModelprogressive_vacationsTr   r   Nr   r   r   r   r   r   r   rc   rD   r   rf  rg  r  r  r   r-  r   r)   r*   r+   r,   r-   r  r  g  st    +M	T	*B!'?
/C46NE46NE'?D7OMVC[!G
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z e e	d            Z
 ee      Z e e             Z e e             Zy)PayrollItemValueModelpayroll_item_valuesTr   r   N)r   r   r   r   r   r   r   item_idrD   r   rj   r   r   r)   r*   r+   r,   r-   r  r  u  sT    )M	T	*BWoG
/CF3K FG_F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 e ed            Z
 e e             Z e e             Zy)PayrollMonthIndicatorModelpayroll_month_indicatorsTr   r   N)r   r   r   r   r   r   r   month_idr   month_valuerj   r   r)   r*   r+   r,   r-   r  r    sP    .M	T	*BgH%KF3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 ee      Z
 e ed            Z e ed            Z ee      Z e e             Z e e             Zy)PayrollItemModelpayroll_itemsTr   r   N)r   r   r   r   r   r   r   item_type_idclassification_idorder_iddisabled_idr   itemsalary_settlement_namesalary_settlement_location_idr   r)   r*   r+   r,   r-   r  r    sw    #M	T	*B'?LwgH/K&+D#F3K0$*7O!
#J(*%Lr,   r  c                      e Zd ZdZ eed      Z e ed            Z e ed            Z	 e ed            Z
 e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z ee      Z e e             Zy)ComplaintModel
complaintsTr   r   N)r   r   r   r   r   r   r   r   relationshipincident_placecomplaint_type	anonymousincident_dateincident_place_detail	knowledgeidentifyr-  r   passwordr3  r  r   r)   r+   r,   r-   r  r    s     M	T	*B&+&LF3K(NF3K(Nvc{#I6#;'M"6#;/vc{#IfSk"HVC[!G%KfSk"H6#;EG_F
#Jr,   r  c                   0   e Zd ZdZ eed      Z ee      Z ee ed            Z	 ee ed            Z
 e ed            Z ee      Z e ed            Z e e             Z e e             Z ee      Z e e             Z e e             Zy)MedicalLicenseModelmedical_licensesTr   zmedical_license_types.idzpatology_types.idr   N)r   r   r   r   r   r   r   rc   r	   medical_license_type_idpatology_type_idr   rj   rD   r   r   rf  rg  r  r   r)   r*   r+   r,   r-   r  r    s    &M	T	*B!'?$Wj9S.TUgz2E'FGF3K F
/C6#;E46NE46NE'?D
#J(*%Lr,   r  c                      e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 e e
d            Z ee      Z e e
d            Z e e             Z e e             Z ee      Z e e             Z e e             Zy)OldMedicalLicenseModelold_medical_licensesTr   r   N)r   r   r   r   r   r   r   rc   r  r   r   rj   rD   r   r   rf  rg  r  r   r)   r*   r+   r,   r-   r  r    s    *M	T	*B!'?$W.gF3K F
/C6#;E46NE46NE'?D
#J(*%Lr,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)RolModelrolsTr   r   N)r   r   r   r   r   r   r   r   rolr   r)   r*   r+   r,   r-   r  r    s9    M	T	*B

C
#J(*%Lr,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)PrincipalModel
principalsTr   r   N)r   r   r   r   r   r   r   r   	principalr   r)   r*   r+   r,   r-   r	  r	    s9     M	T	*Bvc{#I
#J(*%Lr,   r	  c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 e ed            Z
 e e             Z e e             Zy)CarbonMonoxideModelcarbon_monoxidesTr   r   N)r   r   r   r   r   r   r   r1   r   measure_valuer-  r   r)   r*   r+   r,   r-   r  r    sQ    &M	T	*Bg6#;'MVC[!G
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 e ed            Z
 ee      Z e ed            Z e ed            Zy)BankStatementModelbank_statementsTr   r   N)r   r   r   r   r   r   r   bank_statement_type_idr   rD   deposit_numberr   rj   deposit_dater+   r,   r-   r  r    s^    %M	T	*B#G_

CF3K(NG_FF3K F&+&Lr,   r  c                      e Zd ZdZ eed      Z ee      Z e ed            Z	 e ed            Z
 e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e e             Zy)TransbankStatementModeltransbank_statementsTr   r   N)r   r   r   r   r   r   r   r1   r   original_datecodebranch_office_name	sale_typerB  card_numbersale_descriptionr   value_1value_2value_3value_4r   r)   r+   r,   r-   r  r    s    *M	T	*Bg6#;'M&+Ds,vc{#I&+&L%KfSk*F3K FVC[!GVC[!GVC[!GVC[!G
#Jr,   r  c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 e e
             Z e e
             Zy)%BranchOfficesTransbankStatementsModelbranch_offices_transbanksTr   r   N)r   r   r   r   r   r   r   r1   r   transbank_coder   r)   r*   r+   r,   r-   r$  r$    sC    /M	T	*BgF3K(N
#J(*%Lr,   r$  c                   (   e Zd ZdZ eed      Z e ed            Z e ed            Z	 ee      Z
 e ed            Z ee      Z ee      Z e ed            Z ee      Z e ed            Z e ed            Z e ed            Zy)(ComparationPendingDtesBankStatementModel(comparation_pending_dtes_bank_statementsTr   r   N)r   r   r   r   r   r   r   r   rD   rq  r   r   r   r  bank_statement_periodbank_statement_amountbank_statement_rutr  r  r+   r,   r-   r(  r(    s    >M	T	*B

CfSk"H7OE6#;'MG_F#G_"6#;/"7Os,F3K(N&+&Lr,   r(  c                   4   e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 ee      Z
 e ed            Z ee      Z ee      Z ee      Z ee      Z e ed            Z ee      Z ee      Z e ed            Z e ed            Zy),ComparationPendingDepositsBankStatementModel,comparation_pending_deposits_bank_statementsTr   r   N)r   r   r   r   r   r   r   r1   r  r:  
deposit_idr   r   r#   r,  r<  r;  r=  r  r+  r,  r  r+   r,   r-   r.  r.    s    BM	T	*BgWoO7OMJ6#;'MwIG_NwgVC[)O#G_"7Os,F3K(Nr,   r.  c                   4   e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 ee      Z
 ee      Z ee      Z ee      Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e ed            Z e e             Z e e             Zy)SinisterModel	sinistersTr   r   N)r   r   r   r   r   r   r   r1   r#   sinister_type_idprotected_area_idregistered_event_idnotified_security_iddenounced_authorities_idr   sinister_date
client_rutclient_nameclient_last_nameclient_emailclient_phonebrandmodelyearpatentcolorr   r-  r   r)   r*   r+   r,   r-   r2  r2  /  s'   M	T	*BgwIgw /!'?%g6#;'Ms$J%KfSk*&+&L&+&L6#;E6#;E&+DF3K F6#;E%KVC[!G
#J(*%Lr,   r2  c                   D    e Zd ZdZ eed      Z ee      Z ee      Z	y)WhatsappTemplateModelwhatsapp_templatesTr   N)
r   r   r   r   r   r   r   r   r   templater+   r,   r-   rE  rE  J  s%    (M	T	*B4LEd|Hr,   rE  c                       e Zd ZdZ eed      Z ee      Z e e             Z	 e e
             Z e e
             Zy)MaintenanceModelmaintenancesTr   N)r   r   r   r   r   r   r   r1   r   maintenance_dater   r)   r*   r+   r,   r-   rI  rI  Q  sA    "M	T	*Bgdf~
#J(*%Lr,   rI  c                       e Zd ZdZ eed      Z ee      Z ee      Z e e	d            Z
 e e             Z e e             Zy)MaintenanceDataModelmaintenance_dataTr   r   N)r   r   r   r   r   r   r   maintenance_idfile_numberr   r-  r   r)   r*   r+   r,   r-   rM  rM  Z  sK    &M	T	*BG_N/KVC[!G
#J(*%Lr,   rM  c                       e Zd ZdZ eed      Z ee      Z ee      Z	 ee      Z
 ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z e e             Z e e             Zy)SettingModelsettingsTr   N)r   r   r   r   r   r   r   r   capitulation_close_periodcapitulation_open_periodhonorary_open_periodhonorary_close_perioddropbox_tokenfacebook_tokensimplefactura_token	caf_limitru  rv  r   r)   r*   r+   r,   r-   rR  rR  d  s    M	T	*B &t%d|!$<"4L4LMD\N ,wI%d|d|
#J(*%Lr,   rR  c                   x    e Zd ZdZ eed      Z ee      Z ee      Z e e	             Z
 e e	             Zy)AlertUserModelalert_usersTr   N)r   r   r   r   r   r   r   r  user_idr   r)   r*   r+   r,   r-   r]  r]  u  s=    !M	T	*B7OMWoG
#J(*%Lr,   r]  c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 ee      Z
 ee      Z e e             Z e e             Zy)HealthModelhealthsTr   r   N)r   r   r   r   r   r   r   health_remuneration_coder   r  rD   
social_lawr   r)   r*   r+   r,   r-   ra  ra  ~  sU    M	T	*B%gF3K F
/CJ
#J(*%Lr,   ra  c                       e Zd ZdZ eed      Z ee ed            Z ee      Z	 ee      Z
 ee      Z ee      Z e e             Z e e             Zy)EmployeeBankAccountModelemployees_bank_accountsTr   zbanks.idN)r   r   r   r   r   r   r   r	   r  r  r#   rD   r  r   r)   r*   r+   r,   r-   rf  rf    s`    -M	T	*BWj45GWoOwI
/CG_N
#J(*%Lr,   rf  c                       e Zd ZdZ eed      Z ee      Z ee ed            Z	 ee      Z
 ee      Z e ed            Z e ed            Z e e             Z e e             Zy)DocumentEmployeeModeldocuments_employeesTr   zdocument_types.idr   N)r   r   r   r   r   r   r   r#   r	   r<  old_document_status_idrD   r   rj   r-  r   r)   r*   r+   r,   r-   ri  ri    sv    )M	T	*BwIgz2E'FG#G_
/CF3K FVC[!G$J(*%Lr,   ri  c                   x    e Zd ZdZ eed      Z ee      Z ee      Z e e	             Z
 e e	             Zy)DocumentEmployeeSignatureModeldocuments_employees_signaturesTr   N)r   r   r   r   r   r   r   rc   rD   r   r)   r*   r+   r,   r-   rm  rm    s>    4M	T	*B!'?
/C$J(*%Lr,   rm  c                       e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 e e
d            Z e e             Z e e             Zy)OldDocumentEmployeeModelold_documents_employeesTr   r   N)r   r   r   r   r   r   r   r#   r<  rD   r   r-  r   r)   r*   r+   r,   r-   rp  rp    sU    -M	T	*BwIg
/CVC[!G
#J(*%Lr,   rp  c                       e Zd ZdZ eed      Z ee      Z ee      Z e e	             Z
 e e	             Z ee      Z ee      Z e ed            Z e e             Z e e             Zy)OldVacationModelold_vacationsTr   r   Nr  r+   r,   r-   rs  rs    st    #M	T	*B!'?
/C46NE46NE'?D7OMVC[!G
#J(*%Lr,   rs  c                      e Zd ZdZ eed      Z ee      Z e ed            Z	 e ed            Z
 e ed            Z e ed            Z ee      Z ee      Z e ed            Z e ed            Z e e             Z e ed            Z e ed            Z e e             Z e e             Zy)OldEmployeeModelold_employeesTr   r   r   r   N)r   r   r   r   r   r   r   rD   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r)   r*   r+   r,   r-   rv  rv    s    #M	T	*B
/Cr
#J6#;EVC[)OVC[)OwIG_NF3K(Nvc{#ItvIVC[!Gvc{#I
#J(*%Lr,   rv  c                   $   e Zd ZdZ eed      Z ee      Z ee      Z ee      Z	 e e
d            Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z ee      Z e e             Z e e             Z e e             Z e e             Z ee      Z ee      Z ee      Z e e
d            Z e e
d            Z  e e!             Z" e e!             Z#y)OldEmployeeLaborDatumModelold_employee_labor_dataTr   r   N)$r   r   r   r   r   r   r   rD   ri  r1   r   r   r   r   r  r  r  r  r   r  r#   r  r  r   r  r  r  r  r  r  r  r  r  r   r)   r*   r+   r,   r-   ry  ry    s#   -M	T	*B
/Cg'gVC[!GwIJG_NwIJWoOgwIwIw /tvtvTVnO46NLG_FwIJ -s$J
#J(*%Lr,   ry  c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 ee      Z
 e ed            Z e e             Z e e             Zy)PatentModelpatentsTr   r   N)r   r   r   r   r   r   r   r1   r   semesterrA  r-  r   r)   r*   r+   r,   r-   r|  r|    sZ    M	T	*BgfSk"H'?DVC[!G
#J(*%Lr,   r|  c                       e Zd ZdZ eed      Z ee      Z ee      Z e e	d            Z
 ee      Z e e             Z e e             Zy)ClockUserModelclock_usersTr   r   N)r   r   r   r   r   r   r   uidrD   r   r2  	privileger   r)   r*   r+   r,   r-   r  r    sT    !M	T	*B
/C
/Cvc{#IwI
#J(*%Lr,   r  c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)MedicalLicenseTypeModelmedical_license_typesTr   r   N)r   r   r   r   r   r   r   r   medical_license_typer   r)   r*   r+   r,   r-   r  r    s:    +M	T	*B!&+.
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee ed            Z e e	d            Z
 e e             Z e e             Zy)CausalModelcausalsTr   zend_document_statuses.idr   N)r   r   r   r   r   r   r   r	   end_document_status_idr   causalr   r)   r*   r+   r,   r-   r  r    sL    M	T	*B#GZ8R-STF3K F
#J(*%Lr,   r  c                       e Zd ZdZ eed      Z ee      Z ee      Z e e	d            Z
 e e	d            Z e e             Z e e             Zy)SinisterReviewModelsinisters_reviewsTr   r   N)r   r   r   r   r   r   r   sinister_idsinister_step_type_idr   review_descriptionr-  r   r)   r*   r+   r,   r-   r  r    s[    'M	T	*B/K"7Os,VC[!G
#J(*%Lr,   r  N)app.backend.db.databaser   
sqlalchemyr   r   r   r   r   r	   r
   r   r   r   r   r   r   r/   rA   rG   rJ   rT   rW   r[   r`   rl   ro   rv   r|   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r  r  r
  r  r/  r7  rB  rE  rH  rL  rP  rV  rZ  r]  r`  rc  rg  rn  rt  rw  r|  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r"  r*  r.  r8  r?  r^  rd  rj  rn  rs  rx  r|  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r	  r  r  r  r$  r(  r.  r2  rE  rI  rM  rR  r]  ra  rf  ri  rm  rp  rs  rv  ry  r|  r  r  r  r  r+   r,   r-   <module>r     s   ( { { { { & &*&t &,#D ##T ##t #'t '& &&$ &&T &"$ $$d $4 
&4 
&
t 
$
&4 
&
 
"&t &&d &	&t 	&&$ &3T 3&D &(& &2&D && &'t ''4 '$ $&4 &,t , $  	&$ 	&$4 $$ $(&t (&T& && &0 &t &&T &	&T 	&&4 &
&4 
&& &( (&t & &D &$&D &&T &&d &	&4 	&& &&d &; ;&d &@& &(&D &&&$ &?4 ?4B&$ &&4 &&T &" "&D &&D &&d &&$ &	&D 	&
&t 
&& && &	&t 	&
&D 
&& &&4 &:.d .& &!T !&d && 4   )2T )2V
&D 
&
&D 
&
&$ 
&& &&T &$d $%4 %&D &4&t &&4 &&t && && &&t &$d $$4 $$d $
D 
8&$ && &&4 &&4 && &
&T 
&&D &&t &	&D 	&& &&t &$T $&&$ & &T & &t &&T &&$ &	' 	'$d $&&D &'t ' )4 )&&D &6D &t &&4 &&4 &"&T &	&$ 	&
&t 
&&D &&T &	&t 	&&t &&t &&& &>	&$ 	&	&T 	&&d &&$ &	&$ 	&r,   