/* ================================================================================ 档案代号:gej_file 档案名称:独立段资料单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gej_file ( gej01 varchar2(10) NOT NULL, /*独立段编号 */ gej02 varchar2(80), /*名称 */ gej03 number(5), /*长度 */ gej04 varchar2(1), /*No Use */ gej05 varchar2(1), /*No Use */ gej06 varchar2(1), /*No Use */ gejacti varchar2(1), /*资料有效码 */ gejuser varchar2(10), /*资料所有者 */ gejgrup varchar2(10), /*资料所有部门 */ gejmodu varchar2(10), /*资料修改者 */ gejdate date /*最近修改日 */ ); create unique index gej_pk on gej_file (gej01); alter table gej_file add constraint gej_pk primary key (gej01) enable validate; grant select on gej_file to public; grant index on gej_file to public; grant update on gej_file to public; grant delete on gej_file to public; grant insert on gej_file to public; |