/* ================================================================================ 档案代号:gad_file 档案名称:目录暂存档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gad_file ( gad01 varchar2(10) NOT NULL, /*使用者名称 */ gad02 varchar2(10) NOT NULL, /*目录代号 */ gad03 number(5) NOT NULL, /*序号 */ gad04 varchar2(20) /*程式代号 */ ); create unique index gad_pk on gad_file (gad01,gad02,gad03); alter table gad_file add constraint gad_pk primary key (gad01,gad02,gad03) enable validate; grant select on gad_file to public; grant index on gad_file to public; grant update on gad_file to public; grant delete on gad_file to public; grant insert on gad_file to public; |