/* ================================================================================ 档案代号:geu_file 档案名称:集团中心资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table geu_file ( geu00 varchar2(1), /*集团中心类别 */ geu01 varchar2(10) NOT NULL, /*集团中心代码 */ geu02 varchar2(80), /*集团中心名称 */ geuacti varchar2(1), /*资料有效码 */ geuuser varchar2(10), /*资料所有者 */ geugrup varchar2(10), /*资料所有群 */ geumodu varchar2(10), /*资料更改者 */ geudate date /*最近修改日 */ ); create unique index geu_pk on geu_file (geu01); alter table geu_file add constraint geu_pk primary key (geu01) enable validate; grant select on geu_file to public; grant index on geu_file to public; grant update on geu_file to public; grant delete on geu_file to public; grant insert on geu_file to public; |