/*
================================================================================
档案代号:smv_file
档案名称:单别限使用部门明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table smv_file
(
smv01       varchar2(6),             /*单    别                               */
smv02       varchar2(10),            /*设限使用部门                           */
smv03       varchar2(3),             /*系统别                                 */
smv04       varchar2(1)              /*No Use                                 */
);

create        index smv_01 on smv_file (smv01,smv02,smv03);
grant select on smv_file to public;
grant index on smv_file to public;
grant update on smv_file to public;
grant delete on smv_file to public;
grant insert on smv_file to public;