/* ================================================================================ 档案代号:ges_file 档案名称:变数基本资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ges_file ( ges01 varchar2(5) NOT NULL, /*变数代码 */ ges02 varchar2(80), /*变数名称 */ ges03 varchar2(2), /*变数性质 */ ges04 varchar2(255), /*默认值 */ ges05 number(5), /*小数位数 */ ges06 varchar2(10), /*No Use */ ges07 varchar2(10), /*No Use */ ges08 varchar2(10), /*No Use */ gesacti varchar2(1) /*有效否(y/n) */ ); create unique index ges_pk on ges_file (ges01); alter table ges_file add constraint ges_pk primary key (ges01) enable validate; grant select on ges_file to public; grant index on ges_file to public; grant update on ges_file to public; grant delete on ges_file to public; grant insert on ges_file to public; |