i-스스로
테이블 (9)
Assignment (Untitled4)
- id (Key) — number — 기본 키 — 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 — 외래 키 → Tag.id — NOT NULL
- assignmentId (Key3) — number — 외래 키 → Assignment.id — NOT NULL
- titme (Field3) — string — 외래 키 → Assignment.titme
- createdAt (Field) — datetime
- updatedAt (Field2) — datetime
Class (Untitled2)
- id (Key) — number — 기본 키 — NOT NULL
- school (Field) — string
- grade (Field2) — string
- class (Field3) — string
- createdAt (Field4) — datetime
- updatedAt (Field5) — datetime
ClassUser (Untitled3)
- classId (Key1) — number — 외래 키 → Class.id — NOT NULL
- userId (Key2) — number — 외래 키 → User.id — NOT NULL
- attendanceNumber (Field) — number
- craetedAt (Field2) — datetime
- updatedAt (Field3) — datetime
Tag (Untitled9)
- id (Key) — number — 기본 키 — NOT NULL
- name (Field) — string
- createdAt (Field2) — datetime
- updatedAt (Field3) — datetime
User (Untitled)
- id (Key) — number — 기본 키 — 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 — 외래 키 → Assignment.id — NOT NULL
- userId (Key2) — number — 외래 키 → User.id — NOT NULL
- titme (Field7) — string — 외래 키 → Assignment.titme
- title (Field) — string
- content (Field2) — string
- state (Field3) — enum
- submittedAt (Field4) — datetime
- createdAt (Field5) — datetime
- updatedAt (Field6) — datetime
UserTaskComment (Untitled6)
- id (Key) — number — 기본 키 — NOT NULL
- assignmentId (Key1) — number — 외래 키 → UserTask.assignmentId — NOT NULL
- userId (Key2) — number — 외래 키 → UserTask.userId — NOT NULL
- content (Field) — string
- createdAt (Field2) — datetime
- updatedAt (Field3) — datetime
- titme (Field7) — string — 외래 키 → UserTask.titme
UserTaskImage (Untitled7)
- id (Key) — number — 기본 키 — NOT NULL
- userId (Key2) — number — 외래 키 → UserTask.userId — NOT NULL
- assignmentId (Key1) — number — 외래 키 → UserTask.assignmentId — NOT NULL
- content (Field) — byte
- createdAt (Field2) — datetime
- updatedAt (Field3) — datetime
- titme (Field7) — string — 외래 키 → UserTask.titme