ㅁ

Tables (7)

class

  • 반고유번호 (class_seq) — INT — Primary key
  • 코치고유번호 (coach_seq) — INT — Foreign key → coach.코치고유번호 — NOT NULL
  • 컨설턴트고유번호 (consultant_seq) — INT — Foreign key → consultant.컨설턴트고유번호

coach

  • 코치고유번호 (coach_seq) — INT — Primary key — NOT NULL
  • 담당업무고유번호 (work_seq) — INT — Foreign key → work.담당업무고유번호 — NOT NULL
  • 코치이름 (name) — String
  • 담당반 (class_seq) — INT — NOT NULL

consultant

  • 컨설턴트고유번호 (consultant_seq) — INT — Primary key — NOT NULL
  • 담당업무고유번호 (work_seq) — INT — Foreign key → work.담당업무고유번호 — NOT NULL
  • 컨설턴트이름 (name) — String
  • 담당반 (class_seq) — INT — NOT NULL

curriculum (process)

  • 교육과정고유번호 (curriculum_seq) — INT — Primary key — NOT NULL
  • 교육과정이름 (curriculum_name) — String

location

  • 지역고유번호 (location_seq) — INT — Primary key — NOT NULL
  • 지역이름 (location_name) — String

student

  • 학생고유번호 (student_seq) — INT — Primary key — NOT NULL
  • 반고유번호 (class_seq) — INT — Foreign key → class.반고유번호
  • 코치고유번호 (coach_seq) — INT — Foreign key → class.코치고유번호
  • 컨설턴트고유번호 (consultant_seq) — INT — Foreign key → class.컨설턴트고유번호
  • 교육과정고유번호 (curriculum_seq) — INT — Foreign key → curriculum.교육과정고유번호 — NOT NULL
  • 지역고유번호 (location_seq) — INT — Foreign key → location.지역고유번호 — NOT NULL
  • 학생이름 (name) — String
  • 기수 (grade) — INT — NOT NULL
  • 전공여부 (is_major) — INT — NOT NULL
  • 퇴소여부 (exit) — String

work

  • 담당업무고유번호 (work_seq) — INT — Primary key — NOT NULL
  • 담당업무이름 (name) — String