ssafy

Tables (4)

Class

  • class_id (Key) — VARCHAR — Primary key — NOT NULL

Coach (coach)

  • Coach_id — BIGINT — Primary key — NOT NULL
  • coach_task (coack_task) — VARCHAR
  • class_id (Field) — VARCHAR
  • class_id — VARCHAR
  • class_id (Key) — VARCHAR — Foreign key → Class.class_id — NOT NULL

Consultant (consultant)

  • Consultant_id — BIGINT — Primary key — NOT NULL
  • consultant_task — VARCHAR
  • class_id (Field) — VARCHAR
  • class_id — VARCHAR
  • class_id (Key) — VARCHAR — Foreign key → Class.class_id — NOT NULL

Student (student)

  • student_id — BIGINT — Primary key — NOT NULL
  • major — VARCHAR
  • retireTF (Field) — VARCHAR
  • curriculum — VARCHAR
  • unit — VARCHAR
  • class_id (Field2) — VARCHAR
  • class_id — VARCHAR
  • class_id (Key) — VARCHAR — Foreign key → Class.class_id — NOT NULL