
    h                     t   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 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      Z/ G dH dIe      Z0 G dJ dKe      Z1 G dL dMe      Z2 G dN dOe      Z3 G dP dQe      Z4 G dR dSe      Z5 G dT dUe      Z6 G dV dWe      Z7 G dX dYe      Z8 G dZ d[e      Z9 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      Z@ G dj dke      ZA G dl dme      ZB G dn doe      ZC G dp dqe      ZD G dr dse      ZE G dt due      ZF G dv dwe      ZG G dx dye      ZH G dz d{e      ZI G d| d}e      ZJ G d~ de      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      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  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)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     A/var/www/intrajisbackend.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,   r@   r@   0   s/    M	T	*B

CfSk"Hr+   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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,   rE   rE   7   so    #M	T	*B!'s, /&+&Ls,'?D'?Lr+   rE   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   rM   r*   r+   r,   rO   rO   D   s!    #M	T	*B&+&Lr+   rO   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,   rR   rR   J   s9    M	T	*B&+D
#J(*%Lr+   rR   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,   rV   rV   R   sG    M	T	*BF3K FVC[)O
#J(*%Lr+   rV   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_idrB   r   dater   total_hoursstartendweekweek_dayperiodr   r(   r)   r*   r+   r,   r[   r[   [   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   rB   r   re   r   r(   r*   r+   r,   rg   rg   l   s6    M	T	*B
/CF3K F
#Jr+   rg   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_idr]   week_id
is_working	is_sundayrB   r   r_   r(   r*   r+   r,   rj   rj   s   sa    "M	T	*BWoGWoGWoGJwI
/C(*D
#Jr+   rj   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   r_   r*   r+   r,   rq   rq      s?    M	T	*BWoOG_NVC[!G(*Dr+   rq   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   r]   rB   r   
start_dateend_dater   re   r   r(   r)   r*   r+   r,   rw   rw      sa    )M	T	*BWoG
/CJdf~HF3K F
#J(*%Lr+   rw   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   rY   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   pentionrY   rB   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	   r0   rB   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   rB   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breakingra   rb   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   r]   week_schedule_idr   horary_namera   rb   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   folior0   
cashier_idfolio_segment_idrequested_status_idused_status_idbilled_status_idr   r(   r)   r*   r+   r,   r   r   *  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   7  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   @  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   r0   rH   r   r   re   r   r(   r*   r+   r,   r   r   I  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   r0   r!   r   r   r   r   r   transbank_status_idvisibility_status_idr   r   r(   r)   r*   r+   r,   r   r   R  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   a  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   r0   totaltotal_ticketsr   r(   r*   r+   r,   r   r   i  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   r0   r   r   card_total_collectionsr   r   r(   r)   r*   r+   r,   r   r   q  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   r0   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   r0   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   r0   dte_version_idr   dte_type_idchip_idr"   expense_type_idpayment_type_id	reason_idr   payment_daterB   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_hourre   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_idrB   r0   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_idr0   r  user_rutr   r   r(  why_was_rejectedr  r'  payment_supportre   r   r(   r)   r*   r+   r,   r2  r2    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+   r2  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   rB   r-  r   r*   r+   r,   r=  r=    s8    2M	T	*B

Cvc{#IG_Fr+   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)CashReserveModelcash_reservesTr   N)r   r   r   r   r   r   r   r0   r   r   r   r(   r)   r*   r+   r,   r@  r@    sG    #M	T	*BgJ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
             Z e e
             Zy)IntershipModel
intershipsTr   r   N)r   r   r   r   r   r   r   r0   r   internr   r(   r)   r*   r+   r,   rC  rC    sC     M	T	*BgF3K F
#J(*%Lr+   rC  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   r0   r   rE  observationsr(  r   r(   r)   r*   r+   r,   rG  rG    s_    *M	T	*BgF3K F&+&LVC[!G
#J(*%Lr+   rG  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,   rK  rK  	  sF    2M	T	*B'?L/KwI
#J(*%Lr+   rK  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   rM  rN  rO  r   observationr(  r   r(   r)   r*   r+   r,   rQ  rQ    sb    (M	T	*B'?L/KwI%KVC[!G
#J(*%Lr+   rQ  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   rV  r   r(   r)   r*   r+   r,   rU  rU    s9    #M	T	*B6#;'M
#J(*%Lr+   rU  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   rV  r*   r+   r,   rX  rX  '  s!    $M	T	*B6#;'Mr+   rX  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   re   r(  r   r(   r)   r*   r+   r,   r[  r[  -  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,   r^  r^  6  s    M	T	*B7OEr+   r^  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   r0   contract_type_idr   rB   clientr   ry   rz   renovation_dater   currencyr   r(  r   r(   r)   r*   r+   r,   rb  rb  <  s    M	T	*Bgg

CF3K FJdf~HTVnOVC[!GfSk"HG_FVC[!G
#J(*%Lr+   rb  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   rB   r   r   customerr.  r/  activityr   r   r(   r)   r*   r+   r,   ri  ri  N  s    M	T	*B

CwIJfSk"H6#;E6#;EfSk"HVC[!G
#J(*%Lr+   ri  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,   rn  rn  ]  9    "M	T	*B%K
#J(*%Lr+   rn  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   sizerB   r   delivered_dater   r(   r)   r*   r+   r,   rs  rs  e  s_    M	T	*BWj1C&DEO&+D
/CDF^N
#J(*%Lr+   rs  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,   ry  ry  p  9    $M	T	*B6#;'M
#J(*%Lr+   ry  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~  x  rq  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_valuere   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   rB   r	   rd  r0   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   rB   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   rB   r   r   r   r   r   nicknamer   rX   r   r   r   r   r   r   r   r   r	   rd  rV  r0   r   r   r   r   r   communer  rp  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    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  "  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  +  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  3  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  =  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   re   r   r(   r)   r*   r+   r,   r  r  E  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   re   r   r(   r)   r*   r+   r,   r  r  O  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   re   r   r(   r)   r*   r+   r,   r  r  Y  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   re   r   r(   r)   r*   r+   r,   r  r  c  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   re   r   r(   r)   r*   r+   r,   r  r  n  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   re   r   r(   r)   r*   r+   r,   r  r  z  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   re   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   rd  r
   workeremployerr   re   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   re   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   re   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   rB   r   r   re   rd  r0   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   r0   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   re   r*   r+   r,   r!  r!    s+    2M	T	*BwF3K Fr+   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)CollectionModelcollectionsTr   N)r   r   r   r   r   r   r   r0   r   cash_gross_amountcash_net_amountcard_gross_amountcard_net_amountsubscribersr   r   r(   r   r)   r*   r+   r,   r%  r%    su    !M	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   r0   r  collection_idr"   deposited_amountr'  collection_amountr   collection_dater(  r   r(   r)   r*   r+   r,   r-  r-    sy    M	T	*BgWoO7OMwIgG_NwTlOTlG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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   rB   r   dvr   r   r   rX   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,   r4  r4  
  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+   r4  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   re   r   r(   r)   r*   r+   r,   rS  rS  5  s^    :M	T	*BJE]FG_NF3K F
#J(*%Lr+   rS  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   re   sinceuntilfactorr  r   r(   r)   r*   r+   r,   rY  rY  A  sq    3M	T	*BF3K F6#;E6#;EF3K FfSk"H
#J(*%Lr+   rY  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   re   r   r(   r)   r*   r+   r,   r_  r_  M  s]    9M	T	*B'?L%=Le}HE]F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             Z e e             Zy)PayrollCcafIndicatorModelpayroll_ccaf_indicatorsTr   r   N)r   r   r   r   r   r   r   r   ccaffonasare   r   r(   r)   r*   r+   r,   rc  rc  Y  sU    -M	T	*B&+DF3K FF3K F
#J(*%Lr+   rc  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,   rh  rh  c  sI    !M	T	*B%fSk2fSk*
#J(*%Lr+   rh  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_idrB   r   r   re   r   r(   r*   r+   r,   rm  rm  l  sH    +M	T	*BWoO
/CG_FF3K F
#Jr+   rm  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,   rq  rq  v  s%    )M	T	*BWoGG_Nr+   rq  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_idr0   foreigner_idbank_idaccount_type_idschedule_idr   r   requested_byr"   employee_to_replacereplacement_employee_rutr   replacement_employee_full_namer   account_numberr   ry   rz   r   rS  r   r(   r)   r*   r+   r,   rv  rv  }  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+   rv  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   r^   	causal_idrB   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   rB   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   rB   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   rB   r[  r[  r\  daysno_valid_daysr(  r(   r)   )
r   rB   strr[  r\  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   r^   rB   r   r[  r\  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    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   r.  r   r(   r)   r*   r+   r,   r  r  '  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  0  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   rB   r   r   r   r   r   r(   r)   r*   r+   r,   r  r  9  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  D  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   r^   rB   r   r[  r\  r  r  r   r(  r   r(   r)   r*   r+   r,   r  r  M  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_idrB   r   re   r   r   r(   r)   r*   r+   r,   r  r  [  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_valuere   r   r(   r)   r*   r+   r,   r  r  f  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  p  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   passwordr.  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   r^   r	   medical_license_type_idpatology_type_idr   re   rB   r   r   r[  r\  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   r^   r  r  r   re   rB   r   r   r[  r\  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   r0   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   rB   deposit_numberr   re   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   r0   r   original_datecodebranch_office_name	sale_typer7  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   r0   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   rB   rk  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   r0   r  r/  
deposit_idr   r   r"   r'  r1  r0  r2  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   r0   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,   r'  r'    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+   r'  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,   r:  r:  0  s%    (M	T	*B4LEd|Hr+   r:  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   r0   r   maintenance_dater   r(   r)   r*   r+   r,   r>  r>  7  sA    "M	T	*Bgdf~
#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)MaintenanceDataModelmaintenance_dataTr   r   N)r   r   r   r   r   r   r   maintenance_idfile_numberr   r(  r   r(   r)   r*   r+   r,   rB  rB  @  sK    &M	T	*BG_N/KVC[!G
#J(*%Lr+   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 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_limitrj  rk  r   r(   r)   r*   r+   r,   rG  rG  J  s    M	T	*B &t%d|!$<"4L4LMD\N ,wI%d|d|
#J(*%Lr+   rG  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,   rR  rR  [  s=    !M	T	*B7OMWoG
#J(*%Lr+   rR  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  rB   
social_lawr   r(   r)   r*   r+   r,   rV  rV  d  sU    M	T	*B%gF3K F
/CJ
#J(*%Lr+   rV  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	   rz  r{  r"   rB   r  r   r(   r)   r*   r+   r,   r[  r[  o  s`    -M	T	*BWj45GWoOwI
/CG_N
#J(*%Lr+   r[  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	   r7  old_document_status_idrB   r   re   r(  r   r(   r)   r*   r+   r,   r^  r^  {  sv    )M	T	*BwIgz2E'FG#G_
/CF3K FVC[!G$J(*%Lr+   r^  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   r^   rB   r   r(   r)   r*   r+   r,   rb  rb    s>    4M	T	*B!'?
/C$J(*%Lr+   rb  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"   r7  rB   r   r(  r   r(   r)   r*   r+   r,   re  re    sU    -M	T	*BwIg
/CVC[!G
#J(*%Lr+   re  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,   rh  rh    st    #M	T	*B!'?
/C46NE46NE'?D7OMVC[!G
#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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   rB   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r(   r)   r*   r+   r,   rk  rk    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+   rk  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   rB   rd  r0   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,   rn  rn    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+   rn  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   r0   r   semesterr6  r(  r   r(   r)   r*   r+   r,   rq  rq    sZ    M	T	*BgfSk"H'?DVC[!G
#J(*%Lr+   rq  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   uidrB   r   r-  	privileger   r(   r)   r*   r+   r,   ru  ru    sT    !M	T	*B
/C
/Cvc{#IwI
#J(*%Lr+   ru  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,   rz  rz    s:    +M	T	*B!&+.
#J(*%Lr+   rz  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@   rE   rO   rR   rV   r[   rg   rj   rq   rw   r|   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r  r  r*  r2  r=  r@  rC  rG  rK  rQ  rU  rX  r[  r^  rb  ri  rn  rs  ry  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-  r4  rS  rY  r_  rc  rh  rm  rq  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  r  r  r  r  r  r  r  r#  r'  r:  r>  rB  rG  rR  rV  r[  r^  rb  re  rh  rk  rn  rq  ru  rz  r~  r  r*   r+   r,   <module>r     s   ( i i i & &*&t &,#D ##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 &&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+   