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