
    6izZ                     b   S SK Jr  S SKJrJrJrJrJrJrJ	r	J
r
JrJrJr  S SKJr   " S S\5      r " S S\5      r " S S	\5      r " S
 S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S S\5      r " S  S!\5      r " S" S#\5      r " S$ S%\5      r " S& S'\5      r  " S( S)\5      r! " S* S+\5      r" " S, S-\5      r# " S. S/\5      r$ " S0 S1\5      r% " S2 S3\5      r& " S4 S5\5      r' " S6 S7\5      r( " S8 S9\5      r) " S: S;\5      r* " S< S=\5      r+ " S> S?\5      r, " S@ SA\5      r- " SB SC\5      r. " SD SE\5      r/ " SF SG\5      r0 " SH SI\5      r1 " SJ SK\5      r2 " SL SM\5      r3 " SN SO\5      r4 " SP SQ\5      r5 " SR SS\5      r6 " ST SU\5      r7 " SV SW\5      r8 " SX SY\5      r9 " SZ S[\5      r: " S\ S]\5      r; " S^ S_\5      r< " S` Sa\5      r= " Sb Sc\5      r> " Sd Se\5      r? " Sf Sg\5      r@ " Sh Si\5      rA " Sj Sk\5      rB " Sl Sm\5      rC " Sn So\5      rD " Sp Sq\5      rE " Sr Ss\5      rF " St Su\5      rG " Sv Sw\5      rH " Sx Sy\5      rIgz){    )Base)ColumnIntegerStringDateTimeDateTime
ForeignKeyFloatBooleanTextNumeric)datetimec                   v    \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \
" 5       5      r\" \
" 5       5      rSrg)AccountTypeModel   account_typesTprimary_key    N)__name__
__module____qualname____firstlineno____tablename__r   r   idr   account_typer   
added_dateupdated_date__static_attributes__r       GC:\Users\jesus\Desktop\proyecto_pie360\backend\app\backend\db\models.pyr   r      9    #M	T	*B&+&L
#J(*%Lr"   r   c                       \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \" S5      5      r
\" \" S5      5      r\" \" 5       5      rSrg)SettingModel   settingsTr   r   r   N)r   r   r   r   r   r   r   r   r   company_emailcompany_phonecompany_whatsappr   r    r!   r   r"   r#   r&   r&      sJ    M	T	*B6#;'M6#;'MfSk*(*%Lr"   r&   c                      \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \5      r
\" \5      r\" \" S5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" SS5      5      r\" \" 5       5      r\" \" SS5      5      r\" \5      r\" \" SS5      5      r \" \5      r!\" \" SS5      5      r"\" \" 5       5      r#\" \$" 5       5      r%\" \$" 5       5      r&\" \5      r'S	r(g
)ShoppingModel   	shoppingsTr   d   r   
      r   N))r   r   r   r   r   r   r   r   r   shopping_numbersupplier_id	status_idemailr   totalmaritime_freightmerchandise_insurancemanifest_openingdeconsolidationland_freightport_charges
