/*
================================================================================
档案代号:wsn_file
档案名称:ERP 服务 TABLE 栏位预设值单身档
档案目的:提供建立 erp 服务选定 table 栏位预设值
上游档案:
下游档案:
============.========================.==========================================
*/
create table wsn_file
(
wsn01       varchar2(80) NOT NULL,   /*服务代码                               */
wsn02       varchar2(15) NOT NULL,   /*table 名称                             */
wsn03       varchar2(20) NOT NULL,   /*table 栏位名称                         */
wsn04       varchar2(30)             /*栏位预设值                             */
);

create unique index wsn_pk on wsn_file (wsn01,wsn02,wsn03);
alter table wsn_file add  constraint wsn_pk primary key  (wsn01,wsn02,wsn03) enable validate;
grant select on wsn_file to public;
grant index on wsn_file to public;
grant update on wsn_file to public;
grant delete on wsn_file to public;
grant insert on wsn_file to public;