/* ================================================================================ 档案代号:obr_file 档案名称:车辆级别档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table obr_file ( obr01 varchar2(1) NOT NULL, /*车辆级别 */ obr02 varchar2(80), /*说明 */ obracti varchar2(1), /*资料有效码 */ obruser varchar2(10), /*资料所有者 */ obrgrup varchar2(10), /*资料所有部门 */ obrmodu varchar2(10), /*资料修改者 */ obrdate date /*最近修改日 */ ); create unique index obr_pk on obr_file (obr01); alter table obr_file add constraint obr_pk primary key (obr01) enable validate; grant select on obr_file to public; grant index on obr_file to public; grant update on obr_file to public; grant delete on obr_file to public; grant insert on obr_file to public; |