计算参数表.txt

火力发电站创一流达标申报审批系统

create table sys_figure1 (
recn             integer not null primary key,
capacity         varchar(50), 
no_repair        integer,     
y3_repair        integer,      
y4_repair        integer,     
y5_repair        integer,     
shut_times       integer
);



create table sys_figure1_add (
recn             integer not null primary key,
capacity         varchar(50),
no_repair        integer,   
repair           integer,    
shut_times       integer
);


create table sys_figure2 (
recn                      integer not null primary key,
adjust_factor             varchar(100),
value_p                   decimal(3,2), 
value_j                   decimal(3,2)
);


create table sys_figure3 (
recn                  integer not null primary key,
parameter             varchar(12),
capacity              varchar(12),  
make_country          varchar(12),   
ok                    integer,      
best                  integer
);


create table sys_figure4 (
recn                   integer not null primary key,
adjust_factor          varchar(100), 
adjust_value           varchar(200)
remark                 varchar(200)
);


create table sys_figure5 (                //参数表5
recn               integer not null primary key,
press              varchar(50), 
value1             decimal(4,3), 
value2             decimal(4,3)
);


create table sys_figure6 (                 //参数表6
recn                integer not null primary key,
parameter           varchar(10),
capacity            varchar(6),
value_base          integer
);