/*
================================================================================
档案代号:wca_file
档案名称:spc 整合设定主档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table wca_file
(
wca01       varchar2(20) NOT NULL,   /*程式代号                               */
wca02       varchar2(1) NOT NULL,    /*是否为 hard code 程式                  */
wca03       varchar2(1),             /*No Use                                 */
wca04       varchar2(1),             /*No Use                                 */
wca05       varchar2(1),             /*No Use                                 */
wcaacti     varchar2(1),             /*资料有效码                             */
wcauser     varchar2(10),            /*资料所有者                             */
wcagrup     varchar2(10),            /*资料所有群                             */
wcamodu     varchar2(10),            /*资料更改者                             */
wcadate     date                     /*最近修改日                             */
);

create unique index wca_pk on wca_file (wca01);
alter table wca_file add  constraint wca_pk primary key  (wca01) enable validate;
grant select on wca_file to public;
grant index on wca_file to public;
grant update on wca_file to public;
grant delete on wca_file to public;
grant insert on wca_file to public;