DB1

Tables (4)

Coach

  • ID — INT — Primary key — NOT NULL
  • Region (Region2) — CHAR(30) — Foreign key → Organization.Region — NOT NULL
  • Class (Class2) — INT — Foreign key → Organization.Class — NOT NULL

Consultant (Untitled2)

  • ID — INT — Primary key — NOT NULL
  • Region (Region2) — CHAR(30) — Foreign key → Organization.Region — NOT NULL
  • Class (Class2) — INT — Foreign key → Organization.Class — NOT NULL

Organization

  • Region — CHAR(30) — Primary key — NOT NULL
  • Class — INT — Primary key — NOT NULL

Student (Untitled)

  • ID — INT — Primary key — NOT NULL
  • Name — CHAR(30)
  • Gen — TINYINT
  • Major — CHAR(1)
  • IsQuit — TINYINT(1)
  • Course — CHAR(30)
  • Region (Region2) — CHAR(30) — Foreign key → Organization.Region — NOT NULL
  • Class (Class2) — INT — Foreign key → Organization.Class — NOT NULL