/* ================================================================================ 档案代号:xmf_file 档案名称:产品价格单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table xmf_file ( xmf01 varchar2(6) NOT NULL, /*价格条件编号 */ /*价格条件编号 Ex:FOB CIF C与F CIF与C5*/ xmf02 varchar2(4) NOT NULL, /*币别 */ xmf03 varchar2(40) NOT NULL, /*料件编号 */ xmf04 varchar2(4) NOT NULL, /*单位 */ xmf05 date NOT NULL, /*生效日期 */ xmf06 date, /*No Use */ xmf07 number(20,6), /*订价 */ xmf08 number(15,3) /*折扣 */ ); create unique index xmf_pk on xmf_file (xmf01,xmf02,xmf03,xmf04,xmf05); alter table xmf_file add constraint xmf_pk primary key (xmf01,xmf02,xmf03,xmf04,xmf05) enable validate; grant select on xmf_file to public; grant index on xmf_file to public; grant update on xmf_file to public; grant delete on xmf_file to public; grant insert on xmf_file to public; |