ddd
Tables (4)
pay_auth (승인테이블)
- transactionId (거래번호) — char(14) — Primary key
- serviceId (가맹점 아이디) — varchar2(64) — Primary key
- CancelTransactionId (취소거래번호) — char(14) — Foreign key → pay_cancel.CancelTransactionId
- serviceId (가맹점 아이디2) — varchar2(64) — Foreign key → pay_cancel.serviceId
- seqNumber (순번) — int(4)
- itemName (상품명) — varchar2(64)
- itemCode (상품코드) — varchar2(64)
- orderDate (주문일시) — Date
- amount (금액) — int(10
- userId (고객아이디) — varchar2(20)
- userName (고객이름) — varchar2(64)
- userHp (고객전화번호) — char(11)
pay_cancel (취소테이블)
- serviceId (가맹점 아이디) — varchar2(64) — Primary key
- CancelTransactionId (취소거래번호) — char(14) — Primary key
- seqNumber (순번) — int(4)
- itemName (상품명) — varchar2(64)
- itemCode (상품코드) — varchar2(64)
- orderDate (주문일시) — Date
- amount (금액) — int(10
- userId (고객아이디) — varchar2(20)
- userName (고객이름) — varchar2(64)
- userHp (고객전화번호) — char(11)
- transactionId (거래번호) — char(14)
pay_serviceId_list (가맹점리스트)
- serviceId (가맹점아이디) — varchar2(64) — Primary key
- serviceName (가맹점이름) — varchar2(64)
- serviceGubun (가맹점 업종분류) — char(4)
- Field4 (가맹점전화번호) — long(64)
- companyNumber (사업자번호) — int(10