test

Tables (7)

Campus (campus)

  • Campus Id (campus_id) — INT — Primary key — NOT NULL
  • Campus Region (campus_region) — VARCHAR(20)

Class (class)

  • Class id (class_id) — INT — Primary key — NOT NULL
  • Class Number (class_num) — INT
  • Campus Id (class_campus_id) — INT — Foreign key → Campus.Campus Id — NOT NULL

Coach (coach)

  • Coach Id (coach_id) — INT — Primary key — NOT NULL
  • Coach Name (coach_name) — VARCHAR(255)
  • Work (coach_work) — VARCHAR(255)
  • Field
  • Class id (class_id) — INT — Foreign key → Class.Class id — NOT NULL

Consultant (consultant)

  • Consultant Id (consutant_id) — INT — Primary key — NOT NULL
  • Consultant Name (consultant_name) — VARCHAR(255)
  • Work (coach_work) — VARCHAR(255)
  • Class id (class_id) — INT — Foreign key → Class.Class id — NOT NULL

Curriculum (curriculum)

  • Curriculum Id (curriculum_id) — INT — Primary key — NOT NULL
  • Curriculum Name (curriculum_name) — INT

Student (student)

  • Student Id (student_id) — INT — Primary key — NOT NULL
  • Student Name (student_name) — VARCHAR(255)
  • SW Major (student_sw_major) — BOOLEAN
  • Retire (student_retire) — BOOLEAN
  • Class id (student_class_id) — INT — Foreign key → Class.Class id — NOT NULL
  • Curriculum Id (curriculum_id) — INT — Foreign key → Curriculum.Curriculum Id — NOT NULL

Untitled (ㄴㅇㄹ)