/* ================================================================================ 档案代号:xmg_file 档案名称:产品数量价格折扣档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table xmg_file ( xmg01 varchar2(6) NOT NULL, /*价格条件编号 */ xmg02 varchar2(4) NOT NULL, /*币别 */ xmg03 varchar2(40) NOT NULL, /*料件编号 */ xmg04 varchar2(4) NOT NULL, /*单位 */ xmg05 date NOT NULL, /*生效日期 */ xmg06 number(15,6) NOT NULL, /*最低数量 */ xmg07 number(9,4) /*折扣 */ ); create unique index xmg_pk on xmg_file (xmg01,xmg02,xmg03,xmg04,xmg05,xmg06); alter table xmg_file add constraint xmg_pk primary key (xmg01,xmg02,xmg03,xmg04,xmg05,xmg06) enable validate; grant select on xmg_file to public; grant index on xmg_file to public; grant update on xmg_file to public; grant delete on xmg_file to public; grant insert on xmg_file to public; |