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

data_request_logs

  • id — BIGINT

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