ssd

Tables (11)

notification

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • message — VARCHAR(300)
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

payment

  • id — BIGINT — Primary key — NOT NULL
  • reservation_id — BIGINT — Foreign key → reservation.id — NOT NULL
  • amount — INT — NOT NULL
  • payment_method — VARCHAR(30)
  • status — VARCHAR(20) — NOT NULL — PENDING / PAID / CANCELED / REFUNDED
  • paid_at — DATETIME
  • created_at — DATETIME — NOT NULL

product

  • id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → user.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(30) — NOT NULL — 당일재고 / 빈시간대자원 / 당일공실 / 이동관광잔여상품
  • type — VARCHAR(20) — NOT NULL — INDOOR / OUTDOOR
  • qty — INT — NOT NULL
  • price — INT — NOT NULL
  • min_price — INT — NOT NULL
  • open_time — TIME
  • deadline — DATETIME — NOT NULL
  • foot_traffic — VARCHAR(10) — HIGH / LOW
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • status — VARCHAR(20) — NOT NULL — ACTIVE / PAUSED / CLOSED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

product_image

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — INT

push_token

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • device_token — VARCHAR(300) — NOT NULL
  • platform — VARCHAR(10) — NOT NULL — FCM / APNS
  • created_at — DATETIME — NOT NULL

refresh_token

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • token_hash — VARCHAR(300) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

reservation

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • buyer_id — BIGINT — Foreign key → user.id — NOT NULL
  • qty — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — REQUESTED / APPROVED / REJECTED / COMPLETED / NO_SHOW / CANCELED
  • requested_at — DATETIME — NOT NULL
  • updated_at — DATETIME

review

  • id — BIGINT — Primary key — NOT NULL
  • reservation_id — BIGINT — Foreign key → reservation.id — NOT NULL
  • buyer_id — BIGINT — Foreign key → user.id — NOT NULL
  • rating — INT — NOT NULL — 1~5
  • content — TEXT
  • created_at — DATETIME — NOT NULL

seller_profile

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • business_name — VARCHAR(100) — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • address — VARCHAR(200)
  • bank_name — VARCHAR(50)
  • account_number — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

user

  • id — BIGINT — Primary key — NOT NULL
  • kakao_id — BIGINT — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • role — VARCHAR(20) — NOT NULL — BUYER / SELLER
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

wishlist

  • id — BIGINT — Primary key — NOT NULL
  • buyer_id — BIGINT — Foreign key → user.id — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • created_at — DATETIME — NOT NULL