/*
================================================================================
档案代号:wcd_file
档案名称:spc 整合设定档(基本资料栏位设定)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table wcd_file
(
wcd01       varchar2(15) NOT NULL,   /*档案代码                               */
wcd02       varchar2(20) NOT NULL,   /*栏位名称                               */
wcd03       varchar2(1),             /*No Use                                 */
wcd04       varchar2(1),             /*No Use                                 */
wcd05       varchar2(1),             /*No Use                                 */
wcd06       varchar2(1),             /*No Use                                 */
wcd07       varchar2(1)              /*No Use                                 */
);

create unique index wcd_pk on wcd_file (wcd01,wcd02);
alter table wcd_file add  constraint wcd_pk primary key  (wcd01,wcd02) enable validate;
grant select on wcd_file to public;
grant index on wcd_file to public;
grant update on wcd_file to public;
grant delete on wcd_file to public;
grant insert on wcd_file to public;