ERD 연습

테이블 (6)

교육과정 (Procedure)

  • procedure_id — int — 기본 키 — NOT NULL
  • procedure_name — varchar(255) — NOT NULL

교육생 (Student)

  • student_id — bigint — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • training_number — int — NOT NULL — 기수
  • majors — bool — NOT NULL — 전공여부
  • out_yn — varchar(1) — NOT NULL — 퇴소여부
  • create_date — timestamp — NOT NULL
  • update_date — timestamp

반 (Class)

  • class_id — bigint — 기본 키 — NOT NULL
  • location_no — int — 외래 키 → 지역.location_no — NOT NULL
  • consultent_id — bigint — 외래 키 → 컨설턴트.consultent_id — NOT NULL
  • couch_id — bigint — 외래 키 → 코치.couch_id — NOT NULL
  • procedure_id — int — 외래 키 → 교육과정.procedure_id — NOT NULL
  • student_id — bigint — 외래 키 → 교육생.student_id — NOT NULL
  • class_number — int — NOT NULL
  • active_state_yn — varchar(1) — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp

지역 (Location)

  • location_no — int — 기본 키 — NOT NULL
  • location_name — varchar(10) — NOT NULL

컨설턴트 (Consultent)

  • consultent_id — bigint — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • working — varchar(255)
  • create_date — timestamp — NOT NULL
  • update_date — timestamp

코치 (Couch)

  • couch_id — bigint — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • working — varchar(255)
  • create_date — timestamp — NOT NULL
  • update_date — timestamp