/*
================================================================================
档案代号:fje_file
档案名称:工单型态档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fje_file
(
fje01       varchar2(4) NOT NULL,    /*工单型态编号                           */
fje02       varchar2(80),            /*说明                                   */
fje03       varchar2(1),             /*性质                                   */
                                     /*1.维修 2.保养                          */
fje04       varchar2(1),             /*No Use                                 */
fje05       varchar2(1),             /*No Use                                 */
fje06       varchar2(1),             /*No Use                                 */
fje07       varchar2(1),             /*No Use                                 */
fje08       varchar2(1),             /*No Use                                 */
fje09       varchar2(1),             /*No Use                                 */
fje10       varchar2(1)              /*No Use                                 */
);

create unique index fje_pk on fje_file (fje01);
alter table fje_file add  constraint fje_pk primary key  (fje01) enable validate;
grant select on fje_file to public;
grant index on fje_file to public;
grant update on fje_file to public;
grant delete on fje_file to public;
grant insert on fje_file to public;