과제
테이블 (4)
Class (class)
- class_id — VARCHAR(255) — 기본 키 — NOT NULL
Coach (coach)
- Coach_id (Key) — BIGINT(11) — 기본 키 — NOT NULL
- coach_task — VARCHAR(255)
- class_id (Field) — VARCHAR(255)
- class_id — VARCHAR(255) — 외래 키 → Class.class_id — NOT NULL
Consultant (consultant)
- Consultant_id — BIGINT(11) — 기본 키 — NOT NULL
- consultant_task — VARCHAR(255)
- class_id (Field) — VARCHAR(255)
- class_id — VARCHAR(255) — 외래 키 → Class.class_id — NOT NULL
Student (student)
- student_id — BIGINT(11) — 기본 키 — NOT NULL
- unit — VARCHAR(255)
- major — VARCHAR(255)
- retireTF (Field) — VARCHAR(255)
- curriculum — VARCHAR(255)
- class_id (Field2) — VARCHAR(255)
- class_id — VARCHAR(255) — 외래 키 → Class.class_id — NOT NULL