/*
================================================================================
档案代号:tor_file
档案名称:节目编号资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tor_file
(
tor01       varchar2(4) NOT NULL,    /*节目代号                               */
tor02       varchar2(80),            /*节目名称                               */
toracti     varchar2(1)              /*资料有效码                             */
);

create unique index tor_pk on tor_file (tor01);
alter table tor_file add  constraint tor_pk primary key  (tor01) enable validate;
grant select on tor_file to public;
grant index on tor_file to public;
grant update on tor_file to public;
grant delete on tor_file to public;
grant insert on tor_file to public;