
    F4jab                    ^   d dl mZ d dlmZmZmZmZmZmZm	Z	m
Z
mZmZmZmZmZmZmZ d dl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/ d0e      Z* G d1 d2e      Z+ G d3 d4e      Z, G d5 d6e      Z- G d7 d8e      Z. G d9 d:e      Z/ G d; d<e      Z0 G d= d>e      Z1 G d? d@e      Z2 G dA dBe      Z3 G dC dDe      Z4 G dE dFe      Z5 G dG dHe      Z6 G dI dJe      Z7 G dK dLe      Z8 G dM dNe      Z9 G dO dPe      Z: G dQ dRe      Z; G dS dTe      Z< G dU dVe      Z= G dW dXe      Z> G dY dZe      Z? G d[ d\e      Z@ G d] d^e      ZA G d_ d`e      ZB G da dbe      ZC G dc dde      ZD G de dfe      ZE G dg dhe      ZF G di dje      ZG G dk dle      ZH G dm dne      ZI G do dpe      ZJ G dq dre      ZK G ds dte      ZL G du dve      ZM G dw dxe      ZN G dy dze      ZO G d{ d|e      ZP G d} d~e      ZQ G d de      ZR G d de      ZS G d de      ZT G d de      ZU G d de      ZV G d de      ZW G d de      ZX G d de      ZY G d de      ZZ G d de      Z[ G d de      Z\ G d de      Z] G d de      Z^ G d de      Z_ G d de      Z` G d de      Za G d de      Zb G d de      Zc G d de      Zd G d de      Ze G d de      Zf G d de      Zg G d de      Zh G d de      Zi G d de      Zj G d de      Zk G d de      Zl G d de      Zm G d de      Zn G d de      Zo G d de      Zp G d de      Zq G d de      Zr G d de      Zs G dÄ de      Zt G dń de      Zu G dǄ de      Zv G dɄ de      Zw G d˄ de      Zx G d̈́ de      Zy G dτ de      Zz G dф de      Z{ G dӄ de      Z| G dՄ de      Z} G dׄ de      Z~ G dل de      Z G dۄ de      Z G d݄ de      Z G d߄ de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d de      Z G d 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y(      )Base)ColumnInteger
BigIntegerStringDateTimeDateTime
ForeignKeyFloatBooleanTextNumericEnumUniqueConstraintselect)column_property)datetimec                      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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y)CustomerModel	customersTprimary_key   N)__name__
__module____qualname____tablename__r   r   id
country_id	region_id
commune_id
package_idbill_or_ticket_iddeleted_status_idr   identification_numbernames	lastnamesaddresscompany_namephoneemailr	   license_timer   
added_dateupdated_date     G/var/www/pie360backend.cl/public_html/app/backend/db/models/pie_core.pyr   r      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(*%Lr1   r   c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)RegionModelregionsTr   r   N)r   r   r   r   r   r   r   r   regionr   r.   r/   r0   r1   r2   r4   r4      s9    M	T	*BF3K F
#J(*%Lr1   r4   c                       e Zd ZdZdZ eed      Z e ed            Z	 ee      Z
 e e             Z e e             Zy)ProvinceModeluM   Provincias (Inspection listado/provincias): id remoto, nombre, región padre.	provincesTr   r   N)r   r   r   __doc__r   r   r   r   r   provincer!   r   r.   r/   r0   r1   r2   r8   r8   #   sE    WM	T	*BfSk"HwI
#J(*%Lr1   r8   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	d            Z ee      Z e e             Z e e             Zy)	UserModelusersTr   r   N)r   r   r   r   r   r   r   customer_idr%   r   rut	full_namer,   r+   r   hashed_passwordr   r.   r/   r0   r1   r2   r=   r=   -   s    M	T	*B/Kw

Cvc{#I6#;E6#;ETlO
#J(*%Lr1   r=   c                       e Zd ZdZ eed      Z ee ed            Z ee ed            Z	 ee      Z
 eed      Z e e             Z e e             Zy)UsersRolModel
users_rolsTr   users.idrols.idnullableN)r   r   r   r   r   r   r   r   user_idrol_idr%   period_yearr   r.   r/   r0   r1   r2   rD   rD   ;   sc     M	T	*BWj45GGZ	23Fw40K
#J(*%Lr1   rD   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)RolModelrolsTr   r   N)r   r   r   r   r   r   r   r?   	school_idr%   r   rolr   r.   r/   r0   r1   r2   rN   rN   F   sU    M	T	*B/KwIw

C
#J(*%Lr1   rN   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)PermissionModelpermissionsTr   r   N)r   r   r   r   r   r   r   r   
permissionpermission_type_idpermission_order_idr   r.   r/   r0   r1   r2   rS   rS   Q   sM    !M	T	*Bs$J /
#J(*%Lr1   rS   c                       e Zd ZdZ eed      Z ee ed            Z ee ed            Z	 e e
             Z e e
             Zy)RolPermissionModelrols_permissionsTr   rG   zpermissions.idN)r   r   r   r   r   r   r   r   rK   permission_idr   r.   r/   r0   r1   r2   rY   rY   [   sN    &M	T	*BGZ	23F7J/?$@AM
#J(*%Lr1   rY   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)TeachingModel	teachingsTr   r   N)r   r   r   r   r   r   r   rP   teaching_type_idr   teaching_namer   r.   r/   r%   r0   r1   r2   r]   r]   d   sV    M	T	*BwIg6#;'M
#J(*%Lwr1   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 ee      Zy)CourseModelcoursesTr   r   rH   N)r   r   r   r   r   r   r   rP   teaching_idr   course_namerL   r   r.   r/   r%   r0   r1   r2   rb   rb   o   sa    M	T	*BwI/K%K40K
#J(*%Lwr1   rb   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   communer   r.   r/   r0   r1   r2   rg   rg   {   sB    M	T	*BwIVC[!G
#J(*%Lr1   rg   c                   t    e Zd ZdZ eed      Z e ed            Z e e	             Z
 e e	             Zy)NativeLanguageProficiencyModelnative_language_proficienciesTr   r   N)r   r   r   r   r   r   r   r   native_language_proficiencyr   r.   r/   r0   r1   r2   rk   rk      s:    3M	T	*B"("5
#J(*%Lr1   rk   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)FamilyMemberModelfamily_membersTr   r   N)r   r   r   r   r   r   r   r%   r   family_memberr   r.   r/   r0   r1   r2   ro   ro      sC    $M	T	*Bw6#;'M
#J(*%Lr1   ro   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             Z e e             Zy)	NewsModelnewsTr   r   N)r   r   r   r   r   r   r   r%   r   titleshort_descriptionr   descriptionimager   r.   r/   r0   r1   r2   rs   rs      sk    M	T	*Bw6#;Evc{+.K6#;E
#J(*%Lr1   rs   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)NationalityModelnationalitiesTr   r   N)r   r   r   r   r   r   r   r%   r   nationalityr   r.   r/   r0   r1   r2   rz   rz      sC    #M	T	*Bw%K
#J(*%Lr1   rz   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)GenderModelgendersTr   r   N)r   r   r   r   r   r   r   r%   r   genderr   r.   r/   r0   r1   r2   r~   r~      sC    M	T	*BwF3K F
#J(*%Lr1   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	d            Z e e             Z e e             Zy)SchoolModelschoolsTr   r   N)r   r   r   r   r   r   r   r?   r%   r   school_nameschool_addressdirector_namecommunity_school_passwordr   r.   r/   r0   r1   r2   r   r      sw    M	T	*B/Kw%KF3K(N6#;'M &vc{ 3
#J(*%Lr1   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      d      Z e e             Z e e             Zy)StudentModelstudentsTr   r   
   rH   N)r   r   r   r   r   r   r   r%   rP   r   r&   rL   r   r.   r/   r0   r1   r2   r   r      s]    M	T	*BwwI"6#;/d3K
