pjt 22
Tables (6)
Class (class)
- Campus (campus) — VARCHAR(25) — Primary key — NOT NULL
- Num (num) — INT(10) — Primary key — NOT NULL
- No (coach_no) — VARCHAR(25) — Foreign key → Coach.No — NOT NULL
- No (consultant_no) — VARCHAR(25) — Foreign key → Consultant.No — NOT NULL
- Field
Coach (coach)
- No (no) — VARCHAR(25) — Primary key — NOT NULL
- Job_Code (job_code) — VARCHAR(25) — Foreign key → Job.Code — NOT NULL
Consultant (consultant)
- No (no) — VARCHAR(25) — Primary key — NOT NULL
- Job_Code (job_code) — VARCHAR(25) — Foreign key → Job.Code — NOT NULL
Course (course)
- Course (course) — VARCHAR(25) — Primary key — NOT NULL
Job (job)
- Code (code) — VARCHAR(25) — Primary key — NOT NULL
Student (student)
- No (no) — VARCHAR(25) — Primary key — NOT NULL
- Campus (campus) — VARCHAR(25) — Foreign key → Class.Campus — NOT NULL
- Num (num) — INT(10) — Foreign key → Class.Num — NOT NULL
- No (no2) — VARCHAR(25) — Foreign key → Class.No — NOT NULL
- Course (course) — VARCHAR(25) — Foreign key → Course.Course — NOT NULL
- Year (year) — int(10) — NOT NULL
- MajorYN (majorYn) — VARCHAR(10)
- attendYN (attendYn) — VARCHAR(10)