KimchiMall-payment
Tables (3)
PAYMENT_EVENT (결제 이벤트_TB)
- payment_event_id (PK) — BIG INT — Primary key — NOT NULL
- buyer_id (Field) — BIG INT
- is_payment_done (Field2) — BOOLEAN
- order_id (Field3) — VARCHAR , UNIQUE
- payment_key (Field4) — VARCHAR , UNIQUE
- type (BASIC , AUTO ...) — ENUM
- order_name (Field6) — VARCHAR
- method (카드 결제 , 간편 결제 , 휴대폰 ...) — ENUM
- psp_raw_data (Field5) — JSON
- created_at (Field7) — DATETIME
- updated_at (Field8) — DATETIME
- approved_at (Field9) — DATETIME
- Field10
PAYMENT_ORDERS (결제 주문_TB)
- payment_orders_id (PK) — BIG INT — Primary key — NOT NULL
- payment_event_id (FOREIGN KEY) — BIG INT — Foreign key → PAYMENT_EVENT.payment_event_id — NOT NULL
- 12 (Field)
- seller_id (Field1) — BIG INT
- produect_id (Field3) — BIG INT
- order_id (Field4) — VARCHAR , UNIQUE
- amount (Field5) — DECIMAL
- payment_order_status (NOT_STARTED , EXECUTING , SUCCESS) — ENUM
- ledger_updated (Field6) — BOOLEAN
- wallet_updated (Field2) — BOOLEAN
- failed_count (Field7) — TINYINT
- threshold (Field8) — TINYINT
- created_at (Field9) — DATETIME
- updated_at (Field10) — DATETIME
PAYTMENT_HISTORIES (Untitled)
- id (PK) — BIGINT — Primary key — NOT NULL
- payment_order_id (FOREIGN KEY) — BIG INT — Foreign key → PAYMENT_ORDERS.payment_orders_id — NOT NULL
- Field2
- previous_status (Field3) — ENUM
- new_status (Field4) — ENUM
- created_at (Field) — DATETIME
- changed_by (Field5) — VARCHAR
- reason (Field6) — VARCHAR