self-project

Tables (5)

Class (class)

  • Class Id (class_id) — INT(10) — Primary key — NOT NULL
  • Region (region) — VARCHAR(10)
  • Class Number (class_number) — INT(4)
  • Process (process) — CHAR(4)

Coach (coach)

  • Coach Id (coach_id) — INT(10) — Primary key — NOT NULL
  • Name (name) — VARCHAR(20)
  • Phone (phone) — VARCHAR(20)
  • Class Id (class_id) — INT(10) — Foreign key → Class.Class Id — NOT NULL

Consultant (consultant)

  • Consultant Id (consultant_id) — INT(10) — Primary key — NOT NULL
  • Class Id (class_id) — INT(10) — Foreign key → Class.Class Id — NOT NULL
  • Name (name) — VARCHAR(20)
  • Phone (phone) — VARCHAR(20)

Student (student)

  • Student Id (student_id) — INT(10) — Primary key — NOT NULL
  • Class Id (class_id) — INT(10) — Foreign key → Class.Class Id — NOT NULL
  • Ordinal Number (ordinal_number) — INT(4)
  • Is Major (is_major) — BOOLEAN
  • Is Leave (is_leave) — BOOLEAN
  • Name (name) — VARCHAR(20)
  • Email (email) — VARCHAR(100)
  • Gender (gender) — CHAR(2)
  • Birthday (birthday) — CHAR(8)
  • Phone (phone) — VARCHAR(20)

Work (work)

  • Work Id (work_id) — INT(10) — Primary key — NOT NULL
  • Work (work) — VARCHAR(255)
  • Content (content) — VARCHAR(255)
  • Is Complete (is_complete) — BOOLEAN
  • Coach Id (coach_id) — INT(10) — Foreign key → Coach.Coach Id — NOT NULL
  • Consultant Id (consultant_id) — INT(10) — Foreign key → Consultant.Consultant Id — NOT NULL
  • Class Id (class_id) — INT(10) — Foreign key → Consultant.Class Id — NOT NULL