pjt_1
Tables (4)
Student
- Key — Integer — Primary key — NOT NULL
- Key (Key2) — Foreign key → class.pk — NOT NULL
- 교육과정 (education) — String — Foreign key → class.교육과정
- 전공여부 (ismajor) — boolean
- 퇴소여부 (Field2) — boolean
class
- pk — integer — Primary key — NOT NULL
- 교육과정 (education) — String — Primary key
- 지역 (region) — String
- 반 (class_num) — integer
coach
- pk — integer — Primary key — NOT NULL
- pk (pk2) — integer — Foreign key → class.pk — NOT NULL
- 교육과정 (education) — String — Foreign key → class.교육과정
consultant
- pk — integer — Primary key — NOT NULL
- pk (pk2) — integer — Foreign key → class.pk — NOT NULL
- 교육과정 (education) — String — Foreign key → class.교육과정