/*
================================================================================
档案代号:abf_file
档案名称:列印族群资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table abf_file
(
abf01       varchar2(10) NOT NULL,   /*使用者编号                             */
abf02       varchar2(6) NOT NULL,    /*族群编号                               */
abf03       varchar2(1),             /*No Use                                 */
abf04       varchar2(1),             /*No Use                                 */
abf05       varchar2(1),             /*No Use                                 */
abf06       varchar2(1),             /*No Use                                 */
abf07       varchar2(1),             /*No Use                                 */
abfacti     varchar2(1),             /*资料有效码                             */
abfuser     varchar2(10),            /*资料所有者                             */
abfgrup     varchar2(10),            /*资料所有部门                           */
abfmodu     varchar2(10),            /*资料修改者                             */
abfdate     date                     /*最近修改日                             */
);

create unique index abf_pk on abf_file (abf01,abf02);
alter table abf_file add  constraint abf_pk primary key  (abf01,abf02) enable validate;
grant select on abf_file to public;
grant index on abf_file to public;
grant update on abf_file to public;
grant delete on abf_file to public;
grant insert on abf_file to public;