/*
================================================================================
档案代号: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;