订单退货表结构变更报告.pdfVIP

数据改动描述表

报告人赵隶属于购物组审批人

模块名订单模块

‑‑订单退货表结构更改：

droptableb2c_refund_return;

commit;

CREATETABLEB2C_REFUND_RETURN(

REFUND_RETURN_IDCHAR(18)主键NOTNULL,

REFUND_IDVARCHAR2(10)不为空,

REFUND_TIMETIMESTAMP,

REFUND_REASONVARCHAR2(200),

REFUND_TYPECHAR(2),

EXPRESS_COMPANY_IDVARCHAR2(10),

EXPRESS_COMPANY_NAMEVARCHAR2(100),

DELIVERY_NUMVARCHAR2(100),

MERCHANT_REFUSE_REASONVARCHAR2(200),

RETURN_ADDRESSVARCHAR2(200),

STORE_IDVARCHAR2(20)

);

commit;

数据改动描述表

报告人赵隶属于购物组人

模块名订单模块

--订单退货表结构更改：

droptableb2c_refund_return;

commit;

CREATETABLE

B2C_REFUND_RETURN(REFUND_RETURN_ID

CHAR(18)primarykeyNOTNULL,

REFUND_IDVARCHAR2(10)NOTNULL,

REFUND_TIMETIMESTAMP,

REFUND_REASONVARCHAR2(200),

REFUND_TYPECHAR(2),

EXPRESS_COMPANY_IDVARCHAR2(10),

EXPRESS_COMPANY_NAMEVARCHAR2(100),

DELIVERY_NUMVARCHAR2(100),

MERCHANT_REFUSE_REASONVARCHAR2(200),

RETURN_ADDRESSVARCHAR2(200),

STORE_IDVARCHAR2(20)

);

commit;

commentoncolumn

B2C_REFUND_RETURN.REFUND_RETURN_IDis退货编号;

commentoncolumnB2C_REFUND_RETURN.REFUND_IDis退款单

编号;commentoncolumn

B2C_REFUND_RETURN.REFUND_TIMEis退货时间;commenton

columnB2C_REFUND_RETURN.REFUND_REASONis退货;

commentoncolumnB2C_REFUND_RETURN.REFUND_TYPEis退

换货类型;commentoncolumn

B2C_REFUND_RETURN.EXPRESS_COMPANY_IDis配送公司编号;

commentoncolumn

B2C_REFUND_RETURN.EXPRESS_COMPANY_NAMEis配送公司名

称;commentoncolumnB2C_REFUND_RETURN.DELIVERY_NU

Mis配送编号;commentoncolumn

B2C_REFUND_RETURN.MERCHANT_REFUSE_REASONis商户

;commentoncolumn

B2C_REFUND_RETURN.RETURN_ADDRESSis退货地址;co

m