#J(*%Lr1   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      d      Z ee      Z eed      Z e ed      d      Z eed      Z ee      Z ee      Zy)StudentAcademicInfoModelstudent_academic_dataTr   rH   r   2   N)r   r   r   r   r   r   r   
student_idspecial_educational_need_id	course_idplatform_status_idr   resolution_numbersip_admission_yearr	   diagnostic_date#psychopedagogical_evaluation_status!psychopedagogical_evaluation_yearr   r.   r/   r0   r1   r2   r   r      s    +M	T	*BJ"(/wI$7vc{T:TD1O*0d*K'(.w(F%!J(#Lr1   r   c                   @    e Zd ZdZ eed      Z e ed            Zy)PlatformStatusModelplatform_statusesTr   d   N	r   r   r   r   r   r   r   r   namer0   r1   r2   r   r      s!    'M	T	*B&+Dr1   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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)StudentPersonalInfoModelstudent_personal_dataTr   r   rH   N)r   r   r   r   r   r   r   r   r!   r"   	gender_idproficiency_native_language_idproficiency_language_used_idr   r&   r'   father_lastnamemother_lastnamesocial_name	born_datenationality_idr)   r+   r,   native_languagelanguage_usually_usedr   r.   r/   r0   r1   r2   r   r      s   +M	T	*BJwIJwI%+G_"#)'? "6#;/6#;EVC[)OVC[)O%Kvc{#IGd3NVC[!G6#;E6#;EVC[)O"6#;/!J(#Lr1   r   c                   d    e Zd ZdZ eed      Z ee      Z ee      Z	 ee
      Z ee
      Zy)StudentDocumentModelbirth_certificatesTr   N)r   r   r   r   r   r   r   r   r   birth_certificater   r.   r/   r0   r1   r2   r   r      s:    (M	T	*BJt!J(#Lr1   r   c                   H   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      Z e e
d            Z e e
d            Z e e
d            Z ee      Z ee      Zy)StudentGuardianModelstudent_guardiansTr   r   N)r   r   r   r   r   r   r   r   family_member_idr   r   r&   r'   r   r   r	   r   r,   celphonecityr   r.   r/   r0   r1   r2   r   r     s    'M	T	*BJgwI"6#;/6#;EVC[)OVC[)OtI6#;EfSk"H&+D!J(#Lr1   r   c                       e Zd ZdZdZ eed      Z ee ed      d      Z	 eed      Z
 ee      Z ee      Z e eej"                        j%                  ej                  e	k(        j'                  e      j)                               Zy)ProfessionalModelu   
    Perfil académico del usuario (carrera): una fila típica por user_id.
    Colegio / año escolar live en users_rols + rols; teaching/course en professionals_teachings_courses.
    professionalsTr   rF   rH   N)r   r   r   r:   r   r   r   r   r   rJ   career_type_idr   r.   r/   r   r   r=   r@   wherecorrelate_exceptscalar_subqueryr&   r0   r1   r2   r   r     s    
 $M	T	*BWj4tDGGd3N!J(#L+y}}##ILLG$;<MMiXhhjr1   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      Z e ed      d      Z ee      Z ee      Zy)ProfessionalTeachingCourseModelprofessionals_teachings_coursesTr   rH   r   N)r   r   r   r   r   r   r   professional_idrd   r   teacher_type_idr   r%   r   subjectr   r.   r/   r0   r1   r2   r   r   '  st    5M	T	*BWoO/KwIWt4OGd3NwVC[40G!J(#Lr1   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d      Z eed      Zy)StudentProfessionalModelstudents_professionalsTr   rH   N)r   r   r   r   r   r   r   r   r   r   hoursr   r.   r/   deleted_dater0   r1   r2   r   r   5  sa    ,M	T	*BJWoOGd3N7T*E40J(T2L(T2Lr1   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      d      Z e ed      d      Z eed      Z eed      Z eed      Zy)CoordinatorsCourseModelcoordinators_coursesTr   r   rH   N)r   r   r   r   r   r   r   rP   r   r   coordinator_type_idr   r+   r,   r   r.   r/   r   r0   r1   r2   r   r   A  s|    *M	T	*BwIwIWoO /6#;.E6#;.E40J(T2L(T2Lr1   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      d      Z eed      Z eed      Z eed      Zy)MeetingSchedulalingModelmeeting_schedualingsTr   rH   r   N)r   r   r   r   r   r   r   rP   r   	period_idr	   meeting_dater   meeting_timer   r.   r/   r   r0   r1   r2   r   r   O  sq    *M	T	*BwIwIw.I$.L&+5L40J(T2L(T2Lr1   r   c                       e Zd ZdZ eed      Z ee      Z e ed      d      Z	 ee
d      Z ee
d      Z ee
d      Zy) MeetingSchedualingAgreementModelmeeting_schedualing_agreementsTr   r   rH   N)r   r   r   r   r   r   r   meeting_schedualing_idr   
agreementsr   r.   r/   r   r0   r1   r2   r   r   \  sQ    4M	T	*B#G_sd3J40J(T2L(T2Lr1   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y)+MeetingSchedualingRegisterProfessionalModel+meeting_schedualing_registers_professionalsTr   rH   N)r   r   r   r   r   r   r   meeting_schedualing_register_idr   r   r.   r/   r   r0   r1   r2   r   r   f  sJ    AM	T	*B&,Wo#WoO40J(T2L(T2Lr1   r   c                       e Zd ZdZ eed      Z eed      Z eed      Z	 e e
d      d      Z e e
d      d      Z eed      Z eed      Zy)DiversifiedStrategyModeldiversified_strategiesTr   rH   r   N)r   r   r   r   r   r   r   r   r   planning_learning_stylesr   planning_strengthsplanning_support_needsr   r.   r/   r0   r1   r2   r   r   p  sf    ,M	T	*Bw.I%dT:sd;#F3K$?40J(T2Lr1   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      d      Z e ed      d      Z eed      Z eed      Zy)&RegularTeacherDiversifiedStrategyModel&regular_teacher_diversified_strategiesTr   rH   r   N)r   r   r   r   r   r   r   rP   r   
subject_idr   strategyr   periodcriteriar   r.   r/   r0   r1   r2   r   r   {  s{    <M	T	*Bw.Iw.I$/JdT*HF3K$/FfSkD1H40J(T2Lr1   r   c                       e Zd ZdZ eed      Z eed      Z e ed      d      Z	 ee
d      Z ee
d      Z ee
d      Zy)SubjectModelsubjectsTr   rH   r   N)r   r   r   r   r   r   r   rP   r   r   r   r.   r/   r   r0   r1   r2   r   r     sS    M	T	*Bw.IVC[40G40J(T2L(T2Lr1   r   c                       e Zd ZdZdZ eed      Z e ed      d      Z	 e ed      d      Z
 e ed      d      Z eedd	
      Z eedd
      Z eed      Z eed      Z eed      Zy)CurriculumSubjectModelu   
    Catálogo nacional de asignaturas (curriculum subjects).
    Distinto de `subjects`, que son asignaturas por colegio (school_id).
  curriculum_subjectsTr   r   FrH   @   r   rI   default   N)r   r   r   r:   r   r   r   r   r   r   name_escategory
sort_order	is_activer   r.   r/   r   r0   r1   r2   r   r     s    
 *M	T	*B&+.DVC[51GfRj40H%;Jw:I40J(T2L(T2Lr1   r   c                   $   e Zd ZdZdZ eed      Z e ed      d      Z	 e ed      d      Z
 e ed      d      Z eed      Z e ed	      d      Z eedd
      Z eedd      Z eed      Z eed      Z eed      Zy)EducationLevelModelu2   Niveles educativos (1° básico, 2° medio, etc.).education_levelsTr      FrH          r   r   r   N)r   r   r   r:   r   r   r   r   r   r   r   education_stagegrade_numberoa_level_coder   r   r   r.   r/   r   r0   r1   r2   r   r     s    <&M	T	*B&+.DVC[51GVBZ%8O'D1L6!9t4M%;Jw:I40J(T2L(T2Lr1   r   c                       e Zd ZdZdZ eed      Z ee edd      d	      Z	 ee ed
d      d	      Z
 e ed      d	      Z eedd      Z eed	      Z eed	      Z eed	      Zy)CurriculumSubjectLevelModeluL   Vincula una asignatura del catálogo con un nivel (cada par puede tener OA).curriculum_subject_levelsTr   zcurriculum_subjects.idCASCADEondeleteFrH   zeducation_levels.id   r   r   N)r   r   r   r:   r   r   r   r   r   curriculum_subject_ideducation_level_idr   ministry_subject_coder   r   r.   r/   r   r0   r1   r2   r   r     s    V/M	T	*B"7J7OZc,dotu4IT])^ino"6":>w:I40J(T2L(T2Lr1   r   c                       e Zd ZdZdZ eed      Z ee edd      d	      Z	 e e
d
      d	      Z eed	      Z eedd      Z eedd      Z eedd      Z eed	      Z eed	      Z eed	      Zy)LearningObjectiveModelz<Objetivo de aprendizaje (OA) Mineduc por asignatura + nivel.learning_objectivesTr   zcurriculum_subject_levels.idr  r  FrH   r   r   r   r   N)r   r   r   r:   r   r   r   r   r   curriculum_subject_level_idr   coder   rw   is_priorityr   r   r   r.   r/   r   r0   r1   r2   r
  r
    s    F)M	T	*B"(:YOZ_# &*u-D.K5!<K%;Jw:I40J(T2L(T2Lr1   r
  c                   H   e Zd ZdZ eed      Z eed      Z eed      Z e e	d      d      Z
 e e	d      d      Z e e	d      d      Z e e	d      d      Z e e	d      d      Z e e	d      d      Z eed      Z eed      Z eed      Zy)CollaborativeWorkModelcollaborative_worksTr   rH   r   N)r   r   r   r   r   r   r   rP   r   r   planning_collab_co_teachingplanning_collab_assistantsplanning_collab_studentsplanning_collab_familyplanning_collab_communityplanning_observationsr   r.   r/   r   r0   r1   r2   r  r    s    )M	T	*Bw.Iw.I"(t"D!'sd!C%fSkDA#F3K$? &vc{T B"6#;>40J(T2L(T2Lr1   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      d      Z e e
d      d      Z e e
d      d      Z eed      Z eed      Z eed      Zy)SupportOrganizationModelsupport_organizationsTr   rH   r   N)r   r   r   r   r   r   r   rP   r   r   r   hours_support_regular_classroomhours_support_outside_classroomspecialized_support_typesr   r.   r/   r   r0   r1   r2   r  r    s    +M	T	*Bw.Iw.I$/J&,VC[4&H#&,VC[4&H# &vc{T B40J(T2L(T2Lr1   r  c                       e Zd ZdZ eed      Z ed ed      d      Z e ed      d      Z	 eed	
      Z
 eed      Z eed      Z eed      Zy)DiversityCriterionModeldiversity_criteriaTr   keyP   FrH   r   r   r   Nr   r   r   r   r   r   r   r   r!  labelr   r   r.   r/   r   r0   r1   r2   r  r    se    (M	T	*B
r
U
3C6#;.E+J40J(T2L(T2Lr1   r  c                       e Zd ZdZ eed      Z eed      Z e ed      d      Z	 eed      Z
 eed      Z eed      Z eed      Zy)	DiversityStrategyOptionModeldiversity_strategy_optionsTr   rH   r   r   r#  N)r   r   r   r   r   r   r   diversity_criterion_idr   r%  r   r   r.   r/   r   r0   r1   r2   r'  r'    s`    0M	T	*B#Gd;6#;.E+J40J(T2L(T2Lr1   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y)	CourseDiversityResponseModelcourse_diversity_responsesTr   FrH   r   r#  N)r   r   r   r   r   r   r   r   r)  criterion_selecteddiversity_strategy_option_idr   how_textr   r.   r/   r   r0   r1   r2   r+  r+  	  sv    0M	T	*Bw/I#Ge<3#)'D#A dT*H40J(T2L(T2Lr1   r+  c                   `    e Zd ZdZ eed      Z eed      Z eed      Z ee	d      Z
