/* ================================================================================ 档案代号:tob_file 档案名称:区域编号资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tob_file ( tob01 varchar2(10) NOT NULL, /*区域代号 */ tob02 varchar2(80), /*区域名称 */ tobacti varchar2(1) /*资料有效码 */ ); create unique index tob_pk on tob_file (tob01); alter table tob_file add constraint tob_pk primary key (tob01) enable validate; grant select on tob_file to public; grant index on tob_file to public; grant update on tob_file to public; grant delete on tob_file to public; grant insert on tob_file to public; |