/*
================================================================================
档案代号:fig_file
档案名称:设备仪表资料单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fig_file
(
fig01       varchar2(20) NOT NULL,   /*设备编号                               */
fig02       varchar2(10) NOT NULL,   /*仪表编号                               */
fig03       varchar2(4),             /*度量单位                               */
fig04       number(15,3),            /*上限                                   */
fig05       number(15,3),            /*下限                                   */
fig06       varchar2(1),             /*No Use                                 */
fig07       varchar2(1),             /*No Use                                 */
fig08       varchar2(1),             /*No Use                                 */
fig09       varchar2(1),             /*No Use                                 */
fig10       varchar2(1),             /*No Use                                 */
figacti     varchar2(1),             /*资料有效码                             */
figuser     varchar2(10),            /*资料所有者                             */
figgrup     varchar2(10),            /*资料所有部门                           */
figmodu     varchar2(10),            /*最后修改人员                           */
figdate     date                     /*最后修改日期                           */
);

create unique index fig_pk on fig_file (fig01,fig02);
alter table fig_file add  constraint fig_pk primary key  (fig01,fig02) enable validate;
grant select on fig_file to public;
grant index on fig_file to public;
grant update on fig_file to public;
grant delete on fig_file to public;
grant insert on fig_file to public;