/*
================================================================================
档案代号:wcb_file
档案名称:spc 整合设定档(单头档设定)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table wcb_file
(
wcb01       varchar2(20) NOT NULL,   /*程式代号                               */
wcb02       varchar2(15) NOT NULL,   /*程式使用单头档                         */
wcb03       varchar2(20) NOT NULL,   /*单头档 key 值栏位1                     */
wcb04       varchar2(20),            /*单头档 key 值栏位2                     */
wcb05       varchar2(20),            /*单头档 key 值栏位3                     */
wcb06       varchar2(20),            /*单头档 key 值栏位4                     */
wcb07       varchar2(20),            /*单头档 key 值栏位5                     */
wcb08       varchar2(20),            /*单头档确认码栏位                       */
wcb09       varchar2(20),            /*单头档spc抛转码栏位                    */
wcb10       varchar2(1),             /*No Use                                 */
wcb11       varchar2(1),             /*No Use                                 */
wcb12       varchar2(1),             /*No Use                                 */
wcb13       varchar2(1),             /*No Use                                 */
wcb14       varchar2(1)              /*No Use                                 */
);

create unique index wcb_pk on wcb_file (wcb01);
alter table wcb_file add  constraint wcb_pk primary key  (wcb01) enable validate;
grant select on wcb_file to public;
grant index on wcb_file to public;
grant update on wcb_file to public;
grant delete on wcb_file to public;
grant insert on wcb_file to public;