erd

Tables (6)

Class (Untitled2)

  • no — INT — Primary key — NOT NULL
  • num — INT
  • track_no — INT — Foreign key → Track.no — NOT NULL
  • no (no2) — INT — Foreign key → Region.no — NOT NULL

Class-coach (Untitled5)

  • class_no — INT — Foreign key → Class.no — NOT NULL

Class-consultant (Untitled6)

  • class_no — INT — Foreign key → Class.no — NOT NULL
  • consultant_no (no2) — INT — Foreign key → Class.no — NOT NULL

Region (Untitled4)

  • no — INT — Primary key — NOT NULL
  • name — VARCHAR(10)

Track (Untitled3)

  • no — INT — Primary key — NOT NULL
  • name — VARCHAR(10)

Trainee (Untitled)

  • no (Key) — INT — Primary key — NOT NULL
  • generation (Field) — INT
  • is_major (Field2) — VARCHAR(1)
  • is_exit (Field3) — VARCHAR(1)