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