/* ================================================================================ 档案代号:fiz_file 档案名称:备件类型档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fiz_file ( fiz01 varchar2(4) NOT NULL, /*备件类型编号 */ fiz02 varchar2(80) /*说明 */ ); create unique index fiz_pk on fiz_file (fiz01); alter table fiz_file add constraint fiz_pk primary key (fiz01) enable validate; grant select on fiz_file to public; grant index on fiz_file to public; grant update on fiz_file to public; grant delete on fiz_file to public; grant insert on fiz_file to public; |