/* ================================================================================ 档案代号:pjo_file 档案名称:专案多阶段收付款主档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjo_file ( pjo01 varchar2(10) NOT NULL, /*专案代号 */ pjo02 varchar2(1) NOT NULL, /*收/付款 */ pjoacti varchar2(1), /*资料有效码 */ pjoconf varchar2(1), /*确认码 */ pjodate date, /*最近修改日 */ pjogrup varchar2(10), /*资料所有部门 */ pjomodu varchar2(10), /*资料修改者 */ pjouser varchar2(10) /*资料所有者 */ ); create unique index pjo_pk on pjo_file (pjo01,pjo02); alter table pjo_file add constraint pjo_pk primary key (pjo01,pjo02) enable validate; grant select on pjo_file to public; grant index on pjo_file to public; grant update on pjo_file to public; grant delete on pjo_file to public; grant insert on pjo_file to public; |