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)