/* ================================================================================ 档案代号:gel_file 档案名称:编码类别资料单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gel_file ( gel01 varchar2(10) NOT NULL, /*编码类别 */ gel02 number(5) NOT NULL, /*段次 */ gel03 number(5), /*长度 */ gel04 varchar2(1), /*型态 */ gel05 varchar2(10), /*固定值/独立段编号 */ gel06 varchar2(80), /*段次说明 */ gel07 varchar2(1) /*名称显示否 */ ); create unique index gel_pk on gel_file (gel01,gel02); alter table gel_file add constraint gel_pk primary key (gel01,gel02) enable validate; grant select on gel_file to public; grant index on gel_file to public; grant update on gel_file to public; grant delete on gel_file to public; grant insert on gel_file to public; |