Hw02

Tables (3)

coach

  • no (coach_no) — VARCHAR(30) — Primary key — NOT NULL
  • field (coach_field) — VARCHAR(20) — NOT NULL
  • class (coach_class) — INT(11) — NOT NULL

consultant

  • no (consultant_no) — VARCHAR(30) — Primary key — NOT NULL
  • field (consultant_field) — VARCHAR(20)
  • class (consultant_class) — INT(11)

student

  • no (student_no) — VARCHAR(30) — Primary key — NOT NULL
  • number (student_number) — INT(11)
  • major (student_major) — BOOLEAN
  • isExit (student_isExit) — BOOLEAN
  • field (student_field) — VARCHAR(20)
  • class (student_class) — INT(11)
  • edu (student_edu) — VARCHAR(20)
  • no (consultant_no) — VARCHAR(30) — Foreign key → consultant.no — NOT NULL