
    Ni=                     2   S SK Jr  S SKJrJrJr  S SKJrJrJ	r	J
r
Jr  S SKJrJr  S SKJrJr  \" 5       r " S S\R$                  5      r " S S	\R$                  5      r " S
 S\R$                  5      r " S S\R$                  5      r " S S\R$                  5      r " S S\R$                  5      r " S S\R$                  5      r/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQS ./ S!Q/ S"Q/ S#Q/ S$Q/ S%Q/ S&Q/ S'Q/ S(Q/ S)Q/ S*Q/ S+Q/ S,QS .S-.rg.)/    )
SQLAlchemy)Mappedmapped_columnrelationship)IntegerStringJSON
ForeignKeyBoolean)datetimetimezone)generate_password_hashcheck_password_hashc                   D   \ rS rSr% Sr\" \" 5       SSS9r\\	   \
S'   \" \" S5      SS9r\\   \
S	'   \" \" S5      SSS
9r\\   \
S'   \" \" S5      SS9r\\   \
S'   \" \" 5       SSS9r\\   \
S'   \" \" S5      SS9r\\   \
S'   \" SSSS9r\" SSSS9rS rS rSrg)SchoolTable	   schoolsTprimary_keyautoincrementid   Fnullableschool_namer   unique	school_id2   streamr   default
isLoggedIn   passwordTeacherTableschoolzall, delete)back_populatescascadeStudentTablec                 $    [        U5      U l        g Nr   r%   selfr%   s     ,D:\beyond school\SolveSmartBackend\models.pyset_passwordSchoolTable.set_password       .x8    c                 .    [        U R                  U5      $ r,   r   r%   r.   s     r0   check_passwordSchoolTable.check_password       "4==(;;r4   r%   N)__name__
__module____qualname____firstlineno____tablename__r   r   r   r   int__annotations__r   r   strr   r    r   r#   boolr%   r   teachersstudentsr1   r7   __static_attributes__ r4   r0   r   r   	   s    M#GI4tTBsT,VC[5IKI*6#;tTIvc{T'r
UCFF3KC,WYPUVJtV)&+EHfSkEN8][HN8][H9<r4   r   c                      \ rS rSr% Sr\" \" 5       SSS9r\\	   \
S'   \" \" S5      SS9r\\   \
S	'   \" \" S5      SS9r\\   \
S
'   \" \" S5      SSS9r\\   \
S'   \" \" S5      SS9r\\   \
S'   \" \SS9r\\\      \
S'   \" S S9r\\   \
S'   \" S S9r\\   \
S'   \" \" 5       SSS9r\\   \
S'   \" \" S5      SS9r\\	   \
S'   \" SSS9rS rS rSr g)r&      rD   Tr   r   r$   Fr   	firstnamelastname   r   usernamer%   gradesc                  J    [         R                  " [        R                  5      $ r,   r   nowr   utcrG   r4   r0   <lambda>TeacherTable.<lambda>%       hllA[r4   r"   
created_atc                  J    [         R                  " [        R                  5      $ r,   rP   rG   r4   r0   rS   rT   &   s    (,,x||B\r4   
last_loginr"   r   r#   
schools.idr   r   r(   c                      [        US9U l        g )Nr:   r-   r.   s     r0   r1   TeacherTable.set_password,   s    .Ar4   c                 .    [        U R                  U5      $ r,   r6   r.   s     r0   r7   TeacherTable.check_password/   r9   r4   r:   N)!r;   r<   r=   r>   r?   r   r   r   r   r@   rA   r   rJ   rB   rK   rM   r%   r	   rN   listdictrW   r   rY   r   r#   r
   r   r   r'   r1   r7   rF   rG   r4   r0   r&   r&      s   M#GI4tTBsT*6#;GIvc{G)&+EHfSkE)&+dSHfSkS)&+FHfSkF!.te!DFF4:D#09[#\Jx \#0:\#]Jx ]+GIuuUJsU*:l+CeTIvc{T-
CFB<r4   r&   c                      \ rS rSr% Sr\" \" 5       SSS9r\\	   \
S'   \" \" S5      SSS9r\\   \
S	'   \" \" S
5      SS9r\\   \
S'   \" \" S5      SS9r\\   \
S'   \" \" S5      SS9r\\   \
S'   \" \" S5      SSS9r\\   \
S'   \" \" 5       SSS9r\\	   \
S'   \" \" 5       SSS9r\\	   \
S'   \" \" 5       SSS9r\\	   \
S'   \" \" S5      SS9r\\   \
S'   \" \" S
5      SS9r\\   \
S'   \" \" 5       SS9r\\	   \
S'   \" S S 9r\\   \
S!'   \" S" S 9r\\   \
S#'   \" \" 5       SSS$9r\\   \
S%'   \" \" S&5      SS9r\\	   \
S''   \" S(SS)9r S* r!S+ r"S,r#g-).r*   r   rE   Tr   r      Fr   rM   r$   r   r%   
   grade   section   u   👨‍🎓r!   avatari  coins(   gems   streakr   rJ   rK   roll_noc                  J    [         R                  " [        R                  5      $ r,   rP   rG   r4   r0   rS   StudentTable.<lambda>A   rU   r4   rV   rW   c                  J    [         R                  " [        R                  5      $ r,   rP   rG   r4   r0   rS   rr   B   rU   r4   rY   rZ   r#   r[   r   r   r\   c                 $    [        U5      U l        g r,   r-   r.   s     r0   r1   StudentTable.set_passwordH   r3   r4   c                 .    [        U R                  U5      $ r,   r6   r.   s     r0   r7   StudentTable.check_passwordK   r9   r4   r:   N)$r;   r<   r=   r>   r?   r   r   r   r   r@   rA   r   rM   rB   r%   rf   rh   rj   rk   rm   ro   rJ   rK   rp   rW   r   rY   r   r#   r
   r   r   r'   r1   r7   rF   rG   r4   r0   r*   r*   2   s   M#GI4tTBsT)&*uTRHfSkR)&+FHfSkF&vbzEBE6#;B(UCGVC[C'r
UMZFF3KZ&wy5#NE6#;N%gi%LD&+L'	E1MFF3KM*6#;GIvc{G)&+EHfSkE(UCGVC[C#09[#\Jx \#09[#\Jx \+GIuuUJsU*:l+CeTIvc{T-
CF9<r4   r*   c                   r   \ rS rSr% Sr\" \" 5       SSS9r\\	   \
S'   \" \" S5      SS9r\\	   \
S	'   \" \" S
5      SS9r\\	   \
S'   \" \" S5      SS9r\\   \
S'   \" \" S5      SS9r\\   \
S'   \" \SS9r\\\      \
S'   \" \SS9r\\\      \
S'   \" S S9r\\   \
S'   \" S5      r\" S5      rSrg)TeacherAssessmentTableN   teacher_assessmentsTr   r   r[   Fr   r   zteachers.id
created_byre   rf   rh   concepts	questionsc                  J    [         R                  " [        R                  5      $ r,   rP   rG   r4   r0   rS   TeacherAssessmentTable.<lambda>X   rU   r4   rV   rW   r   r&   rG   N)r;   r<   r=   r>   r?   r   r   r   r   r@   rA   r
   r   r|   r   rf   rB   rh   r	   r}   ra   r~   rb   rW   r   r   r'   teacherrF   rG   r4   r0   ry   ry   N   s    )M#GI4tTBsT*:l+CeTIvc{T+J},EPUVJsV&vbzEBE6#;B(eDGVC[D"/u"EHfT#YE$1$$GIvd4j!G#09[#\Jx \-(F>*Gr4   ry   c                   `   \ rS rSr% Sr\" \" 5       SSSS9r\\	   \
S'   \" \" S5      SS9r\\	   \
S	'   \" \" S
5      SS9r\\	   \
S'   \" \" S5      SS9r\\   \
S'   \" \" S5      SS9r\\   \
S'   \" \" S5      SS9r\\	S-     \
S'   \" \SS9r\\\      \
S'   \" S S9r\\   \
S'   Srg)StudentAssesmentResultTable]   student_assesment_resultsFT)r   r   r   r   zstudents.idr   
student_idr[   r   re   rf   rh   zteacher_assessments.idNassesment_idconcept_detailc                  J    [         R                  " [        R                  5      $ r,   rP   rG   r4   r0   rS   $StudentAssesmentResultTable.<lambda>g   s    8<<PXP\P\C]r4   rV   submitted_atrG   )r;   r<   r=   r>   r?   r   r   r   r   r@   rA   r
   r   r   r   rf   rB   rh   r   r	   r   ra   rb   r   r   rF   rG   r4   r0   r   r   ]   s    /M#GI$^bcBsc+J},EPUVJsV*:l+CeTIvc{T&vbzEBE6#;B(eDGVC[D'4Z@X5Ydh'iL&t$i)6te)LNF4:&L%2;]%^L&"^r4   r   c                   P   \ rS rSr% Sr\" \" 5       SSS9r\\	   \
S'   \" \" S5      SS9r\\   \
S	'   \" \" S5      5      r\\   \
S
'   \" \" 5       SSS9r\\   \
S'   \" \" S5      SSS9r\\   \
S'   \" \" S5      SS9r\\   \
S'   \" \" S5      SS9r\\	   \
S'   S rS rSrg)PrincipalTablei   
principalsTr   r   r   Fr   rJ   rK   r!   r#   r$   r   rM   r%   r[   r   c                 $    [        U5      U l        g r,   r-   r.   s     r0   r1   PrincipalTable.set_passwordt   r3   r4   c                 .    [        U R                  U5      $ r,   r6   r.   s     r0   r7   PrincipalTable.check_passwordw   r9   r4   r:   N)r;   r<   r=   r>   r?   r   r   r   r   r@   rA   r   rJ   rB   rK   r   r#   rC   rM   r%   r
   r   r1   r7   rF   rG   r4   r0   r   r   i   s     M#GI4tTBsT*6#;GIvc{G)&+6HfSk6,WYPUVJtV)&+dSHfSkS)&+FHfSkF*:l+CeTIvc{T9<r4   r   c                   d   \ rS rSrSr\R                  \R                  SS9r\R                  \R                  S5      SS9r
\R                  \R                  S5      SS9r\R                  \R                  S5      SS9r\R                  \R                  5      r\R                  S	S
S5      4rSrg)Conceptz   z0Concepts/topics for different grades and streamsT)r   d   Fr   ri   idx_grade_streamrf   r    rG   N)r;   r<   r=   r>   __doc__dbColumnr   r   r   namerf   r    TextdescriptionIndex__table_args__rF   rG   r4   r0   r   r   z   s    :	2::4	0B99RYYs^e94DIIbiimeI4EYYryy}uY5F))BGG$K 	#Wh7Nr4   r   )zCounting 1-100zNumber RecognitionzBefore and After NumberszGreater and SmallerzAddition (1-10)zSubtraction (1-10)zShapes and PatternszLength and HeightzWeight ComparisonzDays and MonthszTime (Hours)zMoney (Coins))zCounting 1-1000zPlace Value (Ones, Tens)zSkip CountingzAddition (1-50)zSubtraction (1-50)zIntroduction to MultiplicationzEven and Odd Numbersz2D and 3D ShapeszMeasurement (cm, m)zTime (Half Hours)zMoney (Notes and Coins)zData Handling (Pictographs))zNumbers up to 10,000z!Place Value (Hundreds, Thousands)"Addition and Subtraction (3-digit)zMultiplication Tables (2-10)zDivision BasicszFractions (Half, Quarter)zSimple PatternszPerimeter and Area BasicszTime (Minutes)zMoney Problemsz
Bar GraphsSymmetry)zNumbers up to 1,00,000zRoman NumeralszFactors and Multiplesz"Addition and Subtraction (4-digit)u#   Multiplication (2-digit × 2-digit)zDivision (Long Division)z#Fractions (Proper, Improper, Mixed)zDecimals IntroductionzAngles and LinesPerimeter and AreazTime ProblemsMoney Word ProblemszData Handling (Tables))zLarge Numbers (Lakhs, Crores)zPrime and Composite NumberszHCF and LCMzFour Operations (Large Numbers)zFractions (All Operations)zDecimals (Operations)zPercentages BasicszRatio and Proportion IntrozSimple Interest BasicszPerimeter and Area (Complex)zVolume BasicszCoordinate Geometry IntrozData InterpretationzAverage and Mean)Whole NumbersIntegers	FractionsDecimalsData HandlingMensurationAlgebraRatio and Proportion)r   Fractions and Decimalsr   zSimple EquationsLines and Angles	Triangles
Congruencer   )Rational NumbersLinear EquationsQuadrilateralsr   Squares and Square RootsCubes and Cube RootszComparing QuantitiesAlgebraic Expressions)zNumber SystemsPolynomialsCoordinate Geometryz!Linear Equations in Two VariableszEuclid's Geometryr   r   r   z%Areas of Parallelograms and TrianglesCirclesConstructionszHeron's FormulaSurface Areas and Volumes
StatisticsProbability)zReal Numbersr   z)Pair of Linear Equations in Two VariablesQuadratic EquationszArithmetic Progressionsr   r   Trigonometryr   r   zAreas Related to Circlesr   r   r   )SetsRelations and FunctionszTrigonometric FunctionsMathematical InductionzComplex NumberszLinear InequalitiesPermutations and CombinationsBinomial TheoremSequences and SerieszStraight LineszConic SectionszIntroduction to 3D GeometryLimits and Derivativesr   r   )r   zInverse Trigonometric FunctionsMatricesDeterminantsz Continuity and DifferentiabilityzApplications of Derivatives	IntegralszApplications of IntegralszDifferential EquationszVector Algebraz3D GeometryzLinear Programmingr   )123456789101112)zNumbers 1-100zCounting and Number NameszBefore, After, BetweenzComparison of NumberszAddition Facts (1-10)zSubtraction Facts (1-10)zBasic ShapesPatternszMeasurement (Longer, Shorter)zCalendar BasicszTime (O'clock)zMoney Recognition)zNumbers up to 1000zPlace Value (Tens, Ones)zOrdinal NumberszAddition (2-digit)zSubtraction (2-digit)zTimes Tables (2, 5, 10)zOdd and EvenzGeometry ShapeszLength (Inches, Feet)zTime (Half Past)zMoney (Paise, Rupees)zSimple Graphs)zNumbers up to 9999zPlace Value ChartzRounding Numbersr   u#   Multiplication (1-digit × 2-digit)zDivision ConceptszIntroduction to FractionszPatterns and SequenceszPerimeter of ShapeszCapacity (Liters)zTime Durationr   zPictographs and Bar Charts)zLarge Numbers (Lakhs)zRoman Numerals (I-C)zMultiples and FactorszLong MultiplicationzLong DivisionzEquivalent FractionszDecimals (Tenths)r   zArea and PerimeterzTime (12-hour and 24-hour)zMoney Calculationsz!Data Handling (Charts and Graphs))zLarge Numbers (Crores)zPrime and CompositezTests of DivisibilityzFractions (Mixed Operations)zDecimals (All Operations)zIntroduction to PercentagesSimple InterestUnitary Methodr   z$Geometry (Triangles, Quadrilaterals)zVolume and CapacityzSymmetry and ReflectionzStatistics Basics)zNatural Numbersr   r   r   r   r   r   
PercentagezProfit and Lossr   zBasic Geometrical Conceptsr   zPractical Geometryr   )r   r   r   	Exponentsr   r   r   Profit, Loss and Discountr   zFundamental Conceptsr   r   r   
Congruencyr   )r   zDirected Numbersr   r   r   r   r   zSimple and Compound InterestzDirect and Inverse VariationsFactorisationr   r   r   )zRational and Irrational NumberszCompound Interest
ExpansionsFactorizationszSimultaneous Linear EquationsIndices
Logarithmsr   zMean and Medianr   r   r   )zCommercial Mathematicsr   r   r   
SimilarityLocir   r   r   
Histogramsr   )r   r   r   r   r   r   r   r   r   r   r   r   )	r   z%Logarithmic and Exponential FunctionszQuadratic Functionsr   r   r   CalculuszProbability DistributionszSampling Theory)CBSEICSEN)flask_sqlalchemyr   sqlalchemy.ormr   r   r   
sqlalchemyr   r   r	   r
   r   r   r   werkzeug.securityr   r   r   Modelr   r&   r*   ry   r   r   r   CONCEPTS_DATArG   r4   r0   <module>r      s'   ' > > A A ' I\<"(( <&<288 <,<288 <8+RXX +
_"(( 
_<RXX <"bhh *




@S'+

F
Uw?D




5

:V"}BCDr4   