create table f1_best_complete_state (              //創(chuàng)一流得分表
recn                  integer not null ,
key_id             varchar(11) not null ,
primary key  (recn,key_id),
complete_state      varchar(400)
);



create table f2_ok_complete_state (               //達標(biāo)得分表
recn                  integer not null ,
key_id             varchar(13) not null ,
primary key  (recn,key_id),
complete_state      varchar(400)
);

create table f3_examine_gain (                    //考核評分指標(biāo)得分
check_bh            varchar(13) not null,
key_id              varchar(13) not null,
primary key (check_bh,key_id),
check_mark           decimal(4,1), 
province_mark        decimal(4,1), 
province_lost_reason varchar(400),
fact_mark            decimal(4,1),
lost_reason          varchar(400),
remark               varchar(400)
);     

create table f4_base_status (
key_id             varchar(13) not null primary key,
plant_name          varchar(100) not null,  
factory_director    varchar(12),           
publish_date        varchar(12),           
telephone           varchar(50),           
plant_address       varchar(100),          
zipcode             char(6),              
make_date         char(10),               
enterprise_type     char(50),            
set_capacity        varchar(100),        
capital_old         integer,            
capital_used        integer,           
employee_permanent  integer,           
employee_all        integer,           
award               varchar(2000),      
report           varchar(200),           
super_notion1       varchar(500),        
super_notion1_date  varchar(14),            
super_notion2       varchar(500),           
super_notion2_date  varchar(14),            
spcc_notion         varchar(500),           
spcc_notion_date    varchar(14)
);







create table f4_standard_complete_status (
key_id               varchar(13) not null  ,
data_source          integer not null,
primary key          (key_id,data_source),
safe_days            integer, 
eaf                  decimal(4,2),
run_days             integer,    
coal_rate            decimal(5,1),
recycle_water_rate   integer,     
emp_efficiency       decimal(5,1), 
emp_train            integer
);



create table f4_general_data (
key_id              varchar(13) not null,
set_sn              char(2) not null ,
primary key         (key_id,set_sn),
capacity            integer,  
pressure            integer, 
temperature         decimal(4,2), 
coal_rate           decimal(6,2), 
make_factory        varchar(20),   
start_work_date     char(10),      
repair_date_start   char(10),     
repair_date_end     char(10),     
coal_oil            char(2),       
low_coal_rate       integer,       
low_coal_vr         integer,        
high_coal_rate      integer,        
low_heat            integer,       
high_coal_vr        integer,        
high_coal_a         integer,         
fuel_ice_device     char(2),          
water_cooling       char(4),           
year_power_out      integer,        
year_run_hour       integer,         
use_hour            integer,          
equivalent_use_hour integer,           
parent_pipe         char(2),            
oil_adjust          decimal(3,2),        
oil_use_hour        integer,           
oil_eq_hour         integer,            
water_height        integer
);


create table f4_general_data_remark(
key_id              varchar(13) not null primary key,
remark1             varchar(200),
remark2             varchar(200),
remark3             varchar(200),
remark4             varchar(200),
remark5             varchar(200),
remark6             varchar(200),
remark7             varchar(200),
remark8             varchar(200),
remark9             varchar(200),
remark10             varchar(200),
remark11            varchar(200),
remark12           varchar(200),
remark13             varchar(200),
remark14             varchar(200),
remark15             varchar(200),
remark16             varchar(200),
remark17             varchar(200),
remark18             varchar(200),
remark19             varchar(200),
remark20             varchar(200),
remark21             varchar(200),
remark22             varchar(200),
remark23            varchar(200),
remark24             varchar(200),
remark25             varchar(200)
)