/*
================================================================================
档案代号:wsr_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table wsr_file
(
wsr01       varchar2(40) DEFAULT '' NOT NULL, /*服务代码*/
wsr02       varchar2(1) DEFAULT '' NOT NULL, /*存取模式*/
wsr03       varchar2(80) DEFAULT '' NOT NULL, /*服务说明*/
wsr04       varchar2(40) DEFAULT '' NOT NULL, /*对应 erp 函式名称*/
wsracti     varchar2(1),             /*资料有效码                             */
wsrdate     date,                    /*最后异动日期                           */
wsrgrup     varchar2(6),             /*资料所有群                             */
wsrmodu     varchar2(10),            /*资料更改者                             */
wsruser     varchar2(10)             /*资料所有者                             */
);

create unique index wsr_pk on wsr_file (wsr01,wsr02);
alter table wsr_file add  constraint wsr_pk primary key  (wsr01,wsr02) enable validate;
grant select on wsr_file to public;
grant index on wsr_file to public;
grant update on wsr_file to public;
grant delete on wsr_file to public;
grant insert on wsr_file to public;