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