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