day2
Tables (6)
Class
- class_pk — bigint — Primary key — NOT NULL
- cs_pk — bigint — Foreign key → Consultant.cs_pk — NOT NULL
- location — varchar(3)
- cl_num — varchar
- coach — co_pk
Coach
- co_pk — bigint — Primary key — NOT NULL
- name — varchar
Consultant
- cs_pk — bigint — Primary key — NOT NULL
- name — varchar(10)
- task — varchar
Curriculum
- cus_pk (cur_pk) — bigint — Primary key — NOT NULL
- curr — varchar
- classify — varchar
Student
- st_num — varchar(10) — Primary key — NOT NULL
- class_pk — bigint — Foreign key → Class.class_pk — NOT NULL
- cs_pk — bigint — Foreign key → Class.cs_pk — NOT NULL
- gisu (기수) — varchar(2)
- name — varchar(10)
- major (관련 전공 여부) — varchar(1)
- discharge (퇴소 여부) — varchar(1)
Task
- task_pk — bigint — Primary key — NOT NULL
- cs_pk — bigint — Foreign key → Consultant.cs_pk — NOT NULL
- co_pk — bigint — Foreign key → Coach.co_pk — NOT NULL
- task — varchar