电厂排班数据库设计

t_ele_schedule_setting_detail排班日历班次

idnamestart_timeend_timeorder_numschedule_setting_id

t_ele_material_consumer_data

idcost_speed_avg(double) 给煤速率(吨/小时)has_consume(double) 累计给煤(吨)consume_avg(double)  给煤量(吨)material_consumer_id

t_ele_main_group

idname

1 : nid = main_group_id

年代久远忘记什么意思了

t_ele_schedule_table_loop排班表循环数据

idouter_orderorder_numrole_idtable_detail_idsetting_id

t_ele_schedule_order排班日历每日数据

iddaterole_idschedule_setting_detail_id

n : 1

1:nid = material_consumer_id

1 : nid = role_id

t_ele_schedule_setting排班设置

idnamedivide_numstart_timeloop_day

t_ele_group_data_stat

idload(double) 平均负荷(万kw)consume(double) 原煤耗(g/Kwh)cost(double)燃料成本(元/Kwh)begin_time(datetime)end_time(datetime)type(varchar)main_group_id

1 : nid = origin_material_id

t_ele_schedule_role值别

idnameorder_numoffice_idsetting_id

1 : n

1 : nid = schedule_setting_id

sys_office

id

1 : n id = material_consumer_id

1 : n id = role_id

t_ele_fetch_consumer

idmaterial_consumer_id

t_ele_material_inuse

idweightorigin_material_idmaterial_consumer_id

1 : nid = schedule_setting_detail_id

1 ： loopDay*roleNum

t_ele_schedule_table_detail排班表班次

1 ： n

t_ele_material_consumer

idnamemain_group_id

t_ele_group_data

idload_avg(double) 实时负荷(万kw)accumulate_power(double) 关口表累积发电量(Kwh)group_power_avg(double) 机组发电量(Kwh)consume_speed(double) 机组给煤速率(吨/小时)main_group_id

t_ele_fetch_history

idfetch_time(datetime) 取煤时间position_long(double) 实际取煤位置长position_wide(double) 实际取煤位置宽position_height(double) 实际取煤位置高fetch_all(char) 是否取完origin_material_id

t_ele_origin_material

idnumber(varchar) 批次号boat_name(varchar) 来煤船信息mine_site(varchar) 矿点信息mine_kind(varchar) 煤种信息arrive_time(datetime) 卸煤时间cal(double) 大卡ash_percent(double) 灰分%water_percent(double) 水分%volatilize_percent(double) 挥发分%sulfur_percent(double) 硫分%density(double) 密度kg/m3arrive_price(double) 到厂煤价position_long(double) 堆煤位置长position_wide(double) 堆煤位置宽position_height(double) 堆煤位置高weight(double) 重量color(varchar) 煤种颜色