수강신청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)