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