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