y)#CourseDiversityResponseStudentModel"course_diversity_response_studentsTr   FrH   N)r   r   r   r   r   r   r   course_diversity_response_idr   r   r.   r0   r1   r2   r1  r1    s8    8M	T	*B#)'E#B %0J40Jr1   r1  c                       e Zd ZdZ eedd      Z ee edd      d      Z ee	d      Z
 eed      Z eed      Zy	)
CourseDiversityObservationModelcourse_diversity_observationsTr   autoincrement
courses.idr  r  FrH   N)r   r   r   r   r   r   r   r   r   r   observationsr   r.   r/   r0   r1   r2   r5  r5    sO    3M	T	>Bw
<) LW\]I$.L40J(T2Lr1   r5  c                       e Zd ZdZ eedd      Z e ed      dd      Z e ed      d      Z	 eed	
      Z
 eed      Z eed      Z eed      Zy)AdjustmentAspectModeladjustment_aspectsTr7  r"  FrI   uniquer   rH   r   r#  Nr$  r0   r1   r2   r<  r<  '  sg    (M	T	>B
eD
9C6#;/E+J40J(T2L(T2Lr1   r<  c                       e Zd ZdZ eedd      Z ee edd      d      Z ee ed	d      d      Z	 e e
d
      d      Z eed      Z eed      Z eed      Z eed      Zy)CourseAdjustmentModelcourse_adjustmentsTr7  r9  r  r  FrH   zadjustment_aspects.id  N)r   r   r   r   r   r   r   r   r   adjustment_aspect_idr   other_aspect_textr   valuer   r.   r/   r   r0   r1   r2   rA  rA  2  s    (M	T	>Bw
<) LW\]I!':6MXa+bmrsvc{T:4$'E40J(T2L(T2Lr1   rA  c                       e Zd ZdZ eedd      Z ee edd      d      Z ee ed	d      d      Z	 ee
d      Zy
)CourseAdjustmentStudentModelcourse_adjustment_studentsTr7  zcourse_adjustments.idr  r  FrH   students.idN)r   r   r   r   r   r   r   r   course_adjustment_idr   r   r.   r0   r1   r2   rH  rH  >  sP    0M	T	>B!':6MXa+bmrsMI!NY^_J40Jr1   rH  c                       e Zd ZdZ eedd      Z e ed      dd      Z e ed      d      Z	 eed	
      Z
 eed      Z eed      Z eed      Zy)CurricularAdequacyTypeModelcurricular_adequacy_typesTr7  r"  Fr>  rC  rH   r   r#  Nr$  r0   r1   r2   rM  rM  F  sg    /M	T	>B
eD
9C6#;/E+J40J(T2L(T2Lr1   rM  c                       e Zd ZdZ eedd      Z ee edd      d      Z ee ed	d      d      Z	 eed
      Z
 eed      Z e ed      d      Z eed      Z eed      Z eed      Zy)CourseCurricularAdequacyModelcourse_curricular_adequaciesTr7  r9  r  r  FrH   zcurricular_adequacy_types.idr   r#  rC  N)r   r   r   r   r   r   r   r   r   curricular_adequacy_type_idappliedr   
scope_textr   strategies_textr   r.   r/   r   r0   r1   r2   rP  rP  Q  s    2M	T	>Bw
<) LW\]I"(*=[fo2p  |A  #BWa(Gt,JVC[48O40J(T2L(T2Lr1   rP  c                       e Zd ZdZ eedd      Z ee edd      d      Z ee ed	d      d      Z	 ee
d      Zy
)$CourseCurricularAdequacySubjectModel#course_curricular_adequacy_subjectsTr7  course_curricular_adequacies.idr  r  FrH   subjects.idN)r   r   r   r   r   r   r   r   course_curricular_adequacy_idr   r   r.   r0   r1   r2   rW  rW  ^  W    9M	T	>B$*7J?`kt4u  AF  %G!MI!NY^_J40Jr1   rW  c                       e Zd ZdZ eedd      Z ee edd      d      Z ee ed	d      d      Z	 ee
d      Zy
)$CourseCurricularAdequacyStudentModel#course_curricular_adequacy_studentsTr7  rY  r  r  FrH   rJ  N)r   r   r   r   r   r   r   r   r[  r   r   r.   r0   r1   r2   r^  r^  f  r\  r1   r^  c                   
   e Zd ZdZ eedd      Z ee edd      d      Z ee ed	d
      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d      Z eed      Zy)CourseIndividualSupportModelcourse_individual_supportsTr7  r9  r  r  FrH   support_areas.idSET NULLr   N)r   r   r   r   r   r   r   r   r   support_area_idr   horarior	   fecha_iniciofecha_terminor   r:  r   r.   r/   r   r0   r1   r2   ra  ra  n  s    0M	T	>Bw
<) LW\]IWj1Cj&YdhiOVC[40G$.L4$/M$.L40J(T2L(T2Lr1   ra  c                       e Zd ZdZ eedd      Z ee edd      d      Z ee ed	d      d      Z	 ee
d      Zy
)#CourseIndividualSupportStudentModel"course_individual_support_studentsTr7  zcourse_individual_supports.idr  r  FrH   rJ  N)r   r   r   r   r   r   r   r   course_individual_support_idr   r   r.   r0   r1   r2   rj  rj  |  sW    8M	T	>B#)':>]hq3r  ~C  $D MI!NY^_J40Jr1   rj  c                       e Zd ZdZdZ eedd      Z ee edd      d	      Z	 ee ed
d      d	      Z
 eed	      Z eed	      Z eed	      Zy)CourseRecordSupportModeluH   Card 2: Registro de apoyos por curso y área (objetivos de aprendizaje).course_record_supportTr7  r9  r  r  FrH   rc  N)r   r   r   r:   r   r   r   r   r   r   re  r   r  r   
created_at
updated_atr0   r1   r2   rn  rn    sj    R+M	T	>Bw
<) LW\]IWj1Ci&XchiO 540J40Jr1   rn  c                       e Zd ZdZdZ eedd      Z ee edd      d	      Z	 ee ed
d      d	      Z
 eed	      Zy)CourseRecordSupportStudentModelu6   Estudiantes que recibirán los apoyos por área (N:M).course_record_support_studentsTr7  zcourse_record_support.idr  r  FrH   rJ  N)r   r   r   r:   r   r   r   r   r   course_record_support_idr   r   rp  r0   r1   r2   rs  rs    sS    @4M	T	>B%gz:T_h/ityzMI!NY^_J40Jr1   rs  c                   .   e Zd ZdZdZ eedd      Z ee edd      d	      Z	 ee ed
d      d	      Z
 eed	      Z e edd      d	      Z e ed      d	      Z ee edd      d	      Z eed	      Z eed	      Z eed	      Zy)$CourseRecordSupportInterventionModelzPCada fila = un 'Ingresar apoyo' (fecha, horas, lugar, profesional, actividades).#course_record_support_interventionsTr7  r9  r  r  FrH   rc        r   professionals.idrd  N)r   r   r   r:   r   r   r   r   r   r   re  r	   dater   pedagogical_hoursr   placer   r   activities_descriptionr   rp  rq  r0   r1   r2   rw  rw    s    Z9M	T	>Bw
