SSAFY_daily_HW

Tables (6)

Class (반)

  • 반PK (PK1) — Int — Primary key — NOT NULL
  • 지역PK (PK2) — String, Choice(서울, 대전, 구미, 광주, 부울경) — Primary key — NOT NULL
  • 교육과정PK (cource_id) — bigint — Foreign key → Course.교육과정PK — NOT NULL

Coach (코치)

  • 코치PK (id) — bigint — Primary key — NOT NULL
  • 반PK (class_id) — bigint — Foreign key → Class.반PK — NOT NULL
  • 업무 (todo_id) — bigint — Foreign key → Todo.업무PK — NOT NULL

Consultant (컨설턴트)

  • 컨설턴트PK (id) — bigint — Primary key — NOT NULL
  • 반PK (class_id) — bigint — Foreign key → Class.반PK — NOT NULL
  • 업무PK (todo_id) — bigint — Foreign key → Todo.업무PK — NOT NULL

Course (교육과정)

  • 교육과정PK (id) — bigint — Primary key — NOT NULL
  • 교욱과정내용 (content) — String, Choice(공통, 특화, 자율)

Student (교육생)

  • 교육생PK (PK) — bigint — Primary key — NOT NULL
  • 반PK (class_id) — bigint — Foreign key → Class.반PK — NOT NULL
  • 기수 (cardinal_num) — Int
  • 전공여부 (is_majored_in) — Boolean
  • 퇴소 여부 (is_quit) — Boolean
  • 퇴소일자 (quit_at) — datetime(6)

Todo (업무)

  • 업무PK (id) — bigint — Primary key — NOT NULL
  • 업무내용 (content) — varchar(50)