/* ================================================================================ 档案代号:pjda_file 档案名称:wbs本阶预计费用档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjda_file ( pjda01 varchar2(30) NOT NULL, /*本阶wbs编码 */ pjda02 varchar2(10) NOT NULL, /*费用代号 */ pjda03 varchar2(24), /*科目一 */ pjda04 varchar2(24), /*科目二 */ pjda05 number(20,6), /*预估金额(专案币别) */ pjdaacti varchar2(1), /*资料有效码 */ pjdadate date, /*最近修改日 */ pjdagrup varchar2(10), /*资料所有部门 */ pjdamodu varchar2(10), /*资料修改者 */ pjdauser varchar2(10) /*资料所有者 */ ); create unique index pjda_pk on pjda_file (pjda01,pjda02); alter table pjda_file add constraint pjda_pk primary key (pjda01,pjda02) enable validate; grant select on pjda_file to public; grant index on pjda_file to public; grant update on pjda_file to public; grant delete on pjda_file to public; grant insert on pjda_file to public; |