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