self-project
Tables (5)
Class (class)
- Class Id (class_id) — INT(10) — Primary key — NOT NULL
- Region (region) — VARCHAR(10)
- Class Number (class_number) — INT(4)
- Process (process) — CHAR(4)
Coach (coach)
- Coach Id (coach_id) — INT(10) — Primary key — NOT NULL
- Name (name) — VARCHAR(20)
- Phone (phone) — VARCHAR(20)
- Class Id (class_id) — INT(10) — Foreign key → Class.Class Id — NOT NULL
Consultant (consultant)
- Consultant Id (consultant_id) — INT(10) — Primary key — NOT NULL
- Class Id (class_id) — INT(10) — Foreign key → Class.Class Id — NOT NULL
- Name (name) — VARCHAR(20)
- Phone (phone) — VARCHAR(20)
Student (student)
- Student Id (student_id) — INT(10) — Primary key — NOT NULL
- Class Id (class_id) — INT(10) — Foreign key → Class.Class Id — NOT NULL
- Ordinal Number (ordinal_number) — INT(4)
- Is Major (is_major) — BOOLEAN
- Is Leave (is_leave) — BOOLEAN
- Name (name) — VARCHAR(20)
- Email (email) — VARCHAR(100)
- Gender (gender) — CHAR(2)
- Birthday (birthday) — CHAR(8)
- Phone (phone) — VARCHAR(20)
Work (work)
- Work Id (work_id) — INT(10) — Primary key — NOT NULL
- Work (work) — VARCHAR(255)
- Content (content) — VARCHAR(255)
- Is Complete (is_complete) — BOOLEAN
- Coach Id (coach_id) — INT(10) — Foreign key → Coach.Coach Id — NOT NULL
- Consultant Id (consultant_id) — INT(10) — Foreign key → Consultant.Consultant Id — NOT NULL
- Class Id (class_id) — INT(10) — Foreign key → Consultant.Class Id — NOT NULL