模版数据模型chenan.pdfVIP

模版

报告人隶属于购物组人武良呈

模块名退款结果处理接口模块

表名B2C_REFUND_RECORD_EXCEPTION

改动描述：新增退款记录异常信息表

DROPTABLEB2C_REFUND_RECORD_EXCEPTIONCASCADECONSTRAINTS

PURGE;

CREATETABLEB2C_REFUND_RECORD_EXCEPTION

(

CYBER_RETURN_LOG_IDVARCHAR2(18char)NOTNULL,

ORDER_IDCHAR(18char)NULL,

REFUND_IDVARCHAR2(10char)NULL,

EXCEPTION_INFOVARCHAR2(2000char)NULL,

CYBER_RETURN_REF_AMTNUMBER(15,2)NULL,

REFUND_TIMEVARCHAR2(20CHAR),

UPDATE_TIMETIMESTAMPNULL

)TABLESPACEEMALLLOG2;

--Addcommentstothetable

commentontableB2C_REFUND_RECORD_EXCEPTION

is退款记录异常信息表;

--Addcommentstothecolumns

commentoncolumn

B2C_REFUND_RECORD_EXCEPTION.cyber_return_log_id

is返回流水号;

commentoncolumnB2C_REFUND_RECORD_EXCEPTION.order_id

is订单号;

commentoncolumnB2C_REFUND_RECORD_EXCEPTION.refund_id

is退款单号;

commentoncolumnB2C_REFUND_RECORD_EXCEPTION.exception_info

is异常信息;

commentoncolumn

B2C_REFUND_RECORD_EXCEPTION.cyber_return_ref_amt

is返回退款金额;

commentoncolumnB2C_REFUND_RECORD_EXCEPTION.refund_time

is退款时间;

commentoncolumnB2C_REFUND_RECORD_EXCEPTION.update_time

is更新时间;

CREATEUNIQUEINDEXPK_B2C_REFUND_RECORD_EXCEPTIONON

B2C_REFUND_RECORD_EXCEPTION