/*
================================================================================
档案代号:fii_file
档案名称:设备系列型号资料单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fii_file
(
fii01       varchar2(30) NOT NULL,   /*系列号                                 */
fii02       varchar2(30) NOT NULL,   /*型号                                   */
fii03       varchar2(300),           /*安全说明                               */
fii04       varchar2(1),             /*No Use                                 */
fii05       varchar2(1),             /*No Use                                 */
fii06       varchar2(1),             /*No Use                                 */
fii07       varchar2(1),             /*No Use                                 */
fii08       varchar2(1),             /*No Use                                 */
fii09       varchar2(1),             /*No Use                                 */
fii10       varchar2(1),             /*No Use                                 */
fiiacti     varchar2(1),             /*资料有效码                             */
fiiuser     varchar2(10),            /*资料所有者                             */
fiigrup     varchar2(10),            /*资料所有部门                           */
fiimodu     varchar2(10),            /*最后修改人员                           */
fiidate     date                     /*最后修改日期                           */
);

create unique index fii_pk on fii_file (fii01,fii02);
alter table fii_file add  constraint fii_pk primary key  (fii01,fii02) enable validate;
grant select on fii_file to public;
grant index on fii_file to public;
grant update on fii_file to public;
grant delete on fii_file to public;
grant insert on fii_file to public;