/* ================================================================================ 档案代号:csg_file 档案名称:附加成本--料件分群码成本项目资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table csg_file ( csg01 varchar2(10) NOT NULL, /*料件分群码 */ csg02 varchar2(10) NOT NULL, /*成本项目 */ csg03 varchar2(10) NOT NULL /*比率成本项目 */ ); create unique index csg_pk on csg_file (csg01,csg02,csg03); alter table csg_file add constraint csg_pk primary key (csg01,csg02,csg03) enable validate; grant select on csg_file to public; grant index on csg_file to public; grant update on csg_file to public; grant delete on csg_file to public; grant insert on csg_file to public; |