/* ================================================================================ 档案代号:cxz_file 档案名称:工单成本项目资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cxz_file ( cxz01 varchar2(40) NOT NULL, /*工单单号重覆性生产产品成本 */ cxz02 varchar2(10) NOT NULL, /*成本中心 */ cxz03 varchar2(10) NOT NULL, /*成本项目 */ cxz04 number(20,6), /*人工总成本 */ cxz05 number(20,6), /*制费总成本 */ cxz06 number(15,3), /*人工指标总数 */ cxz07 number(15,3) /*制费指标总数 */ ); create unique index cxz_pk on cxz_file (cxz01,cxz02,cxz03); alter table cxz_file add constraint cxz_pk primary key (cxz01,cxz02,cxz03) enable validate; grant select on cxz_file to public; grant index on cxz_file to public; grant update on cxz_file to public; grant delete on cxz_file to public; grant insert on cxz_file to public; |