SSAFY
Tables (5)
Class (Entity4)
- ClassID (KEY) — INT — Primary key
- Region (attr1) — VARCHAR(20)
- ClassNumber (attr2) — INT
Coach (Entity3)
- CoachID (KEY) — INT — Primary key
- ClassID (KEY2) — INT — Foreign key → Class.ClassID
- Name (attr1) — VARCHAR(50)
- Task (attr2) — VARCHAR(100)
Consultant (Entity2)
- ConsultantID (KEY) — INT — Primary key
- ClassID (KEY2) — INT — Foreign key → Class.ClassID
- Name (attr1) — VARCHAR(50)
- Task (attr2) — VARCHAR(100)
Curriculum (Entity5)
- curriculumID (KEY) — INT — Primary key
- Field2 (attr1) — VARCHAR(20)
Student (Entity1)
- StudentID (KEY) — INT — Primary key
- curriculumID (KEY2) — INT — Foreign key → Curriculum.curriculumID
- ClassID (KEY3) — INT — Foreign key → Class.ClassID
- Name (attr1) — VARCHAR(50)
- ClassYear (attr2) — INT
- Major (attr3) — BOOLEAN
- Graduated (attr4) — BOOLEAN