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