/* ================================================================================ 档案代号:wsg_file 档案名称:easyflow 整合设定档(单据性质档设定) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table wsg_file ( wsg01 varchar2(20) NOT NULL, /*程式代号 */ wsg02 varchar2(15), /*使用单据性质档 */ wsg03 varchar2(20), /*单据档单别栏位 */ wsg04 varchar2(20), /*单据档单据名称栏位 */ wsg05 varchar2(20), /*单据档系统别栏位 */ wsg06 varchar2(5), /*程式所属单据系统别 */ wsg07 varchar2(20), /*单据档单据性质栏位 */ wsg08 varchar2(255), /*程式所属单据性质代号 */ wsg09 varchar2(20), /*单据档签核处理栏位 */ wsg10 varchar2(10), /*No Use */ wsg11 varchar2(10), /*No Use */ wsg12 varchar2(10), /*No Use */ wsg13 varchar2(10), /*No Use */ wsg14 varchar2(10), /*No Use */ wsg15 varchar2(10) /*No Use */ ); create unique index wsg_pk on wsg_file (wsg01); alter table wsg_file add constraint wsg_pk primary key (wsg01) enable validate; grant select on wsg_file to public; grant index on wsg_file to public; grant update on wsg_file to public; grant delete on wsg_file to public; grant insert on wsg_file to public; |