/*
================================================================================
档案代号:zxx_file
档案名称:使用者目前使用营运中心档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zxx_file
(
zxx01       varchar2(10) NOT NULL,   /*使用者代号                             */
                                     /*使用者代号,(Login user name)           */
zxx02       varchar2(32) NOT NULL,   /*使用者终端机代号                       */
zxx03       varchar2(10)             /*目前使用营运中心编号                   */
);

create unique index zxx_pk on zxx_file (zxx01,zxx02);
alter table zxx_file add  constraint zxx_pk primary key  (zxx01,zxx02) enable validate;
grant select on zxx_file to public;
grant index on zxx_file to public;
grant update on zxx_file to public;
grant delete on zxx_file to public;
grant insert on zxx_file to public;