test
Tables (9)
cart_items
- cart_id — INT
- user_id — INT — NOT NULL
- lecture_id — INT — NOT NULL
- added_at — DATETIME
enrollments
- enrollment_id — INT
- user_id — INT — NOT NULL
- lecture_id — INT — NOT NULL
- status — ENUM('IN_PROGRESS', 'COMPLETED', 'CANCELLED')
- enrolled_at — DATETIME
lecture_feedback
- feedback_id — INT
- user_id — INT — NOT NULL
- lecture_id — INT — NOT NULL
- rating — TINYINT — NOT NULL
- comment — TEXT
- created_at — DATETIME
lecture_questions
- question_id — INT
- user_id — INT — NOT NULL
- lecture_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
mentoring_posts
- post_id — INT
- mentor_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- is_closed — BOOLEAN
- created_at — DATETIME
payments
- payment_id — INT
- user_id — INT — NOT NULL
- lecture_id — INT — NOT NULL
- amount — INT — NOT NULL
- method — ENUM('CARD', 'BANK_TRANSFER') — NOT NULL
- status — ENUM('SUCCESS', 'FAILED', 'PENDING')
- created_at — DATETIME
site_inquiries
- inquiry_id — INT
- user_id — INT — NOT NULL
- category — VARCHAR(50)
- content — TEXT — NOT NULL
- status — ENUM('PENDING', 'ANSWERED')
- created_at — DATETIME
user_profiles
- profile_id — INT
- user_id — INT — NOT NULL
- bio — TEXT
- skills — VARCHAR(255)
- profile_image — VARCHAR(255)
- updated_at — DATETIME
users
- user_id — INT — User ID
- email — VARCHAR(100) — NOT NULL — User email
- password — VARCHAR(255) — NOT NULL — Encrypted password
- name — VARCHAR(50) — NOT NULL — User name
- phone — VARCHAR(20) — Phone number
- user_type — ENUM('STUDENT', 'INSTRUCTOR', 'ADMIN') — NOT NULL — User role
- is_verified — BOOLEAN — Email verified status
- created_at — DATETIME — Sign-up date