SW#7 1228092

Tables (9)

class

  • class_id — INT
  • region_id — INT
  • class_number — INT

class_coach

  • class_id — INT
  • coach_id — INT

class_consultant

  • class_id — INT
  • consultant_id — INT

coach

  • coach_id — INT
  • name — VARCHAR(50)
  • duty — VARCHAR(100)

consultant

  • consultant_id — INT
  • name — VARCHAR(50)
  • duty — VARCHAR(100)

course

  • course_id — INT
  • type — VARCHAR(20)

generation

  • generation_id — INT
  • name — VARCHAR(50) — NOT NULL

region

  • region_id — INT
  • name — VARCHAR(20)

student

  • student_id — INT
  • name — VARCHAR(50)
  • generation_id — INT
  • class_id — INT
  • is_major — BOOLEAN
  • is_dropped — BOOLEAN