/* ================================================================================ 档案代号:idl_file 档案名称:ICD批号档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table idl_file ( idl01 varchar2(24) DEFAULT '' NOT NULL, /*生产批号*/ idl02 varchar2(2), /*最大编号 */ idl03 varchar2(10), /*no use */ idl04 varchar2(10) /*no use */ ); create unique index idl_pk on idl_file (idl01); alter table idl_file add constraint idl_pk primary key (idl01) enable validate; grant select on idl_file to public; grant index on idl_file to public; grant update on idl_file to public; grant delete on idl_file to public; grant insert on idl_file to public; |