/* ================================================================================ 档案代号:pjc_file 档案名称:wbs备注单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjc_file ( pjc01 varchar2(30) NOT NULL, /*wbs编码 */ pjc02 number(5) NOT NULL, /*行序 */ pjc03 varchar2(255) /*备注说明 */ ); create unique index pjc_pk on pjc_file (pjc01,pjc02); alter table pjc_file add constraint pjc_pk primary key (pjc01,pjc02) enable validate; grant select on pjc_file to public; grant index on pjc_file to public; grant update on pjc_file to public; grant delete on pjc_file to public; grant insert on pjc_file to public; |