<) LW\]IWj1Ci&XchiO$'Dwq!}t<6#;.EWj1Cj&YdhiO#D4840J40Jr1   rw  c                       e Zd ZdZ eedd      Z ee edd      d      Z ee ed	d      d      Z	 ee
d      Z eed      Z eed      Zy
)#CourseTeacherRecordObservationModel"course_teacher_record_observationsTr7  r9  r  r  FrH   rZ  N)r   r   r   r   r   r   r   r   r   r   r   r:  r   rp  rq  r0   r1   r2   r  r    se    8M	T	>Bw
<) LW\]IMI!NY^_J$.L40J40Jr1   r  c                       e Zd ZdZ eedd      Z ee edd      d      Z ee ed	d      d      Z	 ee
d      Z e ed
d      dd      Z eed      Z eed      Z eed      Z eed      Zy) CourseTeacherRecordActivityModel course_teacher_record_activitiesTr7  r9  r  r  FrH   rZ  ry  rz  r   r   N)r   r   r   r   r   r   r   r   r   r   r	   r|  r   r}  r   teacher_namesrw   r   rp  rq  r0   r1   r2   r  r    s    6M	T	>Bw
<) LW\]IMI!NY^_J$'Dwq!}uaH4$/M-K40J40Jr1   r  c                       e Zd ZdZdZ eedd      Z ee edd      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y
)CourseActivityFamilyModelz7IV.1 Trabajo con la familia, apoderados y/o estudiante.course_activity_familyTr7  r9  r  r  FrH   Nr   r   r   r:   r   r   r   r   r   r   r	   r|  r   	attendees
objectives
activitiesr   resultsr   rp  rq  r0   r1   r2   r  r    s    A,M	T	>Bw
<) LW\]I$&Dtd+It,Jt,Jt,JTD)G40J40Jr1   r  c                       e Zd ZdZdZ eedd      Z ee edd      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y
)CourseActivityCommunityModelz3IV.2 Trabajo con la comunidad y el entorno escolar.course_activity_communityTr7  r9  r  r  FrH   Nr  r0   r1   r2   r  r    s    =/M	T	>Bw
<) LW\]I$&Dtd+It,Jt,Jt,JTD)G40J40Jr1   r  c                       e Zd ZdZdZ eedd      Z ee edd      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y
)CourseActivityOtherModelzV.3 Otras reuniones (acta).course_activity_otherTr7  r9  r  r  FrH   Nr  r0   r1   r2   r  r    s    %+M	T	>Bw
<) LW\]I$&Dtd+It,Jt,Jt,JTD)G40J40Jr1   r  c                       e Zd ZdZdZ eedd      Z ee edd      d	      Z	 ee ed
d      d	      Z
 eed	      Z eed	      Z eed	      Z eed	      Z eed	      Zy)CourseLearningAchievementModeluV   Card 3: Registro de logros de aprendizaje por curso, estudiante y período (1, 2 o 3).course_learning_achievementsTr7  r9  r  r  FrH   rJ  N)r   r   r   r:   r   r   r   r   r   r   r   r   r   achievementscommentsr   rp  rq  r0   r1   r2   r  r    s    `2M	T	>Bw
<) LW\]IMI!NY^_Jw/I$.LdT*H40J40Jr1   r  c                       e Zd ZdZ eedd      Z e ed      dd      Z e ed      d      Z	 eed	
      Z
 eed      Z eed      Z eed      Zy)EvalDiversityTypeModeleval_diversity_typesTr7  r"  Fr>  rC  rH   r   r#  Nr$  r0   r1   r2   r  r    sg    *M	T	>B
eD
9C6#;/E+J40J(T2L(T2Lr1   r  c                       e Zd ZdZ eedd      Z ee edd      d      Z ee ed	d      d      Z	 ee
d      Z eed      Z eed      Z eed      Zy
)CourseEvalDiversityModelcourse_eval_diversityTr7  r9  r  r  FrH   zeval_diversity_types.idN)r   r   r   r   r   r   r   r   r   eval_diversity_type_idr   rU  r   r.   r/   r   r0   r1   r2   r  r    st    +M	T	>Bw
<) LW\]I#GZ8Q\e-fqvwTD1O40J(T2L(T2Lr1   r  c                       e Zd ZdZ eedd      Z ee edd      dd      Z ee	d	      Z
 eed	      Z eed	      Z eed	      Zy
)#CourseEvalDiversityObservationModel"course_eval_diversity_observationsTr7  r9  r  r  Fr>  rH   Nr   r   r   r   r   r   r   r   r   r   r:  r   r.   r/   r   r0   r1   r2   r  r    s^    8M	T	>Bw
<) LW\eijI$.L40J(T2L(T2Lr1   r  c                       e Zd ZdZ eedd      Z e ed      dd      Z e ed      d      Z	 eed	
      Z
 eed      Z eed      Z eed      Zy) FamilyCommunityStrategyTypeModelfamily_community_strategy_typesTr7  r"  Fr>  r   rH   r   r#  Nr$  r0   r1   r2   r  r    sg    5M	T	>B
eD
9C6#;/E+J40J(T2L(T2Lr1   r  c                       e Zd ZdZ eedd      Z ee edd      d      Z ee ed	d      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y
)CourseFamilyCommunityModelcourse_family_communityTr7  r9  r  r  FrH   z"family_community_strategy_types.idN)r   r   r   r   r   r   r   r   r   !family_community_strategy_type_idr   descripcionseguimiento
evaluacionr   r.   r/   r   r0   r1   r2   r  r  &  s    -M	T	>Bw
<) LW\]I(.w
Cgr{8|  HM  )N%-K-Kt,J40J(T2L(T2Lr1   r  c                       e Zd ZdZ eedd      Z ee edd      dd      Z ee	d	      Z
 eed	      Z eed	      Z eed	      Zy
)%CourseFamilyCommunityObservationModel$course_family_community_observationsTr7  r9  r  r  Fr>  rH   Nr  r0   r1   r2   r  r  3  s^    :M	T	>Bw
<) LW\eijI$.L40J(T2L(T2Lr1   r  c                       e Zd ZdZ eed      Z ee      Z e ed            Z	 ee      Z
 ee      Z ee      Z ee      Zy)PackageModelpackagesTr   r   N)r   r   r   r   r   r   r   r%   r   package_namestudents_per_packageprofessionals_per_packager   r.   r/   r0   r1   r2   r  r  =  sS    M	T	*Bw&+&L!'? &w!J(#Lr1   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)SpecialEducationalNeedModelspecial_educational_needsTr   rH   r   N)r   r   r   r   r   r   r   rP    special_educational_need_type_idr%   r   r  r   r.   r/   r0   r1   r2   r  r  H  sV    /M	T	*Bw.I'-g$w &vc{ 3!J(#Lr1   r  c                       e Zd 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d      Z eedd      Z eedd      Z eed      Z eed      Zy	)
DiagnosisSummaryModelur   Resumen por diagnóstico: cupos disponibles y ocupados por NEE, curso y año (year_index: 0=1er año, 1=2do año).diagnosis_summaryTr7  rH   Fr   r   N)r   r   r   r:   r   r   r   r   rP   r   r   
year_indexavailable_slotsoccupied_slotsr   r.   r/   r0   r1   r2   r  r  S  s    |'M	T	>Bw.I"(5"Aw/I%;JWua@OGeQ?N40J(T2Lr1   r  c                       e Zd ZdZ eedd      Z e ed      d      Z ee	d      Z
 ee	d      Z ee	d      Zy)SupportAreaModelsupport_areasTr7  r   rH   N)r   r   r   r   r   r   r   r   support_arear   r.   r/   r   r0   r1   r2   r  r  a  sI    #M	T	>B&+5L40J(T2L(T2Lr1   r  c                       e Zd 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      d      Z eed      Z eed      Z eed      Z eed      Z eed      Zy)	DynamicFormModeluO   Formularios dinámicos (preguntas configurables). Campos en JSON (fields_json).dynamic_formsTr7  rH   r   FN)r   r   r   r:   r   r   r   r   rP   r   rL   r   r   r   rw   fields_jsonr   r.   r/   r   r0   r1   r2   r  r  j  s    Y#M	T	>Bw.Iw.I40K&+.D-K.K40J(T2L(T2Lr1   r  c                       e Zd 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d      Z eed      Z eed      Z eed      Zy)DynamicFormSubmissionModeluX   Respuestas enviadas a un formulario dinámico (un registro por estudiante y formulario).dynamic_form_submissionsTr7  FrH   N)r   r   r   r:   r   r   r   r   dynamic_form_idr   rP   rL   r   answers_jsonsubmitted_by_user_idr   r.   r/   r0   r1   r2   r  r  z  sy    b.M	T	>BWu5O%0Jw.I40K$/L!'D940J(T2Lr1   r  c                       e Zd ZdZdZ eedd      Z eed      Z e e	d      d      Z
 eed      Z eed      Z eed      Z eed      Zy)	InformalTestTemplateModeluX   Plantillas de pruebas informales por colegio (catálogo reutilizable entre estudiantes).informal_test_templatesTr7  FrH   r   N)r   r   r   r:   r   r   r   r   rP   r   r   r   rw   r   r.   r/   r   r0   r1   r2   r  r    sd    b-M	T	>Bw/I&+.D-K40J(T2L(T2Lr1   r  c                       e Zd ZdZdZ eedd      Z ee edd      d	      Z	 eed	      Z
 eed	      Z e ed
      d	      Z eed	      Z eedd      Z eed	      Z eed	      Zy)!InformalTestTemplateQuestionModelz.Preguntas de una plantilla de prueba informal. informal_test_template_questionsTr7  informal_test_templates.idr  r  FrH   r   r   N)r   r   r   r:   r   r   r   r   r   template_idquestion_orderr   question_textr   question_typeoptions_jsonr   requiredr   r.   r/   r0   r1   r2   r  r    s    86M	T	>B*-IT]"^inoKGe4N4%0M6":6M$.Lgu=H40J(T2Lr1   r  c                       e Zd ZdZdZ eedd      Z ee edd      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y
)InformalTestSubmissionModelzIRespuestas enviadas para una plantilla de prueba informal por estudiante.informal_test_submissionsTr7  r  r  r  FrH   N)r   r   r   r:   r   r   r   r   r   informal_test_template_idrP   r   r   r   r  r   r.   r/   r   r0   r1   r2   r  r    s    S/M	T	>B &w
;Wbk0lw| }w/I%0JWt4O$/L40J(T2L(T2Lr1   r  c                       e Zd ZdZ eedd      Z eed      Z e ed      d      Z	 e ed      d      Z
 eed      Z eed      Z eed      Zy)+DifferentiatedStrategiesImplementationModel)differentiated_strategies_implementationsTr7  rH   r   N)r   r   r   r   r   r   r   r   r   actions_takenapplied_strategiesr   r.   r/   r   r0   r1   r2   r  r    sf    ?M	T	>Bw.I6#;6Msd;40J(T2L(T2Lr1   r  c                   p    e Zd ZdZ eed      Z ee      Z e ed            Z	 ee
      Z ee
      Zy)DocumentTypeModeldocument_typesTr   r   N)r   r   r   r   r   r   r   document_type_idr   documentr   r.   r/   r0   r1   r2   r  r    s?    $M	T	*BgfSk"H!J(#Lr1   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d      Zy)DocumentModel	documentsTr   r   rH   N)r   r   r   r   r   r   r   r  r   r   r  r   r.   r/   r   r0   r1   r2   r  r    sT    M	T	*BgG_NfSk"H!J(#L(T2Lr1   r  c                   p    e Zd ZdZ eed      Z ee      Z e ed            Z	 ee
      Z ee
      Zy)BirthCertificateDocumentModelbirth_certificate_documentsTr   r   N)r   r   r   r   r   r   r   r   r   r   r   r.   r/   r0   r1   r2   r  r    s?    1M	T	*BJvc{+!J(#Lr1   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d            Z e ed            Z ee      Z ee      Zy)MessageModelmessagesTr   r   N)r   r   r   r   r   r   r   r?   message_type_idresponse_idmessage_response_idr%   r   r   messager   r.   r/   r0   r1   r2   r  r    sr    M	T	*B/KWoO/K /wVC[!GVC[!G!J(#Lr1   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 ee      Z ee      Z ee      Z ee      Z ee      Z ee      Zy)ActionIncidentModelactions_incidentsTr   r   N)r   r   r   r   r   r   r   rP   r   r   action_incident_type_id	status_idr%   r   ru   r   incident_dater
   incident_timer   
backgroundconductconsequencesrecommendationsr.   r/   r0   r1   r2   r  r    s    'M	T	*BwIJWoO$WowIw6#;E8$M4LMJTlG$<LTlO!J(#Lr1   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y)ScheduleModel	schedulesTr   r   N)r   r   r   r   r   r   r   schedule_idr   r'   r(   r,   r   r   reasonr   r.   r/   r0   r1   r2   r  r    sq    M	T	*B/K6#;Evc{#I6#;EfSk"HD\F!J(#Lr1   r  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d            Z e ed            Z ee      Z ee      Zy)DownloadModel	downloadsTr   r   N)r   r   r   r   r   r   r   download_type_idr   ru   r   rw   urltagquantityr   r.   r/   r0   r1   r2   r	  r	    sr    M	T	*Bg6#;E,K

C

CfSk"H!J(#Lr1   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)
VideoModelvideosTr   r   N)r   r   r   r   r   r   r   r   ru   r  r   r.   r/   r0   r1   r2   r  r    sC    M	T	*B6#;E

C!J(#Lr1   r  c                   `    e Zd ZdZ eed      Z e ed            Z ee	      Z
 ee	      Zy)CareerTypeModelcareer_typesTr   r   N)r   r   r   r   r   r   r   r   career_typer   r.   r/   r0   r1   r2   r  r  !  s5    "M	T	*B%K!J(#Lr1   r  c                   d    e Zd ZdZ eed      Z ee      Z ee      Z	 ee
      Z ee
      Zy)FaqModelfaqsTr   N)r   r   r   r   r   r   r   r   questionanswerr   r.   r/   r0   r1   r2   r  r  )  s9    M	T	*Bd|HD\F!J(#Lr1   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	d            Z ee      Z ee      Z ee      Zy)ContactModelcontactsTr   r   N)r   r   r   r   r   r   r   subject_type_idschedule_type_idr   r'   r(   r,   r   r   r  r   r.   r/   r0   r1   r2   r  r  2  s{    M	T	*BWoOg6#;Evc{#I6#;EfSk"HTlG!J(#Lr1   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
 ee      Z eed      Z eed      Z e ed      d      Z e ed      d      Z eed      Z eed      Z eed      Zy)FolderModelfoldersTr   rH   r   N)r   r   r   r   r   r   r   rP   r   r   document_id
