dsf
테이블 (6)
API구분코드 (Untitled)
- 0001 (조회)
- 0002 (적립)
- 0003 (사용)
- 0004 (취소)
Point_History (포인트 전환 로그)
- payNo (Field2)
- txNo (Field4)
- privilegeNo (Field) — varchar
- regDate (Field3) — timestamp
- apiTo (Field6) — varchar
- apiType (Field10) — varchar
- apiStatus (Field11) — varchar
- errorMsg (Field14) — varchar
- requestBody (Field15) — varchar
- requestHeader (Field9) — varchar
- response (Field5)
Point_History_Detail (포인트 전환 내역 상세)
- txDetailNo (PK) — varchar — 기본 키 — NOT NULL
- txNo (Field8) — varchar
- privilegeNo (Field) — varchar
- fromAmount (Field2) — varchar
- toAmount (Field3) — varchar
- apiType (Field4) — varchar
- apiStatus (Field5) — varchar
- apiUrl (Field12) — varchar
- start_date (Field6) — timestamp
- end_date (Field7) — timestamp
- errorCode (Field11) — varchar
- errorMsg (Field10) — varchar
- descript (Field9) — varchar
TCM_POINT_COOP_PAY_POINT_CONVERSION (포인트 전환 내역)
- payNo (Key) — varchar — 기본 키 — NOT NULL
- profileID (Field2) — varchar
- privilegeNo (Field4) — varchar
- confirmNo (Field) — varchar
- coopPayTxNo (Field6) — varchar
- point (Field10) — 실수형
- convertPayPoint (Field15) — 실수형
- transactionType (Field8) — varchar
- transactionStatus (Field12) — varchar
- requestDate (Field3)
- completeDate (Field14)
- cancelId (Field9)
- cancelTxNo (Field5)
- cancelReason (Field7)
- cancelDate (Field11)
- coopCd (Field13)
거래구분코드 (title)
- 0001 (적립)
- 0002 (사용)
- 0003 (취소)
- 0004 (만료)
제휴사코드 (title1)
- 0001 (CJ)
- 0002 (Naver)
- 0003 (Asiana)
- 0004 (Field4)