temp

Tables (7)

Class

  • class_id — INT — Primary key
  • region — VARCHAR(10) — NOT NULL
  • class_number — INT — NOT NULL
  • consultant_id — INT — NOT NULL
  • coach_id — INT

Class_Course

  • class_id — INT — Primary key
  • course_id — INT — Primary key
  • class_id (class_id2) — INT — Foreign key → Class.class_id

Coach

  • coach_id — INT — Primary key
  • class_id — INT — Foreign key → Class.class_id
  • name — VARCHAR(50) — NOT NULL
  • duty — VARCHAR(100) — NOT NULL

Consultant

  • consultant_id — INT — Primary key
  • class_id — INT — Foreign key → Class.class_id
  • name — VARCHAR(50) — NOT NULL
  • duty — VARCHAR(100) — NOT NULL

Course

  • course_id — INT — Primary key
  • class_id — INT — Foreign key → Class_Course.class_id
  • course_id (course_id2) — INT — Foreign key → Class_Course.course_id
  • class_id (class_id2) — INT — Foreign key → Class_Course.class_id
  • type — VARCHAR(10) — NOT NULL

Generation

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

Student

  • student_id — INT — Primary key
  • class_id (class_id2) — INT — Foreign key → Class.class_id
  • generation_id (generation_id2) — INT — Foreign key → Generation.generation_id
  • name — VARCHAR(50) — NOT NULL
  • is_major — BOOLEAN — NOT NULL
  • is_dropped — BOOLEAN — NOT NULL
  • generation_id — INT — NOT NULL
  • class_id — INT — NOT NULL