/* ================================================================================ 档案代号:obt_file 档案名称:车辆型号档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table obt_file ( obt01 varchar2(16) NOT NULL, /*车辆厂牌 */ obt02 varchar2(20) NOT NULL, /*车辆型号 */ obt03 varchar2(80) /*说明 */ ); create unique index obt_pk on obt_file (obt01,obt02); alter table obt_file add constraint obt_pk primary key (obt01,obt02) enable validate; grant select on obt_file to public; grant index on obt_file to public; grant update on obt_file to public; grant delete on obt_file to public; grant insert on obt_file to public; |