1000world
Tables (10)
comments
- id — BIGINT
- member_id — BIGINT — NOT NULL
- video_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
games
- id — BIGINT
- title — VARCHAR(50) — NOT NULL
- desc — VARCHAR(255) — NOT NULL
- explain — VARCHAR(255) — NOT NULL
- difficulty — ENUM('EASY', 'MEDIUM', 'HARD') — NOT NULL
- point — BIGINT — NOT NULL
- thumbnail — VARCHAR(255) — NOT NULL
- require_data_type — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
likes
- id — BIGINT
- member_id — BIGINT — NOT NULL
- video_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
members
- id — BIGINT
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- birthday — DATE — NOT NULL — 생년월일
- gender — ENUM('MALE', 'FEMALE') — NOT NULL
- role — ENUM('USER', 'ADMIN') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
orders
- id — BIGINT
- member_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
participations
- id — BIGINT
- member_id — BIGINT — NOT NULL
- game_id — BIGINT — NOT NULL
- status — ENUM('ONGOING', 'COMPLETED', 'FAILED') — NOT NULL — 참여 상태
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
products
- id — BIGINT
- title — VARCHAR(50) — NOT NULL
- category — ENUM('ITEM', 'COUPON', 'OTHER') — NOT NULL
- price — BIGINT — NOT NULL
- thumbnail — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
reward_logs
- id — BIGINT
- participation_id — BIGINT — NOT NULL
- status — ENUM('REWARDED', 'PENDING', 'DUPLICATE') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
videos
- id — BIGINT
- participation_id — BIGINT — NOT NULL
- title — VARCHAR(50) — NOT NULL
- desc — VARCHAR(255)
- thumbnail — VARCHAR(255) — NOT NULL