sedaily
Tables (4)
T_Payment_order_data (결제자 정보)
- Reserve_key (Key) — varchar(50) — Primary key — NOT NULL
- Seq — bigint — NOT NULL
- Item_key — varchar(50)
- Reserve_company — varchar(50) — NOT NULL
- Reserve_name — varchar(50) — NOT NULL
- Reserve_mail — varchar(50) — NOT NULL
- Reserve_phone — varchar(20) — NOT NULL
- Reserve_money — int — NOT NULL
- Reserve_agent — varchar(50)
- Reserve_recruit — int — NOT NULL
- Reserve_recruit_info — varchar(max) — NOT NULL
- Payment_type — char(1) — NOT NULL
- Payment_datetime — varchar(14) — NOT NULL
- Approve_datetime — varchar(14)
- Approve_status — tinyint — NOT NULL
- Reserve_Oid — varchar(50) — NOT NULL
- Reserve_position — varchar(50)
- Error_datetime — varchar(14)
T_Payment_order_user_data (결제 자 포함 참가자 정보)
- Seq — bigint — NOT NULL
- Reserve_name — varchar(50)
- Reserve_mail — varchar(50)
- Reserve_phone — varchar(20)
- Reserve_position — varchar(50)
- I_DateTime — varchar(14) — NOT NULL
- Reserve_key (Key) — varchar(50) — Foreign key → T_Payment_order_data.Reserve_key — NOT NULL
T_Payment_receipt_data (결제 현금 영수증 요청 정보)
- Seq — bigint — NOT NULL
- Item_key — varchar(50)
- CName — varchar(100) — NOT NULL
- CNumber — varchar(100) — NOT NULL
- ImgPath — varchar(100) — NOT NULL
- OName — varchar(50) — NOT NULL
- MName — varchar(50) — NOT NULL
- M_Mail — varchar(50) — NOT NULL
- MPhone — varchar(20) — NOT NULL
- Reg_datetime — varchar(14) — NOT NULL
- Reserve_key (Key) — varchar(50) — Foreign key → T_Payment_order_data.Reserve_key — NOT NULL
T_Payment_xpay_log (결제 이벤트 정보 (대기/최종승인/에러))
- LGD_TID — varchar(255)
- LGD_MID — varchar(255)
- LGD_OID — varchar(255)
- LGD_AMOUNT — varchar(255)
- LGD_RESPCODE — varchar(255)
- LGD_RESPMSG — varchar(255)
- Approve_status — tinyint — NOT NULL
- RequestData — varchar(max)
- I_datatime — varchar(14) — NOT NULL
- Reserve_key (Key) — varchar(50) — Foreign key → T_Payment_order_data.Reserve_key — NOT NULL