honorariesphysical_assessment_expensesadministrative_expensesdollar_valuefolder_processingvalija_expensesr   customs_company_supportwire_transfer_amountr   wire_transfer_date
commissionexchange_rateextra_expensespayment_supportr   r   r    prepaid_status_idr!   r   r"   r#   r-   r-      s   M	T	*BVC[)O/KwI6#;E72q>"Egb!n-"72q>2gb!n-WR^,O'"a.)L'"a.)LA'J#)'"a.#9 $WR^4'"a.)Lwr1~.WR^,O$TVn!'"a.1A'J7OMGBN+NTVnO
#J(*%L wr"   r-   c                   "   \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \" SS5      5      r\" \" SS5      5      r\" \5      r\" \" SS5      5      r\" \" SS5      5      r\" \" 5       5      r\" \" 5       5      rSrg)	ShoppingProductModel8   shoppings_productsTr   r1   r2   r   N)r   r   r   r   r   r   r   r   shopping_id
product_idunit_measure_idquantityr   quantity_per_packageoriginal_unit_costdiscount_percentagefinal_unit_costamountr   r   r    r!   r   r"   r#   rM   rM   8   s    (M	T	*B/KJWoOgH!'"a.1A/ /WR^,OGBN#F
#J(*%Lr"   rM   c                       \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \" S5      5      r
\" \" 5       5      r\" \" 5       5      r\" \" 5       5      rSrg)SupplierModelH   	suppliersTr   r   r   N)r   r   r   r   r   r   r   r   r   identification_numbersupplierr   addressr   r   r    r!   r   r"   r#   rZ   rZ   H   sS    M	T	*B"6#;/fSk"HTVnG
#J(*%Lr"   rZ   c                   v    \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \
" 5       5      r\" \
" 5       5      rSrg)UnitMeasureModelR   unit_measuresTr   r   r   N)r   r   r   r   r   r   r   r   r   unit_measurer   r   r    r!   r   r"   r#   ra   ra   R   r$   r"   ra   c                   >   \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \SS9r\" \5      r\" \5      r\" \SS9r\" \5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       \R.                  S9r\" \" 5       \R.                  S9rSrg)		SaleModelZ   salesTr   r   defaultr   N)r   r   r   r   r   r   r   r   customer_idshipping_method_iddte_type_idr5   folior   subtotaltaxshipping_costr7   r   rJ   delivery_addressr   r   nowr   r    r!   r   r"   r#   rf   rf   Z   s    M	T	*B/K/KwI7A&Ee}H
-C5!,M5METVnOdf~
HLL9J(*hll;Lr"   rf   c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \5      r\" \5      r\" \5      rSrg)SaleProductModell   sales_productsTr   r   N)r   r   r   r   r   r   r   r   sale_idrQ   inventory_movement_idinventory_idlot_item_idrS   pricer!   r   r"   r#   ru   ru   l   sS    $M	T	*BWoGJ"7O'?L/KgH7OEr"   ru   c                      \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \5      r\" \5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)CustomerModelx   	customersTr   r   r   N)r   r   r   r   r   r   r   r   
country_id	region_id
commune_id
package_idbill_or_ticket_iddeleted_status_idr   r]   names	lastnamesr_   company_namephoner6   r   license_timer   r   r    r!   r   r"   r#   r~   r~   x   s    M	T	*BJwIJJww"6#;/6#;Evc{#IVC[!G&+&L6#;E6#;E$<L
#J(*%Lr"   r~   c                   v    \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \
" 5       5      r\" \
" 5       5      rSrg)LocationModel   	locationsTr   r   r   N)r   r   r   r   r   r   r   r   r   locationr   r   r    r!   r   r"   r#   r   r      s9    M	T	*BfSk"H
#J(*%Lr"   r   c                       \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \" S5      5      r
\" \" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)CategoryModel   
categoriesTr   r   r   N)r   r   r   r   r   r   r   r   r   categorypublic_namecolorr   r   r    r!   r   r"   r#   r   r      sU     M	T	*BfSk"H%K6#;E
#J(*%Lr"   r   c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \" S5      5      r\" \" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)LiterFeatureModel   liter_featuresTr   r   r   N)r   r   r   r   r   r   r   r   rQ   rT   quantity_per_palletr   weight_per_literweight_per_palletr   r   r    r!   r   r"   r#   r   r      sf    $M	T	*BJ!'? /fSk*vc{+
#J(*%Lr"   r   c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)PreInventoryStockModel   pre_inventory_stocksTr   r   N)r   r   r   r   r   r   r   r   rQ   rP   
lot_numberstockr   r   r    r!   r   r"   r#   r   r      sO    *M	T	*BJ/KJ7OE
#J(*%Lr"   r   c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \" S5      5      r\" \" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)UnitFeatureModel   unit_featuresTr   r   r   N)r   r   r   r   r   r   r   r   rQ   rT   r   r   weight_per_unitr   r   r   r    r!   r   r"   r#   r   r      se    #M	T	*BJ!'? /VC[)Ovc{+
#J(*%Lr"   r   c                       \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \5      r
\" \" 5       5      r\" \" 5       5      rSrg)RegionModel   regionsTr   r   r   N)r   r   r   r   r   r   r   r   r   regionregion_remuneration_coder   r   r    r!   r   r"   r#   r   r      sC    M	T	*BF3K F%g
#J(*%Lr"   r   c                      \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \" S5      5      r\" \" S5      5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       5      r\" \" 5       5      r\" \5      r\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)ProductModel   productsTr   r   r   N)r   r   r   r   r   r   r   r   r4   category_idrR   r   codeproductr   rU   rV   rW   short_descriptiondescriptionphotocatalogis_compoundcompound_product_idr   r   r    r!   r   r"   r#   r   r      s    M	T	*B/K/KWoO&+DVC[!G .TVnOtv.K46NETVnG/K /
#J(*%Lr"   r   c                   4   \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \\
" S5      5      r\" \5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)		UserModel   usersTr   rols.idr   r   N)r   r   r   r   r   r   r   r   rk   	school_idr
   rol_idr   r   rut	full_namer6   r   hashed_passwordr   r   r    r!   r   r"   r#   r   r      s    M	T	*B/KwIGZ	23Fw

