평행세계SSAFY

테이블 (4)

Consultants (consultants)

  • Consultant Id (consultant_id) — Int(11) — 기본 키 — NOT NULL
  • Class Key (class_key) — Int(11) — 외래 키 → classes.Class Key — NOT NULL
  • First Name (first_name) — VARCHAR(255)
  • Last Name (last_name) — VARCHAR(255)
  • Gender (gender) — VARCHAR(11)
  • Class (class) — INT(11)

Responsibilities (responsibilities)

  • Responsibility Id (responsibility_id) — Int(11) — 기본 키 — NOT NULL
  • Consultant Id (consultant_id) — Int(11) — 외래 키 → Consultants.Consultant Id — NOT NULL
  • Class Key (class_key) — Int(11) — 외래 키 → Consultants.Class Key — NOT NULL
  • Responsibility Name (responsibility_name) — VARCHAR(255)

Students (students)

  • Student Id (student_id) — INT(11) — 기본 키 — NOT NULL
  • Class Key (class_key) — Int(11) — 외래 키 → classes.Class Key — NOT NULL
  • First Name (first_name) — VARCHAR(255)
  • Last Name (last_name) — VARCHAR(255)
  • Year (year) — INT(11)
  • SW Major (sw_majored) — BOOLEAN
  • Graduated (is_graduated) — BOOLEAN
  • Gender (gender) — VARCHAR(11)
  • Region (region) — VARCHAR(11)

classes

  • Class Key (class_key) — Int(11) — 기본 키 — NOT NULL
  • Class (class) — INT(11)