/* ================================================================================ 档案代号:gfe_file 档案名称:单位档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gfe_file ( gfe01 varchar2(4) NOT NULL, /*单位 */ gfe02 varchar2(80), /*说明 */ gfe03 number(5), /*小数位数 */ gfeacti varchar2(1), /*资料有效码 */ gfeuser varchar2(10), /*资料所有者 */ gfegrup varchar2(10), /*资料所有部门 */ gfemodu varchar2(10), /*资料修改者 */ gfedate date /*最近修改日 */ ); create unique index gfe_pk on gfe_file (gfe01); alter table gfe_file add constraint gfe_pk primary key (gfe01) enable validate; grant select on gfe_file to public; grant index on gfe_file to public; grant update on gfe_file to public; grant delete on gfe_file to public; grant insert on gfe_file to public; |