/* ================================================================================ 档案代号:gak_file 档案名称:程式联结资料维护单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gak_file ( gak01 varchar2(20) NOT NULL, /*LINK程式 */ /* 程式代码 */ gak02 varchar2(100), /*No Use */ gak03 varchar2(1000), /*No Use */ gak04 varchar2(1), /*No Use */ gak05 varchar2(1), /*No Use */ gakuser varchar2(10), /*OWNER */ /* OWNER */ gakgrup varchar2(10), /*GROUP */ /* GROUP */ gakmodu varchar2(10), /*MODIFY USER */ /* MODIFY USER */ gakdate date /*MODIFY DATE */ /* MODIFY DATE */ ); create unique index gak_pk on gak_file (gak01); alter table gak_file add constraint gak_pk primary key (gak01) enable validate; grant select on gak_file to public; grant index on gak_file to public; grant update on gak_file to public; grant delete on gak_file to public; grant insert on gak_file to public; |