version_id	detail_idr   r   filerL   r   r.   r/   r   r0   r1   r2   r!  r!  @  s    M	T	*Bw.Iw.IJ/KJw.IWt4O&+-Dt4K40J(T2L(T2Lr1   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y)DocumentAlertModeldocument_alertsTr   rH   N)r   r   r   r   r   r   r   r   r   r#  r   must_be_finish_datedocument_uploaded_dater.   r/   r   r0   r1   r2   r(  r(  Q  sl    %M	T	*BJWoO/K D9#Ht<40J(T2L(T2Lr1   r(  c                   F    e Zd ZdZ eedd      Z e ed      d      Zy)PeriodTypeModelperiod_typesTr7  r   FrH   Nr   r0   r1   r2   r-  r-  c  s%    "M	T	>B&+.Dr1   r-  c                   ^   e Zd ZdZ eedd      Z eed      Z eedd      Z ee	d      Z
 eedd      Z e ed	      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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"d      Z# ee"d      Z$ ee"d      Z%y
)CespDocumentModelcesp_documentsTr7  FrH      r   r   r   N)&r   r   r   r   r   r   r   r   r  r	   elaboration_dateperiod_type_idr   pharmacological_treatmentexternal_specialistsr   profile_interactionprofile_involvementprofile_behavior_repertoireprofile_skillsprofile_challengesprofile_support_needsprofile_interestsstressors_triggersprevention_measuressuggestions_special strategies_phase1_manifestationsstrategies_phase1_strategies strategies_phase2_manifestationsstrategies_phase2_strategies strategies_phase3_manifestationsstrategies_phase3_strategies strategies_phase4_manifestationsstrategies_phase4_strategiesr   r.   r/   r   r0   r1   r2   r0  r0  i  sz   $M	T	>B%0JgrBdT2GeQ?N &vbzD A!&*t< 5 5"("=D40Nt4"4$7td3t4 5 5'-dT'B$#)$#> '-dT'B$#)$#> '-dT'B$#)$#> '-dT'B$#)$#> 40J(T2L(T2Lr1   r0  c                   V   e Zd ZdZ eedd      Z eed      Z eed      Z e e	d      d      Z
 e e	d      d      Z eed      Z e e	d      d      Z e e	d      d      Z e e	d      d      Z eedd	
      Z eedd
      Z eed      Z eed      Zy)CespGuardianModelcesp_guardiansTr7  FrH   r   r   rC  r   r   r   N)r   r   r   r   r   r   r   cesp_document_idguardian_idr   r   r&   r   r)   r+   r,   is_emergency_contactis_guardianr   r.   r/   r0   r1   r2   rJ  rJ    s    $M	T	>Bg640K&+-D"6":=g5VC[40G6":-E6#;.E!'E1E5!<K40J(T2Lr1   rJ  c                       e Zd ZdZ eedd      Z eed      Z eed      Z e e	d      d      Z
 eed      Z eed      Zy) CespParticipantProfessionalModelcesp_participant_professionalsTr7  FrH   r   N)r   r   r   r   r   r   r   rL  r   r   professional_roler   r.   r/   r0   r1   r2   rQ  rQ    sW    4M	T	>Bg6Wu5Ovc{T:40J(T2Lr1   rQ  c                       e Zd ZdZ eedd      Z eed      Z eed      Z e e	d      d      Z
 eed      Z e e	d      d      Z e e	d      d      Z eedd	      Z eed      Z eed      Zy
)CespSupportTeamMemberModelcesp_support_team_membersTr7  FrH   r   r   r   r   N)r   r   r   r   r   r   r   rL  r   r   rS  r   support_rolesr+   r,   r   r   r.   r/   r0   r1   r2   rU  rU    s    /M	T	>Bg6Wu5Ovc{T:4$/M6":-E6#;.E%;J40J(T2Lr1   rU  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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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#y)HealthEvaluationModelhealth_evaluationsTr   r   N)$r   r   r   r   r   r   r   r   r   r   consultation_reason_idprofesional_idprocedence_idr   rA   r&   r	   r   ager   r   r   consultation_reason_detail"professional_identification_number professional_registration_numberprofessional_specialtyprocedence_otherprofessional_contactevaluation_datereevaluation_dategeneral_assessment	diagnosisindicationsr   r.   r/   r0   r1   r2   rY  rY    s.   (M	T	*BJwIG_N#G_G_N7OMvc{#I"6#;/tI
/CVC[)O"6#;/!')/s)<&'-fSk':$#F3K0fSk*!&+.TlOttI,K!J(#Lr1   rY  c                   &   e Zd ZdZdZ eedd      Z ee edd      d	      Z	 e e
d
      d	      Z e e
d      d	      Z eed	      Z e e
d      d	      Z eed	      Z e e
d      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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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 edd      d	      Z% e e
d      d	      Z& e e
d      d	      Z' e e
d
      d	      Z( ee)d	      Z* ee)d	      Z+y)$PsychopedagogicalEvaluationInfoModelu9   Document 27 – Psychopedagogical Evaluation Information.!psychopedagogical_evaluation_infoTr7  rJ  r  r  FrH   r   r   rC  r   r{  rd  N),r   r   r   r:   r   r   r   r   r   r   r   r   r^  r	   re  rh  diagnosis_issue_dateadmission_typeadmission_type_otherr   instruments_appliedschool_history_backgroundcognitive_analysiscognitive_quantitative_matrixcognitive_general_scales!cognitive_quantitative_image_filepersonal_analysismotor_analysiscognitive_synthesispersonal_synthesismotor_synthesissuggestions_to_schoolsuggestions_to_classroom_teamsuggestions_to_studentsuggestions_to_familyother_suggestions
