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