/* ================================================================================ 档案代号: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; |