sss

Tables (6)

address_snapshots

  • id — BIGINT
  • order_id — BIGINT — NOT NULL
  • receiver_name — VARCHAR(50)
  • receiver_phone — VARCHAR(20)
  • full_address — VARCHAR(500)
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • created_at — TIMESTAMP

addresses

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • receiver_name — VARCHAR(50) — NOT NULL
  • receiver_phone — VARCHAR(20) — NOT NULL
  • country — VARCHAR(50) — NOT NULL
  • province — VARCHAR(50)
  • city — VARCHAR(50)
  • district — VARCHAR(50)
  • detail_address — VARCHAR(255) — NOT NULL
  • postal_code — VARCHAR(20)
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • is_default — BOOLEAN
  • version — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_user

payment_methods

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • method_type — ENUM( 'CARD', 'KAKAO_PAY', 'NAVER_PAY' ) — NOT NULL
  • provider — VARCHAR(50)
  • token — VARCHAR(255)
  • last4 — VARCHAR(4)
  • is_default — BOOLEAN
  • created_at — TIMESTAMP
  • INDEX — idx_user

payment_notifications

  • id — BIGINT
  • payment_id — BIGINT — Foreign key → payments.id
  • third_party_txn — VARCHAR(128)
  • raw_data — JSON
  • processed — BOOLEAN
  • created_at — TIMESTAMP
  • INDEX — idx_txn

payment_transactions

  • id — BIGINT
  • payment_id — BIGINT — Foreign key → payments.id — NOT NULL
  • transaction_no — VARCHAR(64) — NOT NULL
  • third_party_txn — VARCHAR(128)
  • action — ENUM( 'PAY', 'REFUND', 'CANCEL' ) — NOT NULL
  • status — ENUM( 'REQUEST', 'SUCCESS', 'FAILED' ) — NOT NULL
  • request_data — JSON
  • response_data — JSON
  • created_at — TIMESTAMP
  • INDEX — idx_payment

payments

  • id — BIGINT
  • order_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • payment_no — VARCHAR(64) — NOT NULL
  • amount — DECIMAL(12,2) — NOT NULL
  • currency — VARCHAR(10)
  • status — ENUM( 'INIT', 'PENDING', 'SUCCESS', 'FAILED', 'CANCELLED', 'REFUNDED' ) — NOT NULL
  • payment_method — ENUM( 'CARD', 'KAKAO_PAY', 'NAVER_PAY', 'ALIPAY', 'WECHAT_PAY' ) — NOT NULL
  • expire_at — TIMESTAMP
  • version — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_order
  • INDEX — idx_user