ERD1
Tables (8)
Class
- class_id — INT
- instructor_id — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- game_type — VARCHAR(50) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
Instructor
- instructor_id — INT — Primary key
- user_id — INT — NOT NULL
- career — TEXT
- review_num — INT
- rating — DECIMAL(3,2)
Payment
- payment_id — INT
- reservation_id — INT — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- date — DATETIME — NOT NULL
- method — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
Replay
- replay_id — INT
- reservation_id — INT — NOT NULL
- file_url — VARCHAR(255) — NOT NULL
- date — DATETIME — NOT NULL
Reservation
- reservation_id — INT
- user_id — INT — NOT NULL
- instructor_id — INT — NOT NULL
- class_id — INT — NOT NULL
- date — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
Review
- review_id — INT
- reservation_id — INT — NOT NULL
- rating — INT — NOT NULL
- comment — TEXT — EX
- date — DATETIME — NOT NULL
USER
- user_id — INT — Primary key
- ID — VARCHAR(50) — NOT NULL
- Password — VARCHAR(100) — NOT NULL
- Name — VARCHAR(50) — NOT NULL
- Nickname — VARCHAR(50)
- e_mail — VARCHAR(100) — NOT NULL
- profile_image — VARCHAR(255)
- Phone — VARCHAR(20)
- 맞춤_강사_서비스 — BOOLEAN
game
- game_id — INT
- user_id — INT — NOT NULL
- game_type — VARCHAR(50) — NOT NULL
- game_tier — VARCHAR(20)
- game_position — VARCHAR(30)