ss
Tables (8)
class
- id — BIGINT
- instructor_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- game_type — VARCHAR(100)
- price — INT — NOT NULL
instructor
- id — BIGINT
- user_id — BIGINT — NOT NULL
- career — TEXT
- review_num — INT
- rating — FLOAT
payment
- id — BIGINT
- reservation_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
- payment_type — ENUM('CARD', 'BANK', 'KAKAO', 'FREE') — NOT NULL
- status — ENUM('READY', 'SUCCESS', 'FAILED', 'REFUNDED')
- paid_at — DATETIME
- transaction_id — VARCHAR(255)
replay
- id — BIGINT
- reservation_id — BIGINT — NOT NULL
- file_url — VARCHAR(255) — NOT NULL
- meta_data — TEXT
- summary — TEXT
- uploaded_at — DATETIME
reservation
- id — BIGINT
- student_id — BIGINT — NOT NULL
- class_id — BIGINT — NOT NULL
- reserved_at — DATETIME — NOT NULL
- status — ENUM('PENDING', 'PAID', 'CONFIRMED', 'CANCELLED')
- replay_id — BIGINT
- review_id — BIGINT
- payment_id — BIGINT
review
- id — BIGINT
- reservation_id — BIGINT — NOT NULL
- rating — INT
- comment — TEXT — EX
- created_at — DATETIME
student
- id — BIGINT
- user_id — BIGINT — NOT NULL
- level — VARCHAR(50)
user
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(100)
- profile_image — VARCHAR(255)
- phone — VARCHAR(30)
- role — ENUM('INSTRUCTOR', 'STUDENT') — NOT NULL