9기_광주 2반_신성주
테이블 (6)
Class (class)
- Class ID (class_id) — NUM — 기본 키 — NOT NULL
- Number (number) — NUMBER(30)
- Region ID (region_id) — NUM — 외래 키 → Region.Region ID — NOT NULL
- Curriculum ID (curriculum_id) — NUM — 외래 키 → Curriculum.Curriculum ID — NOT NULL
Coach (coach)
- Coach ID (coach_id) — NUM — 기본 키 — NOT NULL
- Name (name) — VARCHAR2(50)
- Task (task) — VARCHAR2(200)
- Class ID (class_id) — NUM — 외래 키 → Class.Class ID — NOT NULL
Consultant (consultant)
- Consultant ID (consultant_id) — NUM — 기본 키 — NOT NULL
- Name (name) — VARCHAR2(50)
- Task (task) — VARCHAR2(200)
- Class ID (class_id) — NUM — 외래 키 → Class.Class ID — NOT NULL
Curriculum (curriculum)
- Curriculum ID (curriculum_id) — NUM — 기본 키 — NOT NULL
- Name (name) — VARCHR2(10)
Region (region)
- Region ID (region_id) — NUM — 기본 키 — NOT NULL
- Name (name) — VARCHAR2(10)
Student (student)
- Student ID (student_id) — NUM — 기본 키 — NOT NULL
- Name (name) — VARCHAR2(50)
- Semester (semester) — NUMBER(2)
- Major (major) — VARRCHAR2(10)
- Retire (retire) — VARCHAR2(10)
- Class ID (class_id) — NUM — 외래 키 → Class.Class ID — NOT NULL