/*
================================================================================
档案代号:fac_file
档案名称:固定资产次类别档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fac_file
(
fac01       varchar2(10) NOT NULL,   /*次类别码                               */
fac02       varchar2(80),            /*类别名称                               */
facacti     varchar2(1),             /*资料有效码                             */
facuser     varchar2(10),            /*资料所有者                             */
facgrup     varchar2(10),            /*资料所有群                             */
facmodu     varchar2(10),            /*资料更改者                             */
facdate     date                     /*最近修改日                             */
);

create unique index fac_pk on fac_file (fac01);
alter table fac_file add  constraint fac_pk primary key  (fac01) enable validate;
grant select on fac_file to public;
grant index on fac_file to public;
grant update on fac_file to public;
grant delete on fac_file to public;
grant insert on fac_file to public;