SSAFY
Tables (7)
Class
- cls_id (Key) — int — Primary key — NOT NULL
- region_id (Key3) — integer — Foreign key → Region.region_id — NOT NULL
- coach_id (Key2) — integer — Foreign key → Coach.coach_id — NOT NULL
- consultant_id (Key22) — integer — Foreign key → Consultant.consultant_id — NOT NULL
- cls_number (Field) — integer
Coach (Entity1)
- coach_id (Key) — integer — Primary key — NOT NULL
- coach_name (att1) — character varying
- coach_task (att2) — character varying
Consultant (Entity5)
- consultant_id (Key2) — integer — Primary key — NOT NULL
- consultant_name (attr3) — character varying
- consultant_task (attr4) — character varying
Course (Entity6)
- course_id (Key) — integer — Primary key — NOT NULL
- course_name (attr7) — character varying
Region (Entity2)
- region_id (Key) — integer — Primary key — NOT NULL
- region_name (attr5) — character varying
Student (Untitled)
- student_id (Key) — integer — Primary key — NOT NULL
- year_id (Key2) — integer — Foreign key → Year.year_id — NOT NULL
- course_id (Key3) — integer — Foreign key → Course.course_id — NOT NULL
- cls_id (Key4) — int — Foreign key → Class.cls_id — NOT NULL
- region_id (Key32) — integer — Foreign key → Class.region_id — NOT NULL
- coach_id (Key22) — integer — Foreign key → Class.coach_id — NOT NULL
- consultant_id (Key222) — integer — Foreign key → Class.consultant_id — NOT NULL
- student_name (Field) — character varying
- is_graduate (Field2) — boolean
- is_major (Field3) — boolean
Year (Entity3)
- year_id (Key) — integer — Primary key — NOT NULL
- year_number (attr6) — integer