ssafy

Tables (5)

Class (class)

  • class_no — INT — Primary key — NOT NULL
  • area — VARCHAR
  • coach_id — INT — Foreign key → Coach.coach_id — NOT NULL
  • consultant_id — INT — Foreign key → Consultant.consultant_id — NOT NULL

Coach (coach)

  • coach_id — INT — Primary key — NOT NULL
  • job — VARCHAR
  • age — INT
  • name — VARCHAR

Consultant (consultant)

  • consultant_id — INT — Primary key — NOT NULL
  • name — VARCHAR
  • job — VARCHAR
  • age — INT

Course (course)

  • course_id — INT — Primary key — NOT NULL
  • course_name — VARCHAR — NOT NULL
  • class_no — INT — Foreign key → Class.class_no — NOT NULL

Student (student)

  • student_id — INT — Primary key — NOT NULL
  • grade — VARCHAR
  • major — VARCHAR
  • graduation (delete) — CHAR(1)
  • name — VARCHAR
  • age — INT
  • class_no — INT — Foreign key → Class.class_no — NOT NULL