/*
================================================================================
档案代号:cof_file
档案名称:商品编号币别单价资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cof_file
(
cof01       varchar2(40) NOT NULL,   /*商品编号                               */
cof02       varchar2(4) NOT NULL,    /*币别                                   */
cof03       number(20,6),            /*单价                                   */
cof04       varchar2(4),             /*No Use                                 */
cof05       varchar2(4),             /*No Use                                 */
cof06       number(16,8),            /*No Use                                 */
cof07       varchar2(1),             /*No Use                                 */
cof08       varchar2(1),             /*No Use                                 */
cof09       varchar2(1),             /*No Use                                 */
cofud01     varchar2(255),           /*自订栏位-Textedit                      */
cofud02     varchar2(40),            /*自订栏位-文字                          */
cofud03     varchar2(40),            /*自订栏位-文字                          */
cofud04     varchar2(40),            /*自订栏位-文字                          */
cofud05     varchar2(40),            /*自订栏位-文字                          */
cofud06     varchar2(40),            /*自订栏位-文字                          */
cofud07     number(15,3),            /*自订栏位-数值                          */
cofud08     number(15,3),            /*自订栏位-数值                          */
cofud09     number(15,3),            /*自订栏位-数值                          */
cofud10     number(10),              /*自订栏位-整数                          */
cofud11     number(10),              /*自订栏位-整数                          */
cofud12     number(10),              /*自订栏位-整数                          */
cofud13     date,                    /*自订栏位-日期                          */
cofud14     date,                    /*自订栏位-日期                          */
cofud15     date                     /*自订栏位-日期                          */
);

create unique index cof_pk on cof_file (cof01,cof02);
alter table cof_file add  constraint cof_pk primary key  (cof01,cof02) enable validate;
grant select on cof_file to public;
grant index on cof_file to public;
grant update on cof_file to public;
grant delete on cof_file to public;
grant insert on cof_file to public;