/* ================================================================================ 档案代号:pjd_file 档案名称:wbs累计预计费用档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjd_file ( pjd01 varchar2(30) NOT NULL, /*wbs编码 */ pjd02 varchar2(10) NOT NULL, /*费用代号 */ pjd03 varchar2(24) NOT NULL, /*科目一 */ pjd04 varchar2(24) NOT NULL, /*科目二 */ pjd05 number(20,6) /*预估金额 */ ); create unique index pjd_pk on pjd_file (pjd01,pjd02,pjd03,pjd04); alter table pjd_file add constraint pjd_pk primary key (pjd01,pjd02,pjd03,pjd04) enable validate; grant select on pjd_file to public; grant index on pjd_file to public; grant update on pjd_file to public; grant delete on pjd_file to public; grant insert on pjd_file to public; |