/*
================================================================================
档案代号:smz_file
档案名称:单别限定仓库储位明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table smz_file
(
smz01       varchar2(5) NOT NULL,    /*单    别                               */
smz02       varchar2(10) NOT NULL,   /*设限仓库                               */
smz021      varchar2(10),            /*设限仓库                               */
smz03       varchar2(10) NOT NULL,   /*设限储位                               */
smz031      varchar2(10)             /*设限储位                               */
);

create unique index smz_pk on smz_file (smz01,smz02,smz03);
alter table smz_file add  constraint smz_pk primary key  (smz01,smz02,smz03) enable validate;
grant select on smz_file to public;
grant index on smz_file to public;
grant update on smz_file to public;
grant delete on smz_file to public;
grant insert on smz_file to public;