ptj

Tables (6)

area (Untitled4)

  • 지역 (area) — varchar(20) — Primary key — NOT NULL

class (Untitled5)

  • 반 (class) — varchar(20) — Primary key — NOT NULL

consultant (Untitled2)

  • 컨설턴트이름 (con_name) — varchar(20) — Primary key — NOT NULL
  • 담당업무 (con_work) — varchar(20)

couch (Untitled3)

  • 코치이름 (cou_name) — varchar(20) — Primary key — NOT NULL
  • 담당업무 (cou_work) — varchar(20)

course (Untitled6)

  • 이름 (course_name) — varchar(20) — Primary key — NOT NULL

student (Untitled)

  • 기수 (gi) — varchar(20) — Primary key — NOT NULL
  • 전공여부 (is_subject) — varchar(20) — Primary key
  • 퇴소여부 (is_out) — varchar(20) — Primary key
  • 지역 (area) — varchar(20) — Foreign key → area.지역 — NOT NULL
  • 컨설턴트이름 (con_name) — varchar(20) — Foreign key → consultant.컨설턴트이름 — NOT NULL
  • 반 (class) — varchar(20) — Foreign key → class.반 — NOT NULL
  • 이름 (course_name) — varchar(20) — Foreign key → course.이름 — NOT NULL
  • 코치이름 (cou_name) — varchar(20) — Foreign key → couch.코치이름 — NOT NULL