conclusionr   r`  ra  rb  r   rp  rq  r0   r1   r2   rk  rk    s   C7M	T	>BMI!NY^_Jt4K
t
,CTD1Ovc{T2I!$6F2J6N!&+= 5 &td ;t4$*4$$?!%dT:(.vc{T(J%td3D40N 5t4TD1O"4$7$*4$$?!#D48"4$7td3t,JWj1Cj&YdhiO)/r
T)J&'-fSkD'I$#F3K$?40J40Jr1   rk  c                       e Zd ZdZdZ eedd      Z ee edd      d	      Z	 e e
d
      d	      Z eed	      Z e e
d      d	      Z eed	      Zy)%PsychopedagogicalEvaluationScaleModelu]   Scales VII (pedagogical) and VIII (social_communicative) – indicator 1-10, value 1|2|3|N/O."psychopedagogical_evaluation_scaleTr7  z$psychopedagogical_evaluation_info.idr  r  FrH   r   r   N)r   r   r   r:   r   r   r   r   r   $psychopedagogical_evaluation_info_idr   
scale_typeindicator_numberrF  r   rp  r0   r1   r2   r  r    sn    g8M	T	>B+1BYWbg,( r
U3Jg66":.E40Jr1   r  c                       e Zd ZdZdZ eedd      Z eed      Z	 ee
d      Z e ed      dd	      Z e ed
      dd	      Z eed      Z eed      Z eed      Z eed      Zy)ConnersTeacherEvaluationModeluQ   Document 29: Conners Teacher Abbreviated + Conduct – header (one row per form).conners_teacher_evaluationsTr7  FrH   r    r   r   ingresoN)r   r   r   r:   r   r   r   r   r   r   r	   re  r   evaluator_nameevaluation_typer   comments_observationstotal_scorer   rp  rq  r0   r1   r2   r  r  	  s    [1M	T	>B
U3JTE2OF3K%DNVBZ%KO"4$740K40J40Jr1   r  c                   z    e Zd ZdZdZ eedd      Z ee eddd      d	      Z	 eed	      Z
 eed	      Zy
)ConnersTeacherScoreModelzADocument 29: Conners 10-item scale (one row per item; score 0-3).conners_teacher_scoresTr7  conners_teacher_evaluations.idr  r  onupdateFrH   N)r   r   r   r:   r   r   r   r   r   evaluation_id
item_indexscorer0   r1   r2   r  r    sO    K,M	T	>B<y[depuM %0J7U+Er1   r  c                       e Zd ZdZdZ eedd      Z ee eddd      d	      Z	 eed	      Z
 e ed
      d	      Zy)ConnersConductResponseModelzQDocument 29: Conduct questionnaire 18 items (one row per item; response n/p/b/m).conners_conduct_responsesTr7  r  r  r  FrH   r   N)r   r   r   r:   r   r   r   r   r   r  r  r   responser0   r1   r2   r  r  "  sS    [/M	T	>B<y[depuM %0JfQi%0Hr1   r  c                      e Zd ZdZ eedd      Z eed      Z eedd      Z eedd      Z	 ee
ej                  	      Z ee
ej                  
      Z e ed      d      Z e ed      d      Z e ed      d      Z eed      Z e ed      d      Z e ed      d      Z e ed      d      Z eed      Z e ed      d      Z e ed      d      Z e ed      d      Z e ed      d      Z e ed      d      Z eed      Z e ed      d      Z e ed      d      Z  e ed      d      Z! e ed      d      Z" e ed      d      Z# e ed      d      Z$ e ed      d      Z% e ed      d      Z& e ed      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*d      Z. ee*d      Z/ ee*d      Z0 ee*d      Z1 ee*d      Z2 ee*d      Z3 ee*d      Z4 ee*d      Z5 eed      Z6 eed      Z7 eed      Z8y)FamilyReportModelfamily_reportsTr7  FrH      r   r   r#  r  r   r2  r   r   r   N)9r   r   r   r   r   r   r   r   r  versionr   r   utcnowr.   r/   r   student_full_namestudent_identification_numberstudent_social_namer	   student_born_datestudent_agestudent_coursestudent_schoolr   r`  professional_social_namerS  professional_phoneprofessional_emailreport_delivery_datereceiver_full_namereceiver_identification_numberreceiver_social_namereceiver_phonereceiver_emailreceiver_relationshipreceiver_presence_ofguardian_typehas_power_of_attorneyr  re  r   applied_instrumentsrh  pedagogical_strengthspedagogical_support_needssocial_affective_strengthssocial_affective_support_needshealth_strengthshealth_support_needscollaborative_workhome_supportagreements_commitmentsevaluation_date_1evaluation_date_2evaluation_date_3r0   r1   r2   r  r  -  s   $M	T	>B%0JgqAWua8G(//:J(X__=Lvc{T:$*6":$E! t<td3d3KF3K$7NF3K$7NWt4O)/r
T)J&%fSkDAvc{T:r
T:sd;!$6sd;%+F2J%F"!&+=F2J6NF3K$7N"6#;>!&+=6":5M"6":=VBZ$7OTD1O 5td+I"4$7 &td ;!'t!<%+D4%@"dT2!$6t4$.L#D48td3td3td3r1   r  c                      e Zd ZdZ eedd      Z eed      Z eedd      Z e e	d      d      Z
 eed      Z e e	d	      d      Z eed      Z e e	d
      d      Z eed      Z e e	d      d      Z e e	d      d      Z e e	d      d      Z eed      Z eed      Z e e	d      d      Z eed      Z e e	d	      d      Z e e	d      d      Z e e	d      d      Z e e	d      d      Z eed      Z e e	d      d      Z e e	d      d      Z e e	d	      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d      Z& ee"d      Z' ee"d      Z( eed      Z) e e	d	      d      Z* e e	d      d      Z+ e e	d      d      Z, eed      Z- e e	d      d      Z. e e	d	      d      Z/ eed      Z0 eed      Z1 eed      Z2 ee3e4jj                        Z6 ee3e4jj                        Z7y)InterconsultationModelinterconsultationsTr7  FrH      r   r   r   r  r      r   r#  r  N)8r   r   r   r   r   r   r   r   r  r   rA   r   r&   r	   r   r^  r   r   r   r)   r!   r"   r   responsible_idcontact_phonecontact_emaileducational_establishmentcourse_levelprogram_type_idestablishment_addressestablishment_communeestablishment_phoneestablishment_emailadditional_information_idr   question_to_answerattached_documentsreferring_professionalreception_dateevaluation_summaryindications_supportr   r`  ra  rb  r]  rc  professional_contact_phonere  required_new_control_idnew_control_dater   r   r  r.   r/   r0   r1   r2   r  r  a  s   (M	T	>B%0JgrB vc{T2Iw.I"6":=td+I
d
+CGd3NVC[48O"6#;>VC[40Gw.I$/J&+-DGd3N6":5M6#;6M &vc{T B&*t4LWt4O"6#;>"6#;> d; t< !'w >t4t4#D48 D40Nt4 5 Wt4O)/r
T)J&'-fRj4'H$#F3K$?7T2MfSkD9!'r
T!BTD1O$Wt<dT2(//:J(X__=Lr1   r  c                       e Zd ZdZdZ eedd      Z eed      Z eedd      Z	 eedd	
      Z
 eedd
      Z eedd
      Z eedd
      Z eeej$                        Z eeej$                        Zy)"GuardianAttendanceCertificateModelz@Document 25 - Certificado de asistencia del apoderado (Ley TEA).guardian_attendance_certificateTr7  FrH      r   z,Responsible professional for the certificate)rI   commentzCertificate datez Start time (guardian attendance)zEnd time (guardian attendance)r#  r  N)r   r   r   r:   r   r   r   r   r   r  r   r	   certificate_dater
   
start_timeend_timer   r   r  r.   r/   r0   r1   r2   r  r    s    J5M	T	>B%0JgrBWt=klOdT;MNt5WXJdT3STH(//:J(X__=Lr1   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 ee      Z ee
      Z ee
      Zy)
