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