inflearn
Tables (4)
Class
- id — INT — Primary key — NOT NULL
- category — VARCHAR(20) — NOT NULL
- classname — VARCHAR(50)
- summary — VARCHAR(200) — NOT NULL
- price — INT — NOT NULL
- public — TINYINT
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- teacher_id — INT — Foreign key → Teacher.id — NOT NULL
Register
- id — INT — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- student_id — INT — Foreign key → Student.id — NOT NULL
- class_id — INT — Foreign key → Class.id — NOT NULL
Student
- id — INT — Primary key — NOT NULL
- username — VARCHAR(20) — NOT NULL
- email — VARCHAR(50) — Unique Key
- nickname — VARCHAR(20) — NOT NULL
Teacher
- id — INT — Primary key — NOT NULL
- teacher_name — VARCHAR(20) — NOT NULL