/*
================================================================================
档案代号:fiy_file
档案名称:保修项目备件资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fiy_file
(
fiy01       varchar2(10) NOT NULL,   /*项目编号                               */
fiy02       number(5) NOT NULL,      /*项次                                   */
fiy03       varchar2(40),            /*备件编号                               */
fiy04       varchar2(4),             /*单位                                   */
fiy05       number(15,3),            /*人数                                   */
fiy06       varchar2(1),             /*必需否                                 */
fiy07       varchar2(1),             /*No Use                                 */
fiy08       varchar2(1),             /*No Use                                 */
fiy09       varchar2(1),             /*No Use                                 */
fiy10       varchar2(1)              /*No Use                                 */
);

create unique index fiy_pk on fiy_file (fiy01,fiy02);
alter table fiy_file add  constraint fiy_pk primary key  (fiy01,fiy02) enable validate;
grant select on fiy_file to public;
grant index on fiy_file to public;
grant update on fiy_file to public;
grant delete on fiy_file to public;
grant insert on fiy_file to public;