/* ================================================================================ 档案代号:gei_file 档案名称:编码类别资料单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gei_file ( gei01 varchar2(10) NOT NULL, /*编码类别 */ gei02 varchar2(80), /*名称 */ gei03 varchar2(2), /*性质 */ gei04 number(5), /*总段数 */ gei05 number(5), /*总长度 */ gei06 varchar2(1), /*No Use */ gei07 varchar2(1), /*No Use */ geiacti varchar2(1), /*资料有效码 */ geiuser varchar2(10), /*资料所有者 */ geigrup varchar2(10), /*资料所有部门 */ geimodu varchar2(10), /*资料修改者 */ geidate date /*最近修改日 */ ); create unique index gei_pk on gei_file (gei01); alter table gei_file add constraint gei_pk primary key (gei01) enable validate; grant select on gei_file to public; grant index on gei_file to public; grant update on gei_file to public; grant delete on gei_file to public; grant insert on gei_file to public; |