/*
================================================================================
档案代号:wsd_file
档案名称:EasyFlow 整合设定主档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table wsd_file
(
wsd01       varchar2(20) NOT NULL,   /*程式代号                               */
wsd02       varchar2(1) NOT NULL,    /*是否为 Hard Code 程式                  */
wsd03       varchar2(10),            /*No Use                                 */
wsd04       varchar2(10),            /*No Use                                 */
wsd05       varchar2(10),            /*No Use                                 */
wsd06       varchar2(10),            /*No Use                                 */
wsd07       varchar2(10),            /*No Use                                 */
wsd08       varchar2(10),            /*No Use                                 */
wsd09       varchar2(10),            /*No Use                                 */
wsd10       varchar2(10),            /*No Use                                 */
wsdacti     varchar2(1),             /*资料有效码                             */
wsduser     varchar2(10),            /*资料所有者                             */
wsdgrup     varchar2(10),            /*资料所有群                             */
wsdmodu     varchar2(10),            /*资料更改者                             */
wsddate     date                     /*最近修改日                             */
);

create unique index wsd_pk on wsd_file (wsd01);
alter table wsd_file add  constraint wsd_pk primary key  (wsd01) enable validate;
grant select on wsd_file to public;
grant index on wsd_file to public;
grant update on wsd_file to public;
grant delete on wsd_file to public;
grant insert on wsd_file to public;