SSAFY_fesw
Tables (6)
Class (Untitled4)
- id (PK) — int — Primary key — NOT NULL
- location (지역) — char(100)
- class_number (반 번호) — int
- consultant_id (배정 컨설턴트(FK)) — int
Coach (Untitled3)
- id (PK) — int — Primary key — NOT NULL
- name (이름) — char(100)
- task (담당업무) — char(100)
- class_id (배정 반(FK)) — int
- id (PK2) — int — Foreign key → Class.id — NOT NULL
Consultant (Untitled2)
- id (PK) — int — Primary key — NOT NULL
- id (PK2) — int — Foreign key → Class.id — NOT NULL
- name (이름) — char(100)
- task (담당업무) — char(100)
- class_id (배정 반(FK)) — int
Course (Untitled5)
- id (PK) — int — Primary key — NOT NULL
- name (과정 이름) — char(100)
- id (PK2) — int — Foreign key → StudentCourse.id — NOT NULL
Student (Untitled)
- id (PK) — int — Primary key — NOT NULL
- id (PK2) — int — Foreign key → Class.id — NOT NULL
- batch (Field) — int
- is_major (전공자 여부) — boolom
- Fielde (퇴소 여부) — boolom
- id (PK3) — int — Foreign key → StudentCourse.id — NOT NULL
StudentCourse (Untitled6)
- id (PK) — int — Primary key — NOT NULL
- student_id (교육생(FK)) — int
- course_id (교육과정(FK)) — int