Saferrot 안전결제

테이블 (6)

BUYER

  • BUYER_ID — INT — 기본 키 — NOT NULL
  • BUYER_CODE — VARCHAR(200)
  • EMAIL — VARCHAR(200)
  • ROAD_ADDRESS — VARCHAR(200)
  • DETAIL_ADDREESS — VARCHAR(255)
  • POST_CODE — VARCHAT(100)

ESCROW_STATUS

  • ESCROW_STATUS_ID — INT — 기본 키 — NOT NULL
  • CODE — VARCHAR(100)

SELLER

  • SELLER_ID — VARCHAR(200) — 기본 키 — NOT NULL
  • BUYER_CODE — VARCHAR(200)
  • ACCOUNT — VARCHAR(200)
  • EMAIL — VARCHAR(200)

SHIPPING

  • SHIPPING_ID — INT — 기본 키 — NOT NULL
  • COURIER_CODE — VARHCAR(50)
  • TRACKING_NUMBER — VARCHAR(255)
  • SHIPPING_AT — TIMESTAMP
  • DELIVERED_AT — TIMESTAMP
  • COMPLEATE_YN — VARCHAR(10)

client_server

  • CLIENT_SERVER_ID — INT — 기본 키 — NOT NULL
  • SERVER_NAME — VARCHAR(255)
  • SEVER_KEY — VARCHAR(255)
  • CREATED_AT — TIMESTAMP

escrow

  • ESCROW_ID — INT — 기본 키 — NOT NULL
  • CLIENT_SERVER_ID — INT — 외래 키 → client_server.CLIENT_SERVER_ID — NOT NULL
  • ESCROW_STATUS_ID — INT — 외래 키 → ESCROW_STATUS.ESCROW_STATUS_ID — NOT NULL
  • SHIPMENT_ID — INT — 외래 키 → SHIPPING.SHIPPING_ID — NOT NULL
  • SELLER_ID — INT — 외래 키 → SELLER.SELLER_ID — NOT NULL
  • BUYER_ID — INT — 외래 키 → BUYER.BUYER_ID — NOT NULL
  • PAYMENT_ID — VARHCAR(100)
  • PRODUCT_NAME — INT
  • AMOUNT — INT
  • SAFE_DAY — INT
  • MERCHANT_UID — VARCHAR(200)
  • CREATED_AT — TIMESTAMP
  • UDAPTED_AT — TIMESTAMP