sekki_jupsho_erd
Tables (8)
application
- id — CHAR(36) — Primary key — NOT NULL
- event_id — CHAR(36) — Foreign key → event.id — NOT NULL
- reviewer_id — CHAR(36) — Foreign key → user.id — NOT NULL
- status — ENUM('pending', 'approved', 'rejected') — NOT NULL
- applied_at — TIMESTAMP — NOT NULL
deposit
- id — CHAR(36) — Primary key — NOT NULL
- owner_id — CHAR(36) — Foreign key → user.id — NOT NULL
- amount — INT — NOT NULL — 양수: 충전, 음수: 차감
- deposited_at — TIMESTAMP — NOT NULL
event
- id — CHAR(36) — Primary key — NOT NULL
- store_id — CHAR(36) — Foreign key → store.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- condition — TEXT — NOT NULL
- reward_amount — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
rejection
- id — CHAR(36) — Primary key — NOT NULL
- application_id — CHAR(36) — Foreign key → application.id — NOT NULL
- reason — TEXT — NOT NULL
- rejected_at — TIMESTAMP — NOT NULL
review_image
- id — CHAR(36) — Primary key — NOT NULL
- submission_id — CHAR(36) — Foreign key → review_submission.id — NOT NULL
- image_url — VARCHAR(512) — NOT NULL
- order_index — TINYINT — NOT NULL
review_submission
- id — CHAR(36) — Primary key — NOT NULL
- application_id — CHAR(36) — Foreign key → application.id — NOT NULL
- message — TEXT
- submitted_at — TIMESTAMP — NOT NULL
store
- id — CHAR(36) — Primary key — NOT NULL
- owner_id — CHAR(36) — Foreign key → user.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- category — ENUM('restaurant', 'cafe', 'fashion', 'beauty', 'etc') — NOT NULL
- thumbnail_url — VARCHAR(512)
- description — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
user
- id — CHAR(36) — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- wallet_address — VARCHAR(255)
- role — ENUM('owner', 'reviewer') — NOT NULL
- created_at — TIMESTAMP — NOT NULL