/* ================================================================================ 档案代号:pju_file 档案名称:专案系统参数设定 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pju_file ( pju00 varchar2(1) DEFAULT '' NOT NULL, /*key value*/ pju01 varchar2(4), /*费用原因(材料需求) */ pju02 varchar2(4), /*费用原因(人力需求) */ pju03 varchar2(4), /*费用原因(设备需求) */ pju04 varchar2(4), /*费用原因(费用需求) */ pju05 varchar2(1), /*no use */ pju06 varchar2(1), /*no use */ pju07 varchar2(1), /*no use */ pju08 varchar2(1), /*no use */ pju09 varchar2(1), /*no use */ pju10 varchar2(1) /*no use */ ); create unique index pju_pk on pju_file (pju00); alter table pju_file add constraint pju_pk primary key (pju00) enable validate; grant select on pju_file to public; grant index on pju_file to public; grant update on pju_file to public; grant delete on pju_file to public; grant insert on pju_file to public; |