/* ================================================================================ 档案代号:ccn_file 档案名称:标准BOM元件单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ccn_file ( ccn01 varchar2(40) NOT NULL, /*主件料号 */ ccn02 varchar2(10) NOT NULL, /*标准成本版本 */ ccn03 number(5) NOT NULL, /*项次 */ ccn04 varchar2(40), /*元件料号 */ ccn05 number(16,8), /*标准 QPA */ ccn06 number(9,4), /*损耗率 */ ccndate date /*最近修改日期 */ ); create unique index ccn_pk on ccn_file (ccn01,ccn02,ccn03); alter table ccn_file add constraint ccn_pk primary key (ccn01,ccn02,ccn03) enable validate; grant select on ccn_file to public; grant index on ccn_file to public; grant update on ccn_file to public; grant delete on ccn_file to public; grant insert on ccn_file to public; |