Edumanager

Tables (3)

Assignment (Untitled2)

  • assignment_id (Key) — Primary key — NOT NULL
  • type (Field) — lecure 또는 studyGroup 중에 과제가 어느 테이블에 속하는지 명시
  • related_id (Field2)
  • due_date (Field3)
  • description (Field4)
  • title (Field5)

Notice (Untitled3)

  • notice_id (Key) — Primary key — NOT NULL
  • notice_type (Field)
  • related_id (Field2)
  • title (Field3)
  • content (Field4)
  • created_at (Field5)
  • updated_at (Field6)

SpecialSchedule (Untitled)

  • shedule_id — int — Primary key — NOT NULL
  • schedule_type (Field) — VARCHAR(10)
  • relative_id (Field2) — Int
  • date (Field3) — Date
  • title (Field4) — Varchar(40)
  • description (Field5) — Text