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