Cvc{#I6#;E6#;EVC[)O
#J(*%Lr"   r   c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)RolModel   rolsTr   r   r   N)r   r   r   r   r   r   r   r   rk   r   r   r   rolr   r   r    r!   r   r"   r#   r   r      sU    M	T	*B/KwIw

C
#J(*%Lr"   r   c                       \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \5      r
\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)PermissionModel   permissionsTr   r   r   N)r   r   r   r   r   r   r   r   r   
permissionpermission_type_idpermission_order_idr   r   r    r!   r   r"   r#   r   r      sM    !M	T	*Bs$J /
#J(*%Lr"   r   c                       \ rS rSrSr\" \SS9r\" \\" S5      5      r	\" \\" S5      5      r
\" \" 5       5      r\" \" 5       5      rSrg)	RolPermissionModeli  rols_permissionsTr   r   zpermissions.idr   N)r   r   r   r   r   r   r   r   r
   r   permission_idr   r   r    r!   r   r"   r#   r   r     sN    &M	T	*BGZ	23F7J/?$@AM
#J(*%Lr"   r   c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \
" S5      5      r\" \" 5       5      r\" \" 5       5      r\" \5      rSrg)TeachingModeli  	teachingsTr   r   r   N)r   r   r   r   r   r   r   r   r   teaching_type_idr   teaching_namer   r   r    r   r!   r   r"   r#   r   r     sV    M	T	*BwIg6#;'M
#J(*%Lwr"   r   c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \
" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)CourseModeli  coursesTr   r   r   N)r   r   r   r   r   r   r   r   r   teaching_idr   course_namer   r   r    r!   r   r"   r#   r   r     sK    M	T	*BwI/K%K
#J(*%Lr"   r   c                       \ rS rSrSr\" \SS9r\" \5      r\" \	" S5      5      r
\" \" 5       5      r\" \" 5       5      rSrg)CommuneModeli#  communesTr   r   r   N)r   r   r   r   r   r   r   r   r   r   communer   r   r    r!   r   r"   r#   r   r   #  sB    M	T	*BwIVC[!G
#J(*%Lr"   r   c                   V    \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
Srg)CustomerProductDiscountModeli,  customers_products_discountsTr   r   N)r   r   r   r   r   r   r   r   rk   rQ   rV   r!   r   r"   r#   r   r   ,  s/    2M	T	*B/KJ /r"   r   c                       \ rS rSrSr\" \SSS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)InventoryModeli4  inventoriesTr   autoincrementr   N)r   r   r   r   r   r   r   r   rQ   location_idminimum_stockmaximum_stockr   last_updater   r!   r   r"   r#   r   r   4  sQ    !M	T	>BJ/K7OM7OM$K
#Jr"   r   c                       \ rS rSrSr\" \SSS9r\" \5      r\" \	" S5      5      r
\" \" 5       5      r\" \" 5       5      r\" \" 5       5      rSrg)LotModeli?  lotsTr   r   r   N)r   r   r   r   r   r   r   r   r4   r   r   r   arrival_dater   r   r    r!   r   r"   r#   r   r   ?  sO    M	T	>B/Ks$J$&>L
#J(*%Lr"   r   c                       \ rS rSrSr\" \SSS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \5      r\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)LotItemModeliI  	lot_itemsTr   r   N)r   r   r   r   r   r   r   r   lot_idrQ   rS   	unit_costpublic_sale_priceprivate_sale_pricer   r   r    r!   r   r"   r#   r   r   I  se    M	T	>BG_FJgHwIw
#J(*%Lr"   r   c                       \ rS rSrSr\" \SSS9r\" \\" S5      5      r	\" \\" S5      5      r
\" \5      r\" \" 5       5      r\" \" 5       5      rSrg)	InventoryLotItemModeliV  inventories_lotsTr   inventories.idzlots.idr   N)r   r   r   r   r   r   r   r   r
   rz   r{   rS   r   r   r    r!   r   r"   r#   r   r   V  sY    &M	T	>B':.>#?@L*Y"78KgH
#J(*%Lr"   r   c                   x    \ rS rSrSr\" \SSS9r\" \" S5      5      r	\" \
" 5       5      r\" \
" 5       5      rSrg)MovementTypeModeli`  movement_typesTr   r   r   N)r   r   r   r   r   r   r   r   r   movement_typer   r   r    r!   r   r"   r#   r  r  `  s;    $M	T	>B6#;'M
#J(*%Lr"   r  c                       \ rS rSrSr\" \SSS9r\" \\" S5      5      r	\" \\" S5      5      r
\" \\" S5      5      r\" \5      r\" \5      r\" \" 5       5      r\" \" 5       5      rSrg	)
InventoryMovementModelih  inventories_movementsTr   r   zlot_items.idzmovement_types.idr   N)r   r   r   r   r   r   r   r   r
   rz   r{   movement_type_idrS   r   r   reasonr   r   r!   r   r"   r#   r  r  h  st    +M	T	>B':.>#?@L*^"<=Kgz2E'FGgHwIDF^F
#Jr"   r  c                       \ rS rSrSr\" \SSS9r\" \\" S5      5      r	\" \\" S5      5      r
\" \5      r\" \5      r\" \" 5       5      r\" \" 5       \R"                  S9rSrg	)
InventoryAuditModelit  inventories_auditsTr   zusers.idr   ri   r   N)r   r   r   r   r   r   r   r   r
   user_idrz   previous_stock	new_stockr   r  r   r   rs   r   r!   r   r"   r#   r
  r
  t  sg    (M	T	>BWj45G':.>#?@LG_NwIDF^F
HLL9Jr"   r
  c                       \ rS rSrSr\" \SSS9r\" \\" S5      5      r	\" \\" S5      5      r
\" \" 5       \R                  S9r\" \" 5       5      rSrg	)
SupplierCategoryModeli  suppliers_categoriesTr   zsuppliers.idzcategories.idri   r   N)r   r   r   r   r   r   r   r   r
   r4   r   r   r   rs   r   r    r!   r   r"   r#   r  r    sU    *M	T	>B*^"<=K*_"=>K
