naverCloud_practice1
Tables (5)
department
- dep_id — VARCHAR(10) — Primary key — NOT NULL
- dep_name — VARCHAR(10)
enroll
- sub_id — INT — Foreign key → subject.sub_id — NOT NULL
- stu_id — INT — Foreign key → student.stu_id — NOT NULL
professor
- prof_id — INT — Primary key — NOT NULL
- dep_id — VARCHAR(10) — Foreign key → department.dep_id — NOT NULL
- prof_name — VARCHAR(10)
student
- stu_id — INT — Primary key — NOT NULL
- dep_id — VARCHAR(10) — Foreign key → department.dep_id — NOT NULL
- stu_name — VARCHAR(10) — NOT NULL
- height — DECIMAL(3, 1)
subject
- sub_id — INT — Primary key — NOT NULL
- sub_name — VARCHAR(15)
- start_date — DATE
- end_date — DATE