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