ProblemTImer
Tables (15)
Academies (Untitled6)
- Id (PK) — INTEGER — Primary key — NOT NULL
- Name (FK) — VARCHAR(30)
Assignments (Untitled8)
- Id (PK) — INTEGER — Primary key — NOT NULL
- BookId (Field6) — INTEGER — Foreign key → Books.Id — NOT NULL
- PageFrom (Field) — INTEGER
- PageTo (Field2) — INTEGER
- NumberFrom (Field3) — VARCHAR(20)
- NumberTo (Field4) — VARCHAR(20)
- DueDate (Field5) — TIMESTAMP
- assignedAt (Field7) — TIMESTAMP
- ClassroomName (Field31) — VARCHAR(30) — Foreign key → Classrooms.Name — NOT NULL
- TeacherId (Field32) — INTEGER — Foreign key → Teachers.Id — NOT NULL
- StudentId (Field33) — INTEGER — Foreign key → Students.Id — NOT NULL
BookUnits1 (Untitled7)
- Id (PK) — INTEGER — Primary key — NOT NULL
- Unit1Name (Field5) — VARCHAR(30)
- Unit1StartPage (Field) — INTEGER
- Unit1EndPage (Field3) — INTEGER
- Unit1StartNumber (Field2) — VARCHAR(20)
- Unit1EndNumber (Field4) — VARCHAR(20)
- BookId (Field31) — INTEGER — Foreign key → Books.Id — NOT NULL
- Unit1Number (Field32) — INTEGER
BookUnits2 (CopyOfUntitled7)
- Id (PK) — INTEGER — Primary key — NOT NULL
- Unit2Name (Field5) — VARCHAR(30)
- Unit2StartPage (Field) — INTEGER
- Unit2EndPage (Field3) — INTEGER
- Unit2StartNumber (Field2) — VARCHAR(20)
- Unit2EndNumber (Field4) — VARCHAR(20)
- BookId (Field31) — INTEGER — Foreign key → Books.Id — NOT NULL
- Unit1Number (Field32) — INTEGER
- Unit2Number (Field33) — INTEGER
Books (Untitled4)
- Id (PK) — INTEGER — Primary key — NOT NULL
- School (Field) — INTEGER
- Subject (Field2) — INTEGER
- Name (Field3) — VARCHAR(20)
Classrooms (Untitled2)
- Name (PK) — VARCHAR(30) — Primary key — NOT NULL
- TeacherId (PK3) — INTEGER — Foreign key → Teachers.Id — NOT NULL
- StudentId (PK2) — INTEGER — Foreign key → Students.Id — NOT NULL
Problems (Untitled9)
- Id (PK) — INTEGER — Primary key — NOT NULL
- Answer (Field4) — VARCHAR(20)
- BookId (Field31) — INTEGER — Foreign key → Books.Id — NOT NULL
- Page (Field32) — INTEGER
- Number (Field33) — VARCHAR(20)
RecordStatistics (Untitled12)
- Id (PK) — INTEGER — Primary key — NOT NULL
- TimeRecordAvg (Field2) — Decimal(3,1)
- TimeRecordSd (Field3) — Decimal(2,1)
- CorrectAnswerRateAvg (Field4) — Decimal(3.1)
- Dificulty (Field5) — INTEGER
- ProblemId (Field31) — INTEGER — Foreign key → Problems.Id — NOT NULL
RecordsByProblem (Untitled10)
- Id (PK) — INTEGER — Primary key — NOT NULL
- TimeRecord (Field) — Decimal(3,1)
- RecordedAt (Field2) — TIMESTAMP
- IsSolved (Field3) — INTEGER
- StudentId (Field5) — INTEGER — Foreign key → Students.Id — NOT NULL
- ProblemId (Field31) — INTEGER — Foreign key → Problems.Id — NOT NULL
Schools (CopyOfUntitled3)
- Id (PK) — INTEGER — Primary key — NOT NULL
- apiId (Field31) — INTEGER
- Address (Field2) — VARCHAR(20)
- Name (Field3) — VARCHAR(20)
ScoreByUnit2 (Untitled14)
- Id (Key) — INTEGER — Primary key — NOT NULL
- Score (Field) — Decimal(1,1)
- StudentId (Field32) — INTEGER — Foreign key → Students.Id — NOT NULL
- BookUnit2Id (Field31) — INTEGER — Foreign key → BookUnits2.Id — NOT NULL
ScoreStatistics (Untitled13)
- Id (PK) — Primary key — NOT NULL
- Avg (Field) — Decimal(5,1)
- Sd (Field2) — Decimal(2,1)
- BookUnit2Id (Field31) — INTEGER — Foreign key → BookUnits2.Id — NOT NULL
StudentBooks (Untitled5)
- BookId (PK) — INTEGER — Foreign key → Books.Id — NOT NULL
- StudentId (PK2) — INTEGER — Foreign key → Students.Id — NOT NULL
- AddedAt (Field) — TIMESTAMP
Students (Untitled3)
- Id (PK) — INTEGER — Primary key — NOT NULL
- SchoolId (Field31) — INTEGER — Foreign key → Schools.Id — NOT NULL
- email (Field) — VARCHAR(20)
- Name (Field2) — VARCHAR(20)
- Grade (Field4) — INTEGER
Teachers (Untitled)
- Id (Key) — INTEGER — Primary key — NOT NULL
- email (Field) — VARCHAR(20)
- Name (Field2) — VARCHAR(20)
- academyId (PK) — INTEGER — Foreign key → Academies.Id — NOT NULL