daily1_ERD추출하기
테이블 (8)
Subject (과목)
- subject_id (PK) — int — 기본 키 — NOT NULL
- subject_name (Field) — varchar
class (반)
- class_id (Key) — int — 기본 키 — NOT NULL
- class_number (Field) — int
- local_id (Key2) — int — 외래 키 → local.local_id — NOT NULL
- teacher_id (Key3) — int — 외래 키 → teacher.teacher_id — NOT NULL
- consult_id (Key4) — int — 외래 키 → consultant.consult_id — NOT NULL
consultant (컨설턴트)
- consult_id (PK) — int — 기본 키 — NOT NULL
- consultant_name (Field) — varchar
- work_id (PK2) — int — 외래 키 → work.work_id — NOT NULL
lecture (수강)
- student_id (Key) — int — 외래 키 → student.student_id — NOT NULL
- subject_id (Key2) — int — 외래 키 → Subject.subject_id — NOT NULL
local (지역)
- local_id (PK) — int — 기본 키 — NOT NULL
- local_name (Field) — varchar
student (교육생)
- student_id (PK) — int — 기본 키 — NOT NULL
- semester (Field1) — int
- major (Field2) — boolean
- Expulsion (Field3) — boolean
- class_id (FK) — int — 외래 키 → class.class_id — NOT NULL
teacher (코치)
- teacher_id (PK) — int — 기본 키 — NOT NULL
- teacher_name (Field2) — varchar
- work_id (PK2) — int — 외래 키 → work.work_id — NOT NULL
work (업무)
- work_id (PK) — int — 기본 키 — NOT NULL
- work_name (Field) — varchar