/* ================================================================================ 档案代号:xmd_file 档案名称:特卖产品数量价格折扣档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table xmd_file ( xmd01 varchar2(6) NOT NULL, /*价格条件 */ xmd02 varchar2(4) NOT NULL, /*币别 */ xmd03 date NOT NULL, /*生效日期 */ xmd04 varchar2(10) NOT NULL, /*客户编号 */ xmd05 varchar2(6) NOT NULL, /*收款条件 */ xmd06 varchar2(40) NOT NULL, /*料件编号 */ xmd07 varchar2(4) NOT NULL, /*单位 */ xmd08 number(15,6) NOT NULL, /*最低数量 */ xmd09 number(9,4) /*折扣 */ ); create unique index xmd_pk on xmd_file (xmd01,xmd02,xmd03,xmd04,xmd05,xmd06,xmd07,xmd08); alter table xmd_file add constraint xmd_pk primary key (xmd01,xmd02,xmd03,xmd04,xmd05,xmd06,xmd07,xmd08) enable validate; grant select on xmd_file to public; grant index on xmd_file to public; grant update on xmd_file to public; grant delete on xmd_file to public; grant insert on xmd_file to public; |