/* ================================================================================ 档案代号:ccm_file 档案名称:标准BOM主件单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ccm_file ( ccm01 varchar2(40) NOT NULL, /*主件料号 */ ccm02 varchar2(10) NOT NULL, /*标准成本版本 */ ccm03 number(5), /*标准工时 */ ccm04 number(5), /*No Use */ ccm05 number(5), /*No Use */ ccm06 number(5), /*No Use */ ccmuser varchar2(10), /*资料所有者 */ ccmgrup varchar2(10), /*资料GROUP */ ccmmodd date, /*最近修改日 */ ccmdate date /*最近成本卷算日 */ ); create unique index ccm_pk on ccm_file (ccm01,ccm02); alter table ccm_file add constraint ccm_pk primary key (ccm01,ccm02) enable validate; grant select on ccm_file to public; grant index on ccm_file to public; grant update on ccm_file to public; grant delete on ccm_file to public; grant insert on ccm_file to public; |