수강신청ERD

테이블 (5)

department

  • dpt_id — varchar(30) — 기본 키 — NOT NULL
  • dpt_name — varchar(30)
  • dpt_college — varchar(30)

lecture

  • lct_id — varchar(30) — 기본 키 — NOT NULL
  • lct_name — varchar(30)
  • lct_classification — varchar(30)
  • lct_time — varchar(30)
  • lct_level — int
  • lct_credit — int
  • lct_capacity — int
  • lct_room — varchar(30)
  • pfs_id — int — 외래 키 → professor.pfs_id — NOT NULL

professor

  • pfs_id — int — 기본 키 — NOT NULL
  • pfs_name — varchar(30)
  • pfs_position — varchar(30)
  • dpt_id — varchar(30) — 외래 키 → department.dpt_id — NOT NULL

student

  • std_id — int — 기본 키 — NOT NULL
  • std_name — varchar(30)
  • std_grade — int
  • std_semester — int
  • std_credit — int
  • dpt_id — varchar(30) — 외래 키 → department.dpt_id — NOT NULL

taking_course

  • std_id — int — 외래 키 → student.std_id — NOT NULL
  • lct_id — varchar(30) — 외래 키 → lecture.lct_id — NOT NULL
  • tkc_retake — int
  • tkc_grade — varchar(30)