/*
================================================================================
档案代号:wcc_file
档案名称:spc 整合设定档(表单整合栏位设定)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table wcc_file
(
wcc01       varchar2(20) NOT NULL,   /*程式代号                               */
wcc02       varchar2(20) NOT NULL,   /*栏位名称                               */
wcc03       varchar2(1),             /*更新否                                 */
wcc04       varchar2(1),             /*No Use                                 */
wcc05       varchar2(1),             /*No Use                                 */
wcc06       varchar2(1),             /*No Use                                 */
wcc07       varchar2(1)              /*No Use                                 */
);

create unique index wcc_pk on wcc_file (wcc01,wcc02);
alter table wcc_file add  constraint wcc_pk primary key  (wcc01,wcc02) enable validate;
grant select on wcc_file to public;
grant index on wcc_file to public;
grant update on wcc_file to public;
grant delete on wcc_file to public;
grant insert on wcc_file to public;