/* ================================================================================ 档案代号:cmb_file 档案名称:LCM 料件价格单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cmb_file ( cmb01 varchar2(40) NOT NULL, /*料件编号 */ cmb02 number(5) NOT NULL, /*项次 */ cmb03 varchar2(2), /*异动类别 */ /*销售: 1A,1B,1C */ /*进货: 2A,2B,2C */ cmb04 date, /*异动日期-起值 */ cmb05 date, /*异动日期-迄值 */ cmb06 number(20,6) /*异动单价 */ ); create unique index cmb_pk on cmb_file (cmb01,cmb02); alter table cmb_file add constraint cmb_pk primary key (cmb01,cmb02) enable validate; grant select on cmb_file to public; grant index on cmb_file to public; grant update on cmb_file to public; grant delete on cmb_file to public; grant insert on cmb_file to public; |