/* ================================================================================ 档案代号:obq_file 档案名称:车辆类型档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table obq_file ( obq01 varchar2(4) NOT NULL, /*车辆类型 */ obq02 varchar2(80), /*说明 */ obqacti varchar2(1), /*资料有效码 */ obquser varchar2(10), /*资料所有者 */ obqgrup varchar2(10), /*资料所有部门 */ obqmodu varchar2(10), /*资料修改者 */ obqdate date /*最近修改日 */ ); create unique index obq_pk on obq_file (obq01); alter table obq_file add constraint obq_pk primary key (obq01) enable validate; grant select on obq_file to public; grant index on obq_file to public; grant update on obq_file to public; grant delete on obq_file to public; grant insert on obq_file to public; |