/*
================================================================================
档案代号:fid_file
档案名称:作业资料单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fid_file
(
fid01       varchar2(10) NOT NULL,   /*作业编号                               */
fid02       varchar2(80),            /*说明                                   */
fid03       number(8,3),             /*预备工时,单位小时                      */
fid04       number(8,3),             /*标准工时,单位小时                      */
fid05       varchar2(1),             /*No                                     */
fid06       varchar2(1),             /*No                                     */
fid07       varchar2(1),             /*No                                     */
fid08       varchar2(1),             /*No                                     */
fid09       varchar2(1),             /*No                                     */
fid10       varchar2(1),             /*No                                     */
fidacti     varchar2(1),             /*资料有效码                             */
fiduser     varchar2(10),            /*资料所有者                             */
fidgrup     varchar2(10),            /*资料所有部门                           */
fidmodu     varchar2(10),            /*最后修改人员                           */
fiddate     date                     /*最后修改日期                           */
);

create unique index fid_pk on fid_file (fid01);
alter table fid_file add  constraint fid_pk primary key  (fid01) enable validate;
grant select on fid_file to public;
grant index on fid_file to public;
grant update on fid_file to public;
grant delete on fid_file to public;
grant insert on fid_file to public;