SSAFY_HW

Tables (6)

CAMPUS (Untitled)

  • campus_id (캠퍼스번호) — BIGINT — Primary key — NOT NULL
  • reigion (지역명) — VARCHAR
  • address (캠퍼스주소) — VARCHAR

CLASS (Untitled4)

  • class_number (반 번호) — INT — Primary key — NOT NULL
  • campus_id (캠퍼스번호) — BIGINT — Foreign key → CAMPUS.campus_id — NOT NULL

COACH (코치)

  • coach_id (코치번호) — BIGINT — Primary key — NOT NULL
  • class_number (반 번호) — INT — Foreign key → CLASS.class_number — NOT NULL
  • job (담당업무) — VARCHAR

CONSULTANT (컨설턴트)

  • consult_id (컨설턴트 아이디) — BIGINT — Primary key — NOT NULL
  • class_number (반 번호) — INT — Foreign key → CLASS.class_number — NOT NULL
  • job (담당업무) — VARCHAR

SESSION (교육과정)

  • session_name (과정명) — VARCHAR — Primary key — NOT NULL

STUDENT (교육생)

  • student_id (학번) — BIGINT — Primary key — NOT NULL
  • generation (기수) — INT
  • is_out (퇴소여부) — BOOLEAN
  • is_major (전공여부) — BOOLEAN
  • class_number (반 번호) — INT — Foreign key → CLASS.class_number — NOT NULL