EventModeleventsTr   r   N)r   r   r   r   r   r   r   r   ru   colorr   
start_dateend_dater   rw   r.   r/   r0   r1   r2   r  r    s`    M	T	*B6#;E6#;E!JhH,K!J(#Lr1   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      d      Z eed      Z eed      Zy)BankDescriptionModelbank_descriptionsTr   rH   r   N)r   r   r   r   r   r   r   rP   r#  question_numberr   bank_descriptionr   r.   r/   r0   r1   r2   r  r    s`    'M	T	*Bw.I40KWt4OfSkD940J(T2Lr1   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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d      Z eed      Z eed      Z eed      Z e ed      d      Z ee d      Z! ee d      Z" ee d      Z#y	)
ProgressStatusStudentModelprogress_status_studentsTr   rH   F   r   rC  N)$r   r   r   r   r   r   r   r$  r   rP   r#  nee_idr   guardian_relationship_idr   r   responsible_professionalsr	   progress_datepedagogical_languagepedagogical_mathematicspsychopedagogicalspeech_therapypsychologicalkinesiologyoccupational_therapydeaf_co_educatorsynthesis_commentssuggestions_familysuggestions_establishmentr   r&  r   r.   r/   r   r0   r1   r2   r  r    sY   .M	T	*B$/J%0Jw/I5"=KGd+Fw.I%g=w.I &td ;4$/M "$6$TD9td3D40N4$/M-K!$6dT2  t4  t4 &td ; &+-D 40J(T2L(T2Lr1   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      d      Z e ed      d      Z eed      Z e ed      d      Z ee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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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.y)	IndividualSupportPlanModelindividual_support_plansTr   rH   r   r   r   N)/r   r   r   r   r   r   r   r   r  rP   r   r   r  r  r	   r  r  student_nee_idr  student_course_idr3  r   r  cognitive_strengthscurricular_strengthsfamily_strengthsintervention_ed_diferencial&intervention_ed_diferencial_strategiesintervention_psicopedagogia&intervention_psicopedagogia_strategiesintervention_fonoaudiologia&intervention_fonoaudiologia_strategiesintervention_psicologia"intervention_psicologia_strategies intervention_terapia_ocupacional+intervention_terapia_ocupacional_strategiesintervention_kinesiologia$intervention_kinesiologia_strategiesintervention_coeducador_sordo(intervention_coeducador_sordo_strategiesintervention_int_lengua_senas(intervention_int_lengua_senas_strategiesfollow_up_pair   r.   r/   r   r0   r1   r2   r  r    s   .M	T	*B$/Jg5w.Iw.I vc{T:$*6":$E!td3d3KGd3NF3K$7Nw6dT2 "(t!< 5!$6dT2 #)"=-3D4-H* #)"=-3D4-H* #)"=-3D4-H* %TD9)/t)D& (.dT'B$282M/ !'td ;+1$+F( %+4$$?!/5dT/J, %+4$$?!/5dT/J, 4$/M 40J(T2L(T2Lr1   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      d      Z e e
d      d      Z eed      Z eed      Z e e
d      d      Z eed      Z eed      Z eed      Zy)	&IndividualSupportPlanProfessionalModel%individual_support_plan_professionalsTr   FrH   r   r   N)r   r   r   r   r   r   r   individual_support_plan_idr   r   r   registration_number
days_hoursr	   	from_dateto_datesupport_modalityr   r.   r/   r   r0   r1   r2   r  r  *  s    ;M	T	*B!'%!@Wu5OGd3N t<sd3Jtd+ITD)GfSkD9 40J(T2L(T2Lr1   r  c                   d   e Zd ZdZ eedd      Z eed      Z eedd      Z eed      Z	 eed      Z
 eed      Z e ed      d      Z e ed	      d      Z eed      Z e ed	      d      Z eed      Z e ed      d      Z e ed      d      Z ee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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#y
)'IndividualCurriculumAdaptationPlanModel&individual_curriculum_adaptation_plansTr7  FrH      r   r   r   N)$r   r   r   r   r   r   r   r   r  rP   semester_idr	   report_dater   r  r  r  r  r  student_neer  r  r  r   school_backgroundevaluation_backgroundnee_diagnosiscurricular_adaptationscurricular_adaptation_subjectssupport_resourcesevaluation_criteriaprogress_stater   r.   r/   r   r0   r1   r2   r'  r'  <  sf   <M	T	>B%0JgrBw.I40K-Kvc{T:$*6":$E!td3d3KGd3Nt4KF3K$7Nw6F3K$7Ntd3"4$74$/M#D48%+D4%@"td3 5D40N40J(T2L(T2Lr1   r'  c                       e Zd ZdZ eedd      Z eed      Z eed      Z e e	d      d      Z
 eed      Z e e	d      d      Z e e	d      d      Z eed      Z eed      Z eed      Zy)	3IndividualCurriculumAdaptationPlanProfessionalModel3individual_curriculum_adaptation_plan_professionalsTr7  FrH   r   r   N)r   r   r   r   r   r   r   (individual_curriculum_adaptation_plan_idr   r   rS  r   rW  r+   r,   r   r.   r/   r   r0   r1   r2   r6  r6  ]  s    IM	T	>B/5g/N,Wu5Ovc{T:4$/M6":-E6#;.E40J(T2L(T2Lr1   r6  c                   j   e Zd ZdZ eedd      Z eed      Z eed      Z e e	d      d      Z
 e e	d      d      Z eed      Z e e	d      d      Z e e	d      d      Z e e	d      d      Z eedd	
      Z eedd
      Z eed      Z eed      Z eed      Zy)3IndividualCurriculumAdaptationPlanFamilyMemberModel4individual_curriculum_adaptation_plan_family_membersTr7  FrH   r   r   rC  r   r   r   N)r   r   r   r   r   r   r   r8  rM  r   r   r&   r   r)   r+   r,   rN  rO  r   r.   r/   r   r0   r1   r2   r:  r:  k  s    JM	T	>B/5g/N,40K&+-D"6":=g5VC[40G6":-E6#;.E!'E1E5!<K40J(T2L(T2Lr1   r:  c                       e Zd ZdZ eed      Z ee ed      d      Z ee ed      d      Z	 ee
dej                        Z ee
dej                  ej                  	      Zy
)
AuditModelauditsTr   rF   FrH   rG   r   )rI   r   r  N)r   r   r   r   r   r   r   r   rJ   rK   r   r   r  r.   r/   r0   r1   r2   r=  r=  }  sf    M	T	*BWj4uEGGZ	2TBF4IJ(T8??U]UdUdeLr1   r=  c                   8   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      d      Z e e
d      d      Z eed      Z e e
d      d      Z ee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
d      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d      Z eed      Z eed      Z  eed      Z!y
)$ProgressStatusIndividualSupportModel#progress_status_individual_supportsTr   FrH   r   r   r   rC  N)"r   r   r   r   r   r   r   r   rP   r  r   r  r  r	   r  r  r  r  r  r  r   r  guardian_namer  selected_pai_idr   pai_objectivespai_observationsr  r  r   r.   r/   r   r0   r1   r2   r@  r@    sW   9M	T	*B%0Jw.Ig5 vc{T:$*6":$E!td3d3KGd3NF3K$7Nw6 4$/Mw.I  &g=6#;6M !'vc{T B Wt4OD40NdT2  t4 &td ; 40J(T2L(T2Lr1   r@  c                   P   e Zd ZdZ eed      Z eed      Z eed      Z e e	d      d      Z
 e e	d      d      Z ee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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!d      Z# ee!d      Z$y)	FonoaudiologicalReportModelfonoaudiological_reportTr   FrH   r   r   N)%r   r   r   r   r   r   r   r   r  r   r  r  r	   r  establishment_idr   r   r  r+  type_idreason_evaluationevaluation_instrumentsrelevant_backgroundbehaviors_observedorofacial_auditoryphonological_levelmorphosyntactic_levelsemantic_levelpragmatic_leveladditional_observationsdiagnostic_synthesisr  r  r   r.   r/   r   r0   r1   r2   rG  rG    sh   -M	T	*B%0Jg5vc{T:$*6":$E!td3fSkD9w.I &td ;-KWt,Gtd3#D48 5t4t4t4"4$7D40NTD1O$TD9!$6t4 &td ;40J(T2L(T2Lr1   rG  c                       e Zd ZdZdZ eedd      Z eed      Z eed      Z	 e e
