/* ================================================================================ 档案代号:gal_file 档案名称:程式联结资料维护单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gal_file ( gal01 varchar2(20) NOT NULL, /*Link 程式代码 */ /*LINK程式 */ gal02 varchar2(5) NOT NULL, /*系统 */ gal03 varchar2(80) NOT NULL, /*程式名称 */ gal04 varchar2(1) /*客制否 */ /*是否链结个案区 Y/N */ ); create unique index gal_pk on gal_file (gal01,gal02,gal03); alter table gal_file add constraint gal_pk primary key (gal01,gal02,gal03) enable validate; grant select on gal_file to public; grant index on gal_file to public; grant update on gal_file to public; grant delete on gal_file to public; grant insert on gal_file to public; |