/*
================================================================================
档案代号:wsm_file
档案名称:ERP 服务与他系统间栏位对应关系单头档
档案目的:提供建立呼叫 erp 服务建立资料时, 他系统与 erp 栏位的对应关系
上游档案:
下游档案:
============.========================.==========================================
*/
create table wsm_file
(
wsm01       varchar2(80) NOT NULL,   /*服务代码                               */
wsm02       varchar2(15) NOT NULL,   /*table 名称                             */
wsmacti     varchar2(1),             /*资料有效码                             */
wsmdate     date,                    /*最后异动日期                           */
wsmgrup     varchar2(10),            /*资料建立人员群组                       */
wsmmodu     varchar2(10),            /*最后异动人员                           */
wsmuser     varchar2(10)             /*资料建立人员                           */
);

create unique index wsm_pk on wsm_file (wsm01,wsm02);
alter table wsm_file add  constraint wsm_pk primary key  (wsm01,wsm02) enable validate;
grant select on wsm_file to public;
grant index on wsm_file to public;
grant update on wsm_file to public;
grant delete on wsm_file to public;
grant insert on wsm_file to public;