/* ================================================================================ 档案代号:gbc_file 档案名称:名称多语言对照档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gbc_file ( gbc01 varchar2(15) NOT NULL, /*档案代码 */ gbc02 varchar2(20) NOT NULL, /*栏位代码 */ gbc03 varchar2(255) NOT NULL, /*KEY 值序列 */ gbc04 varchar2(1) NOT NULL, /*语言别 */ gbc05 varchar2(100), /*各语言别下的名称 */ gbc06 varchar2(1), /*No Use */ gbc07 varchar2(1) /*No Use */ ); create unique index gbc_pk on gbc_file (gbc01,gbc02,gbc03,gbc04); alter table gbc_file add constraint gbc_pk primary key (gbc01,gbc02,gbc03,gbc04) enable validate; grant select on gbc_file to public; grant index on gbc_file to public; grant update on gbc_file to public; grant delete on gbc_file to public; grant insert on gbc_file to public; |