HLL9J(*%Lr"   r  c                       \ rS rSrSr\" \SSS9r\" \\" S5      5      r	\" \SS9r
\" \SS9r\" \" 5       \R                  S9r\" \" 5       \R                  S9rSrg	)
KardexValuesModeli  kardex_valuesTr   zproducts.idr   ri   r   N)r   r   r   r   r   r   r   r   r
   rQ   rS   average_costr   r   rs   r   r    r!   r   r"   r#   r  r    sb    #M	T	>BM!:;Jgq)H'1-L
HLL9J(*hll;Lr"   r  c                   v    \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \
" 5       5      r\" \
" 5       5      rSrg)NativeLanguageProficiencyModeli  native_language_proficienciesTr   r   r   N)r   r   r   r   r   r   r   r   r   native_language_proficiencyr   r   r    r!   r   r"   r#   r  r    s:    3M	T	*B"("5
#J(*%Lr"   r  c                       \ rS rSrSr\" \SS9r\" \5      r\" \	" S5      5      r
\" \" 5       5      r\" \" 5       5      rSrg)FamilyMemberModeli  family_membersTr   r   r   N)r   r   r   r   r   r   r   r   r   r   family_memberr   r   r    r!   r   r"   r#   r  r    sC    $M	T	*Bw6#;'M
#J(*%Lr"   r  c                       \ rS rSrSr\" \SS9r\" \5      r\" \	" S5      5      r
\" \	" S5      5      r\" \" 5       5      r\" \	" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)	NewsModeli  newsTr   r   r   N)r   r   r   r   r   r   r   r   r   r   titler   r   r   imager   r   r    r!   r   r"   r#   r  r    sk    M	T	*Bw6#;Evc{+.K6#;E
#J(*%Lr"   r  c                       \ rS rSrSr\" \SS9r\" \5      r\" \	" S5      5      r
\" \" 5       5      r\" \" 5       5      rSrg)NationalityModeli  nationalitiesTr   r   r   N)r   r   r   r   r   r   r   r   r   r   nationalityr   r   r    r!   r   r"   r#   r$  r$    sC    #M	T	*Bw%K
#J(*%Lr"   r$  c                       \ rS rSrSr\" \SS9r\" \5      r\" \	" S5      5      r
\" \" 5       5      r\" \" 5       5      rSrg)GenderModeli  gendersTr   r   r   N)r   r   r   r   r   r   r   r   r   r   genderr   r   r    r!   r   r"   r#   r(  r(    sC    M	T	*BwF3K F
#J(*%Lr"   r(  c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \
" S5      5      r\" \
" S5      5      r\" \
" S5      5      r\" \
" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)SchoolModeli  schoolsTr   r   r   N)r   r   r   r   r   r   r   r   rk   r   r   school_nameschool_addressdirector_namecommunity_school_passwordr   r   r    r!   r   r"   r#   r,  r,    sw    M	T	*B/Kw%KF3K(N6#;'M &vc{ 3
#J(*%Lr"   r,  c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \
" S5      5      r\" \" 5       5      r\" \" 5       5      rSrg)StudentModeli  studentsTr   r   r   N)r   r   r   r   r   r   r   r   r   r   r   r]   r   r   r    r!   r   r"   r#   r3  r3    sM    M	T	*BwwI"6#;/
#J(*%Lr"   r3  c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \5      r\" \5      rSrg)StudentAcademicInfoModeli  student_academic_dataTr   r   N)r   r   r   r   r   r   r   r   
student_idspecial_educational_need_id	course_idsip_admission_yearr   r   r    r!   r   r"   r#   r6  r6    sM    +M	T	*BJ"(/wI!J(#Lr"   r6  c                      \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \5      r\" \5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \5      r\" \5      rSrg)StudentPersonalInfoModeli  student_personal_dataTr   r   r   N)r   r   r   r   r   r   r   r   r8  r   r   	gender_idproficiency_native_language_idproficiency_language_used_idr   r]   r   father_lastnamemother_lastnamesocial_name	born_dater&  r_   r   r6   native_languagelanguage_usually_usedr   r   r    r!   r   r"   r#   r=  r=    s	   +M	T	*BJwIJwI%+G_"#)'? "6#;/6#;EVC[)OVC[)O%Kvc{#I%KVC[!G6#;E6#;EVC[)O"6#;/!J(#Lr"   r=  c                   f    \ rS rSrSr\" \SS9r\" \5      r\" \	5      r
\" \5      r\" \5      rSrg)StudentDocumentModeli  birth_certificatesTr   r   N)r   r   r   r   r   r   r   r   r8  r   birth_certificater   r   r    r!   r   r"   r#   rI  rI    s:    (M	T	*BJt!J(#Lr"   rI  c                   .   \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \5      r\" \" S5      5      r\" \" S5      5      r\" \5      r\" \5      rSrg)StudentGuardianModeli  student_guardiansTr   r   r   N)r   r   r   r   r   r   r   r   r8  family_member_idr?  r   r]   r   rB  rC  r   rE  r6   celphoner   r   r    r!   r   r"   r#   rM  rM    s    'M	T	*BJgwI"6#;/6#;EVC[)OVC[)OtI6#;EfSk"H!J(#Lr"   rM  c                   .   \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \" S5      5      r\" \5      r\" \" S5      5      r\" \" S5      5      r\" \5      r\" \5      rSrg)ProfessionalModeli  professionalsTr   r   r   N)r   r   r   r   r   r   r   r   r   r   career_type_idr   r]   r   r   r6   r   
birth_dater_   r   r   r   r    r!   r   r"   r#   rR  rR    s    #M	T	*BwIG_FG_N"6#;/6#;Evc{#I6#;EJVC[!G6#;E!J(#Lr"   rR  c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \5      r\" \5      rSrg)ProfessionalTeachingCourseModeli'  professionals_teachings_coursesTr   r   N)r   r   r   r   r   r   r   r   professional_idr   r:  r   r   r   r    r!   r   r"   r#   rW  rW  '  sL    5M	T	*BWoO/KwIw!J(#Lr"   rW  c                       \ rS rSrSr\" \SS9r\" \5      r\" \	" S5      5      r
\" \5      r\" \5      r\" \5      r\" \5      rSrg)PackageModeli2  packagesTr   r   r   N)r   r   r   r   r   r   r   r   r   r   package_namestudents_per_packageprofessionals_per_packager   r   r    r!   r   r"   r#   r[  r[  2  sS    M	T	*Bw&+&L!'? &w!J(#Lr"   r[  c                   r    \ rS rSrSr\" \SS9r\" \5      r\" \	" S5      5      r
\" \5      r\" \5      rSrg)SpecialEducationalNeedModeli=  special_educational_needsTr   r   r   N)r   r   r   r   r   r   r   r   r   r   rb  r   r   r    r!   r   r"   r#   ra  ra  =  s@    /M	T	*Bw &vc{ 3!J(#Lr"   ra  c                   r    \ rS rSrSr\" \SS9r\" \5      r\" \	" S5      5      r
\" \5      r\" \5      rSrg)DocumentTypeModeliF  document_typesTr   r   r   N)r   r   r   r   r   r   r   r   document_type_idr   documentr   r   r    r!   r   r"   r#   rd  rd  F  s?    $M	T	*BgfSk"H!J(#Lr"   rd  c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \
" S5      5      r\" \5      r\" \5      rSrg)DocumentModeliO  	documentsTr   r   r   N)r   r   r   r   r   r   r   r   rf  rT  r   rg  r   r   r    r!   r   r"   r#   ri  ri  O  sH    M	T	*BgG_NfSk"H!J(#Lr"   ri  c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \
" S5      5      r\" \5      r\" \5      rSrg)BirthCertificateDocumentModeliY  birth_certificate_documentsTr   r   r   N)r   r   r   r   r   r   r   r   r8  
version_idr   rK  r   r   r    r!   r   r"   r#   rl  rl  Y  sH    1M	T	*BJJvc{+!J(#Lr"   rl  c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \5      r\" \" S5      5      r\" \" S5      5      r\" \5      r\" \5      rSrg)MessageModelic  messagesTr   r   r   N)r   r   r   r   r   r   r   r   rk   message_type_idresponse_idmessage_response_idr   r   subjectmessager   r   r    r!   r   r"   r#   rp  rp  c  sr    M	T	*B/KWoO/K /wVC[!GVC[!G!J(#Lr"   rp  c                   "   \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \5      r
\" \5      r\" \5      r\" \5      r\" \" S5      5      r\" \5      r\" \5      r\" \5      r\" \5      r\" \5      r\" \5      r\" \5      r\" \5      rSrg)ActionIncidentModeliq  actions_incidentsTr   r   r   N)r   r   r   r   r   r   r   r   r   r8  rY  action_incident_type_idr5   r   r   r!  r   incident_dater	   incident_timer   
backgroundconductconsequencesrecommendationsr   r    r!   r   r"   r#   rx  rx  q  s    'M	T	*BwIJWoO$WowIw6#;E8$M4LMJTlG$<LTlO!J(#Lr"   rx  c                       \ rS rSrSr\" \SS9r\" \5      r\" \	" S5      5      r
\" \	" S5      5      r\" \	" S5      5      r\" \	" S5      5      r\" \5      r\" \5      r\" \5      rSrg)ScheduleModeli  	schedulesTr   r   r   N)r   r   r   r   r   r   r   r   schedule_idr   r   r   r6   rP  r   r  r   r   r    r!   r   r"   r#   r  r    sq    M	T	*B/K6#;Evc{#I6#;EfSk"HD\F!J(#Lr"   r  c                       \ rS rSrSr\" \SS9r\" \5      r\" \	" S5      5      r
\" \5      r\" \	" S5      5      r\" \	" S5      5      r\" \	" S5      5      r\" \5      r\" \5      rSrg)DownloadModeli  	downloadsTr   r   r   N)r   r   r   r   r   r   r   r   download_type_idr   r!  r   r   urltagrS   r   r   r    r!   r   r"   r#   r  r    sr    M	T	*Bg6#;E,K

C

CfSk"H!J(#Lr"   r  c                   ~    \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \" S5      5      r
\" \5      r\" \5      rSrg)
VideoModeli  videosTr   r   r   N)r   r   r   r   r   r   r   r   r   r!  r  r   r   r    r!   r   r"   r#   r  r    sC    M	T	*B6#;E

C!J(#Lr"   r  c                   b    \ rS rSrSr\" \SS9r\" \" S5      5      r	\" \
5      r\" \
5      rSrg)CareerTypeModeli  career_typesTr   r   r   N)r   r   r   r   r   r   r   r   r   career_typer   r   r    r!   r   r"   r#   r  r    s5    "M	T	*B%K!J(#Lr"   r  c                   f    \ rS rSrSr\" \SS9r\" \5      r	\" \5      r
\" \5      r\" \5      rSrg)FaqModeli  faqsTr   r   N)r   r   r   r   r   r   r   r   r   questionanswerr   r   r    r!   r   r"   r#   r  r    s9    M	T	*Bd|HD\F!J(#Lr"   r  c                       \ rS rSrSr\" \SS9r\" \5      r\" \5      r	\" \
" S5      5      r\" \
" S5      5      r\" \
" S5      5      r\" \
" S5      5      r\" \5      r\" \5      r\" \5      rSrg)ContactModeli  contactsTr   r   r   N)r   r   r   r   r   r   r   r   subject_type_idschedule_type_idr   r   r   r6   rP  r   rv  r   r   r    r!   r   r"   r#   r  r    s{    M	T	*BWoOg6#;Evc{#I6#;EfSk"HTlG!J(#Lr"   r  N)Japp.backend.db.databaser   
sqlalchemyr   r   r   r   r   r	   r
   r   r   r   r   r   r   r&   r-   rM   rZ   ra   rf   ru   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,  r3  r6  r=  rI  rM  rR  rW  r[  ra  rd  ri  rl  rp  rx  r  r  r  r  r  r  r   r"   r#   <module>r     s   ( o o o o &t &&4 & (D  (D&4 & &D &&t &< <$
t 
&D &*&D &&D &
& 
&	&T 	&
&t 
&&$ &&4 &*& & 	&t 	&&d && &	(D 	(&$ &&4 &*4 *	$T 	$&t &&4 &&D && &
$T 
$	:$ 	:&D &< <&T && &
& 
&&t &&$ &&$ &&4 &	$t 	$$t $2$4 $$4 $"$ $"	$d 	$	$4 	$$$ $$ $$D $$D $$4 $$$ $($D $$D $$ $$d $$t $$4 $r"   