/* ================================================================================ 档案代号:gbl_file 档案名称:程式Action比照功能记录档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gbl_file ( gbl01 varchar2(20) NOT NULL, /*程式代码 */ gbl02 varchar2(80) NOT NULL, /*Action 代码 */ gbl03 varchar2(1), /*比对Action代码 */ gbl04 varchar2(1), /*No Use */ gbl05 varchar2(1) /*No Use */ ); create unique index gbl_pk on gbl_file (gbl01,gbl02); alter table gbl_file add constraint gbl_pk primary key (gbl01,gbl02) enable validate; grant select on gbl_file to public; grant index on gbl_file to public; grant update on gbl_file to public; grant delete on gbl_file to public; grant insert on gbl_file to public; |