/*
================================================================================
档案代号:fip_file
档案名称:保修项目作业资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fip_file
(
fip01       varchar2(10) NOT NULL,   /*项目编号                               */
fip02       number(5) NOT NULL,      /*项目序                                 */
fip03       varchar2(10),            /*作业编号                               */
fip04       varchar2(1),             /*No Use                                 */
fip05       varchar2(1),             /*No Use                                 */
fip06       varchar2(1)              /*No Use                                 */
);

create unique index fip_pk on fip_file (fip01,fip02);
alter table fip_file add  constraint fip_pk primary key  (fip01,fip02) enable validate;
grant select on fip_file to public;
grant index on fip_file to public;
grant update on fip_file to public;
grant delete on fip_file to public;
grant insert on fip_file to public;