/* ================================================================================ 档案代号:gau_file 档案名称:主键与外键关联纪录档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gau_file ( gau01 varchar2(20) NOT NULL, /*主键Primary Key 栏位名称 */ gau02 varchar2(20), /*主键Primary Key Table名称 */ gau03 varchar2(20) NOT NULL, /*外键Foreign Key 栏位名称 */ gau04 varchar2(20), /*外键Foreign Key Table名称 */ gau05 varchar2(50), /*No Use */ gau06 varchar2(50), /*No Use */ gau07 varchar2(50) /*No Use */ ); create unique index gau_pk on gau_file (gau01,gau03); alter table gau_file add constraint gau_pk primary key (gau01,gau03) enable validate; grant select on gau_file to public; grant index on gau_file to public; grant update on gau_file to public; grant delete on gau_file to public; grant insert on gau_file to public; |