gacha

테이블 (8)

Category

  • category_id — INTEGER
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL

DealHistory

  • history_id — INTEGER
  • deal_id — INTEGER
  • changed_at — TIMESTAMP — NOT NULL
  • old_title — VARCHAR(255) — NOT NULL
  • new_title — VARCHAR(255) — NOT NULL
  • old_description — TEXT — NOT NULL
  • new_description — TEXT — NOT NULL
  • old_price — DECIMAL — NOT NULL
  • new_price — DECIMAL — NOT NULL
  • old_discount_rate — FLOAT — NOT NULL
  • new_discount_rate — FLOAT — NOT NULL
  • old_start_date — TIMESTAMP — NOT NULL
  • new_start_date — TIMESTAMP — NOT NULL
  • old_end_date — TIMESTAMP — NOT NULL
  • new_end_date — TIMESTAMP — NOT NULL
  • changed_by — INTEGER — NOT NULL

Entry

  • entry_id — INTEGER
  • user_id — INTEGER
  • deal_id — INTEGER
  • entry_date — TIMESTAMP — NOT NULL
  • reward_points — INTEGER — NOT NULL

Review

  • review_id — INTEGER
  • user_id — INTEGER
  • deal_id — INTEGER
  • rating — FLOAT — NOT NULL
  • comment — TEXT3 — NOT NULL — EXT NOT NULdddd
  • created_at (222) — TIMESTAMP — NOT NULL

Reward

  • reward_id — INTEGER
  • deal_id — INTEGER
  • points — INTEGER — NOT NULL
  • probability — FLOAT — NOT NULL

RewardHistory

  • history_id — INTEGER
  • reward_id — INTEGER
  • changed_at — TIMESTAMP — NOT NULL
  • old_points — INTEGER — NOT NULL
  • new_points — INTEGER — NOT NULL
  • old_probability — FLOAT — NOT NULL
  • new_probability — FLOAT — NOT NULL
  • changed_by — INTEGER — NOT NULL

User

  • 회원명 (user_id) — INTEGER
  • username — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • total_points — INTEGER

가챠럭키딜 (gacha)

  • seq (deal_id) — INTEGER
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • price — DECIMAL — NOT NULL
  • discount_rate — FLOAT — NOT NULL
  • start_date — TIMESTAMP — NOT NULL
  • end_date — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL