Lv.3
Tables (3)
Instructor
- instructorId — BIGINT — Primary key — NOT NULL
- instructorName — VARCHAR
- experience — BIGINT
- company (companny) — VARCHAR
- phoneNumber — VARCHAR
- biography — VARCHAR
Lecture
- lectureId — BIGINT — Primary key — NOT NULL
- lectureName — VARCHAR
- price — BIGINT
- introduction — VARCHAR
- category — ENUM('SPRING', 'REACT','NODE')
- instructorId — BIGINT
- createdAt — DATETIME
User
- userId — BIGINT — Primary key — NOT NULL
- username — VARCHAR
- email — VARCHAR
- password — VARCHAR
- department — ENUM('CURRICULUM', 'MARKETING', 'DEVELOPMENT')
- role — ENUM('MANAGER', 'STAFF')