ssafy_1227

Tables (7)

Copy Of Copy Of Copy Of Untitled2 (Curriculums)

  • Key (curriculum_id) — NOT NULL — Primary key — NOT NULL
  • Field (Common) — NOT NULL
  • Field (Specialized) — NOT NULL
  • Field (Voluntary) — NOT NULL

Copy Of Copy Of Untitled2 (Classes)

  • Key (class_id) — NOT NULL, CONSTRAINT chk_class_id_range CHECK (class_id BETWEEN 1 AND 6) — Primary key — NOT NULL
  • Key (campus_id) — NOT NULL — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Key (consultant_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Field (Class) — NOT NULL
  • Key (coach_id) — NOT NULL — Foreign key → Copy Of Untitled.Key — NOT NULL

Copy Of Untitled (Coaches)

  • Key (coach_id) — NOT NULL — Primary key — NOT NULL
  • Field (Name) — NOT NULL

Copy Of Untitled2 (Campuses)

  • Key (campus_id) — NOT NULL — Primary key — NOT NULL
  • Field (Location) — NOT NULL

Untitled (Trainees)

  • Key (trainee_id) — NOT NULL — Primary key — NOT NULL
  • Key (class_id) — NOT NULL, CONSTRAINT chk_class_id_range CHECK (class_id BETWEEN 1 AND 6) — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
  • Key (campus_id) — NOT NULL — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
  • Key (consultant_id) — NOT NULL — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
  • Field (Name) — NOT NULL
  • Field (Computer Major) — NOT NULL
  • Field (Retired) — NOT NULL

Untitled (Consultants)

  • Key (consultant_id) — NOT NULL — Primary key — NOT NULL
  • Field (Name) — NOT NULL

Untitled (Assignments)

  • Key (assignment_id) — NOT NULL — Primary key — NOT NULL
  • Key (consultant_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Key (coach_id) — NOT NULL — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (assigenment_info) — NOT NULL