Assignment

Tables (9)

Assignment (Untitled4)

  • id (Key) — number — Primary key — NOT NULL
  • titme (Field) — string
  • descriptiin (Field2) — string
  • type (Field3) — enum
  • madeBy (Field4) — number
  • startDate (Field5) — date
  • endDate (Field6) — date
  • createdAt (Field7) — datetime
  • updatedAt (Field8) — datetime

AssignmentTag (Untitled8)

  • tagId (Key2) — number — Foreign key → Tag.id — NOT NULL
  • assignmentId (Key3) — number — Foreign key → Assignment.id — NOT NULL
  • createdAt (Field) — datetime
  • updatedAt (Field2) — datetime

Class (Untitled2)

  • id (Key) — number — Primary key — NOT NULL
  • school (Field) — string
  • grade (Field2) — string
  • class (Field3) — string
  • createdAt (Field4) — datetime
  • updatedAt (Field5) — datetime

ClassUser (Untitled3)

  • classId (Key1) — number — Foreign key → Class.id — NOT NULL
  • userId (Key2) — number — Foreign key → User.id — NOT NULL
  • attendanceNumber (Field) — number
  • craetedAt (Field2) — datetime
  • updatedAt (Field3) — datetime

Tag (Untitled9)

  • id (Key) — number — Primary key — NOT NULL
  • name (Field) — string
  • createdAt (Field2) — datetime
  • updatedAt (Field3) — datetime

User (Untitled)

  • id (Key) — number — Primary key — NOT NULL
  • loginId (Field) — string
  • name (Field2) — string
  • authorization (Field3) — enum
  • password (Field4) — string
  • createdAt (Field5) — datatime
  • updatedAt (Field6) — datetime

UserTask (Untitled5)

  • assignmentId (Key1) — number — Foreign key → Assignment.id — NOT NULL
  • userId (Key2) — number — Foreign key → User.id — NOT NULL
  • title (Field) — string
  • content (Field2) — string
  • state (Field3) — enum
  • submittedAt (Field4) — datetime
  • createdAt (Field5) — datetime
  • updatedAt (Field6) — datetime

UserTaskComment (Untitled6)

  • id (Key) — number — Primary key — NOT NULL
  • assignmentId (Key1) — number — Foreign key → UserTask.assignmentId — NOT NULL
  • userId (Key2) — number — Foreign key → UserTask.userId — NOT NULL
  • content (Field) — string
  • createdAt (Field2) — datetime
  • updatedAt (Field3) — datetime

UserTaskImage (Untitled7)

  • id (Key) — number — Primary key — NOT NULL
  • userId (Key2) — number — Foreign key → UserTask.userId — NOT NULL
  • assignmentId (Key1) — number — Foreign key → UserTask.assignmentId — NOT NULL
  • cotent (Field) — byte
  • createdAt (Field2) — datetime
  • updatedAt (Field3) — datetime