homework

Tables (7)

Class (class)

  • Class Id (class_id) — INT — Primary key — NOT NULL
  • Area (area) — VARCHAR(200)
  • Class Num (class_num) — INT

Coach (coach)

  • Coach Id (coach_id) — INT — Primary key — NOT NULL
  • Class Id (class_id) — INT — Foreign key → Class.Class Id — NOT NULL

Consultant (consultant)

  • Consultant Id (consultant_id) — INT — Primary key — NOT NULL
  • Class Id (class_id) — INT — Foreign key → Class.Class Id — NOT NULL

Education (education)

  • Education Id (education_id) — INT — Primary key — NOT NULL
  • Class Id (class_id) — INT — Foreign key → Class.Class Id — NOT NULL
  • Course (course) — VARCHAR(200)

Students (students)

  • Student Id (Key) — Primary key — NOT NULL
  • Class Id (class_id) — INT — Foreign key → Class.Class Id — NOT NULL
  • School (school) — INT
  • Is Majored (is_majored) — BOOLEAN
  • Is Leaved (is_leaved) — BOOLEAN

Tasks By Coach (tasks_by_coach)

  • Task Id (task_id) — INT — Primary key — NOT NULL
  • Coach Id (coach_id) — INT — Foreign key → Coach.Coach Id — NOT NULL
  • Class Id (class_id) — INT — Foreign key → Coach.Class Id — NOT NULL

Tasks By Consultant (tasks_by_consultant)

  • Task Id (task_id) — INT — Primary key — NOT NULL
  • Consultant Id (consultant_id) — INT — Foreign key → Consultant.Consultant Id — NOT NULL
  • Class Id (class_id) — INT — Foreign key → Consultant.Class Id — NOT NULL