erd실습
테이블 (4)
Class (Untitled2)
- class_id (class_pk) — INT — 기본 키 — NOT NULL
- area (지역) — CHAR
- class_number (반) — INT
Coach
- coach_id (coach_pk) — INT — 기본 키 — NOT NULL
- name (이름) — VARCHAR
- work (담당업무) — VARCHAR
- class_id (class_pk2) — INT — 외래 키 → Class.class_id — NOT NULL
Consultant (Untitled3)
- consiltant_id (consultannt_pk) — INT — 기본 키 — NOT NULL
- work (담당업무) — VARCHAR
- class_number (담당반) — INT
- Field
- class_id (class_pk) — INT — 외래 키 → Class.class_id — NOT NULL
Student (Untitled)
- id (student_id) — INT — 기본 키 — NOT NULL
- name (이름) — VARCHAR
- Major (전공여부) — BOOLEAN
- retire (퇴소여부) — BOOLEAN
- unit (기수) — INT
- Field5 (교육과정) — CHAR
- class_id (class_pk) — INT — 외래 키 → Class.class_id — NOT NULL