SSAFY_ERD
Tables (5)
class (Entity4)
- class_id (Key) — int — Primary key — NOT NULL
- region (Field) — varchar(20)
- class_num (Field2) — int
coach (Entity5)
- coach_id (Key2) — int — Primary key — NOT NULL
- class_id (Key) — int — Foreign key → class.class_id — NOT NULL
- name (att3) — varchar(20)
- work (att4) — varchar(20)
consultant (Entity6)
- consultant_id (Key) — int — Primary key — NOT NULL
- class_id (Key2) — int — Foreign key → class.class_id — NOT NULL
- name (Field) — varchar(20)
- work (Field2) — varchar(20)
project (Entity2)
- curriculum_id (Key) — int — Primary key — NOT NULL
- field (att5) — varchar(20)
trainee (Entity1)
- student_id (Key2) — int — Primary key
- curriculum_id (Key4) — int — Foreign key → project.curriculum_id — NOT NULL
- class_id (Key) — int — Foreign key → class.class_id — NOT NULL
- major (att2) — boolean
- cardinal (att1) — int
- name (Field) — varchar(20)
- discharge (Field2) — boolean