/* ================================================================================ 档案代号:toa_file 档案名称:媒体编号资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table toa_file ( toa01 varchar2(4) NOT NULL, /*媒体代号 */ toa02 varchar2(80), /*媒体名称 */ toa03 varchar2(1), /*类别 */ toaacti varchar2(1) /*有效否 */ ); create unique index toa_pk on toa_file (toa01); alter table toa_file add constraint toa_pk primary key (toa01) enable validate; grant select on toa_file to public; grant index on toa_file to public; grant update on toa_file to public; grant delete on toa_file to public; grant insert on toa_file to public; |