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