/*
================================================================================
档案代号:zco_file
档案名称:员工自订BackgroundJob资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zco_file
(
zco01       varchar2(10) NOT NULL,   /*使用者代号                             */
                                     /*使用者代号,(Login user name)           */
zco02       varchar2(20) NOT NULL,   /*程式名称                               */
zco03       varchar2(80),            /*程式执行参数                           */
zco04       varchar2(2),             /*分                                     */
zco05       varchar2(2),             /*时                                     */
zco06       varchar2(2),             /*日                                     */
zco07       varchar2(2),             /*月                                     */
zco08       varchar2(255),           /*星期                                   */
zco09       varchar2(80),            /*Action                                 */
                                     /*Action ex:mail -s 'list' a@dsc.com<< out*/
zco10       varchar2(1),             /*Active 否                              */
                                     /*Active 否(Y/N)                         */
zco11       varchar2(10)             /*营运中心编号                           */
);

create unique index zco_pk on zco_file (zco01,zco02);
alter table zco_file add  constraint zco_pk primary key  (zco01,zco02) enable validate;
grant select on zco_file to public;
grant index on zco_file to public;
grant update on zco_file to public;
grant delete on zco_file to public;
grant insert on zco_file to public;