/* ================================================================================ 档案代号:cmc_file 档案名称:LCM 料件数量入库异动档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cmc_file ( cmc01 varchar2(40) NOT NULL, /*料件编号 */ cmc02 date, /*计算基准日 */ cmc03 date NOT NULL, /*异动日期 */ cmc04 number(15,5) /*数量 */ /*数量 (不含除外仓之入库量) */ ); create unique index cmc_pk on cmc_file (cmc01,cmc03); alter table cmc_file add constraint cmc_pk primary key (cmc01,cmc03) enable validate; grant select on cmc_file to public; grant index on cmc_file to public; grant update on cmc_file to public; grant delete on cmc_file to public; grant insert on cmc_file to public; |