ssssaffy

Tables (7)

class

  • class_id — INT
  • gisu_id — INT — Foreign key → gisu.gisu_id — NOT NULL
  • region — VARCHAR(6) — NOT NULL
  • class_number — INT — NOT NULL
  • consultant_id — INT — Foreign key → consultant.consultant_id — NOT NULL
  • coach_id — INT — Foreign key → coach.coach_id

coach

  • coach_id — INT
  • work_id — INT — Foreign key → work.work_id — NOT NULL
  • work_detail — VARCHAR(250) — NOT NULL

consultant

  • consultant_id — INT
  • work_id — INT — Foreign key → work.work_id — NOT NULL
  • work_detail — VARCHAR(250) — NOT NULL

course

  • course_id — INT
  • course_name — VARCHAR(10) — NOT NULL

gisu

  • gisu_id — INT
  • course_id — INT — Foreign key → course.course_id — NOT NULL
  • gisu — INT — NOT NULL

student

  • student_id — INT
  • class_id — INT — Foreign key → class.class_id — NOT NULL
  • is_major — TINYINT(1) — NOT NULL
  • is_out — INT — NOT NULL

work

  • work_id — INT
  • work_detail — VARCHAR(250) — NOT NULL