/*
================================================================================
档案代号:cam_file
档案名称:每日投入工时单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cam_file
(
cam01       date NOT NULL,           /*日期                                   */
cam02       varchar2(10) NOT NULL,   /*成本中心                               */
cam03       number(5) NOT NULL,      /*序号                                   */
cam04       varchar2(16),            /*工单编号                               */
cam05       varchar2(19),            /*RUN CARD                               */
cam06       number(5),               /*制程序                                 */
cam07       number(15,3),            /*约当数量                               */
cam08       number(15,3),            /*投入工时                               */
cam09       varchar2(255),           /*备注                                   */
cam10       number(15,3),            /*投入标准人工工时                       */
cam11       number(15,3),            /*投入标准机器工时                       */
camud01     varchar2(255),           /*自订栏位-Textedit                      */
camud02     varchar2(40),            /*自订栏位-文字                          */
camud03     varchar2(40),            /*自订栏位-文字                          */
camud04     varchar2(40),            /*自订栏位-文字                          */
camud05     varchar2(40),            /*自订栏位-文字                          */
camud06     varchar2(40),            /*自订栏位-文字                          */
camud07     number(15,3),            /*自订栏位-数值                          */
camud08     number(15,3),            /*自订栏位-数值                          */
camud09     number(15,3),            /*自订栏位-数值                          */
camud10     number(10),              /*自订栏位-整数                          */
camud11     number(10),              /*自订栏位-整数                          */
camud12     number(10),              /*自订栏位-整数                          */
camud13     date,                    /*自订栏位-日期                          */
camud14     date,                    /*自订栏位-日期                          */
camud15     date                     /*自订栏位-日期                          */
);

create        index cam_02 on cam_file (cam04);
create unique index cam_pk on cam_file (cam01,cam02,cam03);
alter table cam_file add  constraint cam_pk primary key  (cam01,cam02,cam03) enable validate;
grant select on cam_file to public;
grant index on cam_file to public;
grant update on cam_file to public;
grant delete on cam_file to public;
grant insert on cam_file to public;