ddd

Tables (4)

Untitled

    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