d      d      Z eedd	      Z e e
d
      dd	      Z eed      Z eed      Z eed      Zy)FurFormModeluO   Document 6 – Formulario de revaluación (FUR). Campos del formulario en JSON.	fur_formsTr7  FrH   r   ry  r   r"  deaN)r   r   r   r:   r   r   r   r   r   rP   r   r  r  fur_variantr   	form_datar   r.   r/   r0   r1   r2   rW  rW    s    YM	T	>B%0Jw.I$*6":$E!gqAeUCKtd+I40J(T2Lr1   rW  c                       e Zd ZdZdZ eed      Z eed      Z eed      Z	 ee
d      Z eedd      Z eed      Z eed      Zy)	IdtelReportModelu.   Document 9 – Informe fonoaudiológico IDTEL.idtel_reportTr   FrH   )r   rI   N)r   r   r   r:   r   r   r   r   r   r  r   r[  r   quantitative_lockedr   r.   r/   r0   r1   r2   r]  r]    sb    8"M	T	*B%0Jg5td+I %$G40J(T2Lr1   r]  c                       e Zd 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y) PsychomotorEvaluationReportModeluL   Informe de evaluación psicomotriz (áreas motoras, síntesis, sugerencias).psychomotor_evaluation_reportTr   FrH   N)r   r   r   r:   r   r   r   r   r   r  r   r[  r   r.   r/   r0   r1   r2   ra  ra    sS    V3M	T	*B%0Jg5td+I40J(T2Lr1   ra  c                       e Zd ZdZdZ eedd      Z eed      Z eed      Z	 e e
d      d      Z eed      Z eed      Zy)	EvaluaResultReportModelua   Informes Resultado Prueba Evalua (título; folders.detail_id → id). Tabla evalua_result_report.evalua_result_reportTr7  FrH   rC  N)r   r   r   r:   r   r   r   r   r   document_catalog_idr   ru   r   r.   r/   r0   r1   r2   rd  rd    sY    k*M	T	>B%0J 486#;.E40J(T2Lr1   rd  c                       e Zd ZdZ eed      Z eed      Z eed      Z e e	d      d      Z
 e e	d      d      Z e e	d      d      Z eed      Z eed      Z eed      Zy),SchoolIntegrationProgramExitCertificateModel+school_integration_program_exit_certificateTr   rH   r   N)r   r   r   r   r   r   r   r   r   r   document_description!professional_certification_numberprofessional_careerrM  r   r.   r/   r0   r1   r2   rh  rh    s    AM	T	*B$/JWt4O!&+=(.vc{T(J% t<40K40J(T2Lr1   rh  c                      e Zd ZdZ eedd      Z eed      Z eedd      Z ee	d      Z
 ee	d      Z e ed      d      Z eed      Z eed      Z e ed	      d      Z eed      Z e ed
      d      Z e ed	      d      Z e ed      d      Z eed      Z e ed      d      Z eed      Z e ed      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d      Z  eed      Z! e ed      d      Z" eed      Z# e ed	      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d      d      Z* e ed      d      Z+ e ed      d      Z, e ed      d      Z- e ed      d      Z. e ed      d      Z/ e ed      d      Z0 e ed      d      Z1 e ed      d      Z2 e ed      d      Z3 eed      Z4 e ed	      d      Z5 e ed	      d      Z6 eed      Z7 eed      Z8 e ed      d      Z9 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      ZA eed      ZB eed      ZC eed      ZD eed      ZE eed      ZF eed      ZG eed      ZH eed      ZI eed      ZJ eed      ZK eed      ZL eed      ZM eed      ZN eed      ZO eed      ZP eed      ZQ eed      ZR eed      ZS eed      ZT eed      ZU eed      ZV eed      ZW e ed	      d      ZX e ed      d      ZY eed      ZZ 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      Za eed      Zb eed      Zc eed      Zd eed      Ze eed      Zf eed      Zg eed      Zh eed      Zi eed      Zj eed      Zk eed      Zl eed      Zm eed      Zn eed      Zo eed      Zp eed      Zq eed      Zr eed      Zs eed      Zt eed      Zu e ed	      d      Zv e ed	      d      Zw e ed	      d      Zx eed      Zy eed      Zz 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      d      Z eed      Z e ed	      d      Z e ed      d      Z e ed	      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d      Z e ed	      d      Z e ed	      d      Z e ed      d      Z e ed      d      Z e ed      d      Z eed      Z eed      Z eed      Z e ed	      d      Z eed      Z e ed	      d      Z e ed	      d      Z eed      Z eed      Z e ed      d      Z ee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d      Z eed      Z eed      Z e ed
      d      Z e ed	      d      Z e ed
      d      Z eed      Z e ed      d      Z eed      Z e ed      d      Z eed      Z e ed      d      Z eed      Z eed      Z e ed	      d      Z e ed	      d      Z eed      Zy)AnamnesisModel	anamnesisTr7  FrH   r   r   r   r   rC  r   r   r   r#  N)r   r   r   r   r   r   r   r   r  r   r.   r/   r   r  r   r	   r   r^  r   r)   r+   r   r   native_language_domainlanguage_usedlanguage_used_domaincurrent_schoolingr   interview_reasondiagnosis_hasdiagnosis_detailspecialistsfirst_year_notesbirth_type_idbirth_reasonbirth_medical_assistancebirth_weightbirth_heightfirst_year_conditions#first_year_periodic_health_checkupsfirst_year_vaccinesfirst_year_observationssm_head_controlsm_sits_alonesm_walks_without_supportsm_first_wordssm_first_phrasessm_dresses_alonesm_bladder_daysm_bladder_nightsm_bowel_daysm_bowel_nightsm_observations_1sm_motor_activitysm_muscle_tonesm_walking_stabilitysm_frequent_fallssm_lateral_dominancesm_fine_grabsm_fine_gripsm_fine_pinchsm_fine_drawsm_fine_writesm_fine_threadsm_cog_reacts_familiarsm_cog_demands_companysm_cog_smiles_babblessm_cog_manipulates_exploressm_cog_understands_prohibitionssm_cog_poor_eye_handsm_observations_2vision_interested_stimulivision_irritated_eyesvision_headachesvision_squintsvision_follows_movementvision_abnormal_movementsvision_erroneous_behaviorsvision_diagnosishearing_interested_stimulihearing_recognizes_voiceshearing_turns_headhearing_ears_to_tvhearing_covers_earshearing_earacheshearing_pronunciation_adequatehearing_diagnosisvision_hearing_observationslanguage_communication_methodlanguage_communication_otherlanguage_exp_babbleslanguage_exp_vocalizes_gestureslanguage_exp_emits_wordslanguage_exp_emits_phrases language_exp_relates_experiences language_exp_clear_pronunciation language_comp_identifies_objectslanguage_comp_identifies_people"language_comp_understands_abstract!language_comp_responds_coherently)language_comp_follows_simple_instructions*language_comp_follows_complex_instructions(language_comp_follows_group_instructions!language_comp_understands_storieslanguage_oral_losslanguage_observationssocial_relates_spontaneouslysocial_explains_behaviorssocial_participates_groupssocial_prefers_individualsocial_echolalic_languagesocial_difficulty_adaptingsocial_relates_collaborativelysocial_respects_social_normssocial_respects_school_normssocial_shows_humorsocial_stereotyped_movementssocial_frequent_tantrumssocial_reaction_lightssocial_reaction_soundssocial_reaction_strange_peoplesocial_observationshealth_vaccines_up_to_datehealth_epilepsyhealth_heart_problemshealth_paraplegiahealth_hearing_losshealth_vision_losshealth_motor_disorderhealth_bronchorespiratoryhealth_infectious_diseasehealth_emotional_disorderhealth_behavioral_disorderhealth_otherhealth_other_specifyhealth_problems_treatmenthealth_diethealth_diet_otherhealth_weighthealth_sleep_patternhealth_sleep_insomniahealth_sleep_nightmareshealth_sleep_terrorshealth_sleep_sleepwalkinghealth_sleep_good_moodhealth_sleep_hourshealth_sleeps_alonehealth_sleeps_specifyhealth_mood_behaviorhealth_mood_otherhealth_current_observationsfamily_health_historyfamily_health_observationsschool_entry_ageattended_kindergartenschools_countteaching_modalitychanges_reasonrepeated_graderepeated_coursesrepeated_reasoncurrent_levellearning_difficultyparticipation_difficultydisruptive_behaviorattends_regularlyattends_gladlyfamily_support_homeworkfriendsfamily_attitudeperformance_assessmentperformance_reasonsresponse_difficultiesresponse_difficulties_otherresponse_successresponse_success_otherrewardsrewards_other
supporterssupporters_other_professionalsexpectationsenvironmentfinal_commentsr0   r1   r2   rn  rn  
  sp	   M	T	>B%0JWua8G40J(T2Lvc{T:w.Itd+I
d
+CGd3NVC[40G6":-EVC[48O#D486#;6M!$6vc{T:t4KdT27T2MdT2-KdT27T2M&+5L%g=&*t4L&*t4L"4$7*04*H' 48$TD9VC[48O6#;6M%fSkDAF3K$7NfSkD9fSkD9F3K$7NfSkD9&+5LF3K$7Ntd3vbzD9F2J6N!'D9w6!&*t<'D1L'D1L7T2M'D1L7T2MGd3N#Gd;#Gd;"7T:"(4"@&,Wt&D#!'D9td3 &w >"7T:g5Gd3N$Wt< &w >!'$!?g5!'$!? &w >$7$7 48g5%+Gd%C"w6"("=$*6":$E!#)&+#E !'D9&,Wt&D#%g=!'$!?'-g'E$'-g'E$'-g'E$&,Wt&D#)/$)G&(.w(F%06w0N-17$1O./5g/M,(.w(F%t4"4$7#)'D#A  &w >!'$!? &w > &w >!'$!?%+Gd%C"#)'D#A #)'D#A $7#)'D#A %g=#F2J>#F2J>%+F2J%F" 5!'$!?Wt4O"7T:w6 48$7"7T: &w > &w > &w >!'$!?'D1L!&+= &td ;d3Kvc{T:6":5M!&*t<"7A6$Wa8!'15 &w :#GQ7r
T: d;"6#;>!&+=vc{T:"("="4$7!'t!<fRj48"7T:6":5MvbzD9D40NGd3NfSkD9TD1O6#;6M 48%g= 48w6Gd3N$Wt<Wt,GVC[48O#F2J> t<"4$7"(t"DdT2#F3K$?TD)G6#;6Mt,J%+D4%@"&*t4Ld3KD40Nr1   rn  c                       e Zd ZdZ eedd      Z eed      Z eed      Z e e	d      d      Z
 e e	d	      d      Z e e	d      d      Z eed      Zy
)AnamnesisInformantModelanamnesis_informantsTr7  FrH   r   r#  r   r   N)r   r   r   r   r   r   r   anamnesis_idr   r   r   relationshippresencer	   interview_dater0   r1   r2   r  r    si    *M	T	>B'E2L+J&+-D&+5LfSkD1HD40Nr1   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      d      Z eed      Zy	)
AnamnesisInterviewerModelanamnesis_interviewersTr7  FrH   r   r#  r   N)r   r   r   r   r   r   r   r  r   r   r   roler	   r  r0   r1   r2   r  r    sU    ,M	T	>B'E2L+JWt4O&+-DD40Nr1   r  c                       e Zd ZdZ eedd      Z eed      Z eed      Z e e	d      d      Z
 e e	d	      d      Z e e	d
      d      Z e e	d	      d      Z e e	d      d      Zy)AnamnesisHouseholdMemberModelanamnesis_household_membersTr7  FrH   r   r#  r   r   r   N)r   r   r   r   r   r   r   r  r   r   r   r  r^  	schooling
occupationr0   r1   r2   r  r    s}    1M	T	>B'E2L+J&+-D&+5L
d
+Cvc{T2Isd3Jr1   r  c                   
   e Zd 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d      Z eedd      Z eedd      Z eed      Z eed      Z eed      Z eed      Zy	)
#ProfessionalDocumentAssignmentModeluU   Asignación documento–estudiante por profesional, curso y período (status_id 0/1).!professional_document_assignmentsTr7  FrH   r   r   N)r   r   r   r:   r   r   r   r   r   rL   r   r   r   r  rf  r  r	   deadline_atr   completed_atr.   r/   r0   r1   r2   r   r     s    _7M	
D	AB51Kw/IWu5O%0Jg6 5!Dw:I-K(T2L40J(T2Lr1   r   c                   V   e Zd 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dd      Z eed      Z e ed	      d      Z e ed
      d      Z eed      Z e ed	      dd      Z eed      Z eed      Z eed      Zy)
AlertModeluL   Alertas in-app (campana): tipo, texto, vínculo a recurso, estatus revisada.alertsTr7  rH   Fr   r   r   r   professional_document_assignmentN)r   r   r   r:   r   r   r   r   r   rP   r   r   reference_idr  rL   r   
alert_typeru   r   r  reference_kindextrar   r.   r/   r0   r1   r2   r%  r%    s    VM	
D	ABw.IWu5Ow/I*u5Lw:I51Kr
U3J6#;.ETD)GF2J@bcN4$'E40J(T2Lr1   r%  N)app.backend.db.databaser   
sqlalchemyr   r   r   r   r   r	   r
   r   r   r   r   r   r   r   r   sqlalchemy.ormr   r   r   r4   r8   r=   rD   rN   rS   rY   r]   rb   rg   rk   ro   rs   rz   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+  r1  r5  r<  rA  rH  rM  rP  rW  r^  ra  rj  rn  rs  rw  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r	  r  r  r  r  r!  r(  r-  r0  rJ  rQ  rU  rY  rk  r  r  r  r  r  r  r  r  r  r  r  r  r'  r6  r:  r=  r@  rG  rW  r]  ra  rd  rh  rn  r  r  r  r   r%  r0   r1   r2   <module>r/     s.   ( \  \  \  \  \ * &D &*&$ &&D && &	&D 	&	&t 	&&d && &	(D 	(
($ 
(&4 &&T && &
& 
&&t &&$ &&$ &	&4 	&$t $ $ $t $2$4 $$4 $$ $$d $
3t 
33d 33t 33t 33$ 3	3t 	33T 334 33T 3$3$ 3"3$ 33T 3$3T 3 3t 3	3d 	3	34 	334 31$ 13d 3	3D 	3
3D 
314 1	3$ 	33D 314 114 134 31$ 1	1t 	11d 114 11$ 11t 11 1 14 1 1t 1 1T 1	3T 	3	3t 	33$ 3	3t 	33 33D 3	$4 	$	$$ 	$3D 33t 33t 3 3 33 33 33$ 3	3$ 	3$ $	3D 	3$D $$4 $$$ $($D $$D $$ $$d $$t $$4 $3$ 3"3 3$/d /3 3@3 3"3t 33 3"$D "$H$14 $1L1D 11D 1	,t 	,	1$ 	124 24h7>T 7>r> > 
$ 
$	34 	3&3 &3P?3 ?3B3T 3$3d 3B3$ 33$ 3$f f(34 (3T3$ 3>34 3	3t 	33t 33d 3
34 
3x1T x1t1d 11 1	4D 	43$ 3$3 3r1   