API-body中的columns参数结构
本接口一共对应5张数据库表，请您传数据时找到对应表进行参数构建
第一张表 光伏电厂每日信息记录表
1. tableName（表名）：plant_photovoltaic_record(光伏电厂每日信息记录表)
2. 请求体（Body）结构说明
{
"tableName": "plant_photovoltaic_record",
"columns": [
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "substation_name",
"dataType": "string"
},
{
"columnName": "substation_code",
"dataType": "string"
},
{
"columnName": "record_date",
"dataType": "timestamp"
},
{
"columnName": "generate_quantity",
"dataType": "string"
},
{
"columnName": "supply_quantity",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "发电量", "供电量","2025-08-19 11:35:26"
]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| measure_point | string | 是 | 测点名 | |
| id | string | 是 | id | |
| substation_name | string | 是 | 厂站名称 | "绿能134团永安光伏站" |
| substation_code | string | 是 | 厂站编码(用名称的首字母简写) | "lnyagfz" |
| record_date | timestamp | 是 | 记录日期(yyyy-MM-dd) | "2025-08-19" |
| generate_quantity | string | 否 | 发电量 | |
| supply_quantity | string | 否 | 供电量 | |
| create_date | timestamp | 否 | 数据推送时间 | "2025-08-29 11:12:20" |
4. 数据推送频率
一天更新一次（1次/天）
第二张表 储能电厂每日信息记录表
1. tableName（表名）：plant_storage_record(储能电厂每日信息记录表)
2. 请求体（Body）结构说明
{
"tableName": "plant_storage_record",
"tableDisplayName": "储能电厂每日信息记录表",
"columns": [
{
"columnName": "measure_point",
"columnDisplayName": "测点名",
"dataType": "string",
"isKey": true
},
{
"columnName": "id",
"columnDisplayName": "id",
"dataType": "string" ,
"isKey": true
},
{
"columnName": "substation_name",
"columnDisplayName": "厂站名称",
"dataType": "string",
"isKey": true
},
{
"columnName": "substation_code",
"columnDisplayName": "厂站编码",
"dataType": "string",
"isKey": true
},
{
"columnName": "record_date",
"columnDisplayName": "记录日期",
"dataType": "timestamp",
"isKey": true
},
{
"columnName": "photovoltaic_supply_quantity",
"columnDisplayName": "光伏储能供电量",
"dataType": "string"
},
{
"columnName": "water_supply_quantity",
"columnDisplayName": "抽水蓄能供电量",
"dataType": "string"
},
{
"columnName": "photovoltaic_release_quantity",
"columnDisplayName": "光伏储能放电量",
"dataType": "string"
},
{
"columnName": "water_release_quantity",
"columnDisplayName": "抽水蓄能放电量",
"dataType": "string"
},
{
"columnName": "photovoltaic_sufficient_quantity",
"columnDisplayName": "光伏储能充电量",
"dataType": "string"
},
{
"columnName": "water_sufficient_quantity",
"columnDisplayName": "抽水蓄能充电量",
"dataType": "string"
},
{
"columnName": "photovoltaic_max_load",
"columnDisplayName": "光伏储能最大负荷",
"dataType": "string"
},
{
"columnName": "water_max_load",
"columnDisplayName": "抽水蓄能最大负荷",
"dataType": "string"
},
{
"columnName": "photovoltaic_min_load",
"columnDisplayName": "光伏储能最小负荷",
"dataType": "string"
},
{
"columnName": "water_min_load",
"columnDisplayName": "抽水蓄能最小负荷",
"dataType": "string"
},
{
"columnName": "create_date",
"columnDisplayName": "数据推送时间",
"dataType": "timestamp"
}
],
"creator": "",
"projectId": 0
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| measure_point | string | 是 | 测点名 | |
| id | string | 是 | id | |
| substation_name | string | 是 | 厂站名称 | "绿能134团永安光伏站" |
| substation_code | string | 是 | 厂站编码(用名称的首字母简写) | "lnyagfz" |
| record_date | timestamp | 是 | 记录日期(yyyy-MM-dd) | "2025-08-19" |
| photovoltaic_supply_quantity | string | 否 | 光伏储能供电量 | |
| water_supply_quantity | string | 否 | 抽水蓄能供电量 | |
| photovoltaic_release_quantity | string | 否 | 光伏储能放电量 | |
| water_release_quantity | string | 否 | 抽水蓄能放电量 | |
| photovoltaic_sufficient_quantity | string | 否 | 光伏储能充电量 | |
| water_sufficient_quantity | string | 否 | 抽水蓄能充电量 | |
| photovoltaic_max_load | string | 否 | 光伏储能最大负荷 | |
| water_max_load | string | 否 | 抽水蓄能最大负荷 | |
| photovoltaic_min_load | string | 否 | 光伏储能最小负荷 | |
| water_min_load | string | 否 | 抽水蓄能最小负荷 | |
| supply_quantity | string | 否 | 供电量 | |
| create_date | timestamp | 否 | 数据推送时间 | "2025-08-29 11:12:20" |
4. 数据推送频率
一天更新一次（1次/天）
第三张表 电厂环境记录表
1. tableName（表名）：plant_circumstances_record(电厂环境记录表)
2. 请求体（Body）结构说明
{
"tableName": "plant_storage_record",
"columns": [
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "substation_name",
"dataType": "string"
},
{
"columnName": "substation_code",
"dataType": "string"
},
{
"columnName": "record_date",
"dataType": "timestamp"
},
{
"columnName": "photovoltaic_supply_quantity",
"dataType": "string"
},
{
"columnName": "water_supply_quantity",
"dataType": "string"
},
{
"columnName": "photovoltaic_release_quantity",
"dataType": "string"
},
{
"columnName": "water_release_quantity",
"dataType": "string"
},
{
"columnName": "photovoltaic_sufficient_quantity",
"dataType": "string"
},
{
"columnName": "water_sufficient_quantity",
"dataType": "string"
},
{
"columnName": "photovoltaic_max_load",
"dataType": "string"
},
{
"columnName": "water_max_load",
"dataType": "string"
},
{
"columnName": "photovoltaic_min_load",
"dataType": "string"
},
{
"columnName": "water_min_load",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19", "光伏储能供电量", "抽水蓄能供电量",
"光伏储能放电量","抽水蓄能放电量","光伏储能充电量","抽水蓄能充电量","光伏储能最大负荷","光伏储能最大负荷","光伏储能最小负荷","抽水蓄能最小负荷",
"2025-08-19 11:35:26"
]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| measure_point | string | 是 | 测点名 | |
| id | string | 是 | id | |
| substation_name | string | 是 | 厂站名称 | "绿能134团永安光伏站" |
| substation_code | string | 是 | 厂站编码(用名称的首字母简写) | "lnyagfz" |
| record_date | timestamp | 是 | 记录日期(yyyy-MM-dd) | "2025-08-19" |
| sunlight_hour | string | 否 | 日照时数 | |
| avg_temperature | string | 否 | 空气温度 | |
| avg_humidity | string | 否 | 相对湿度 | |
| avg_speed | string | 否 | 空气风速 | |
| create_date | timestamp | 否 | 数据推送时间 | "2025-08-29 11:12:20" |
4. 数据推送频率
一天更新一次（1次/天）
第四张表 光伏电厂实时数据记录表
1. tableName（表名）：plant_photovoltaic_real_record(光伏电厂实时数据记录表)
2. 请求体（Body）结构说明
{
"tableName": "plant_photovoltaic_real_record",
"columns": [
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "substation_name",
"dataType": "string"
},
{
"columnName": "substation_code",
"dataType": "string"
},
{
"columnName": "record_date",
"dataType": "timestamp"
},
{
"columnName": "real_load",
"dataType": "string"
},
{
"columnName": "year_supply_quantity",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19 12:23:54",
"实时负荷","今年实际发电量","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19 12:54:54",
"实时负荷","今年实际发电量","2025-08-19 11:35:26"
]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| measure_point | string | 是 | 测点名 | |
| id | string | 是 | id | |
| substation_name | string | 是 | 厂站名称 | "绿能134团永安光伏站" |
| substation_code | string | 是 | 厂站编码(用名称的首字母简写) | "lnyagfz" |
| record_date | timestamp | 是 | 记录时间(yyyy-MM-dd hh:mm:ss) | "2025-08-19 11:12:20" |
| real_load | string | 否 | 实时负荷 | |
| year_supply_quantity | string | 否 | 今年实际发电量 | |
| create_date | timestamp | 否 | 数据推送时间(yyyy-MM-dd hh:mm:ss) | "2025-08-29 11:12:20" |
4. 数据推送频率
十分钟更新一次（1次/十分钟）
第五张表 储能电厂实时数据记录表
1. tableName（表名）：plant_storage_real_record(储能电厂实时数据记录表)
2. 请求体（Body）结构说明
{
"tableName": "plant_storage_real_record",
"columns": [
{
"columnName": "measure_point",
"dataType": "string"
},
{
"columnName": "id",
"dataType": "string"
},
{
"columnName": "substation_name",
"dataType": "string"
},
{
"columnName": "substation_code",
"dataType": "string"
},
{
"columnName": "record_date",
"dataType": "timestamp"
},
{
"columnName": "real_load",
"dataType": "string"
},
{
"columnName": "sum_supply_quantity",
"dataType": "string"
},
{
"columnName": "old_sum_supply_quantity",
"dataType": "string"
},
{
"columnName": "storage_efficiency",
"dataType": "string"
},
{
"columnName": "create_date",
"dataType": "timestamp"
}
],
"rows": [
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19 12:23:54",
"实时负荷","今年累计供电量","去年累计供电量","储能效率","2025-08-19 11:35:26"
],
[ "测点名", "0881id", "绿能134团永安光伏站", "lnyagfz", "2025-08-19 12:37:54",
"实时负荷","今年实际发电量","去年累计供电量","储能效率","2025-08-19 11:35:26"
]
]
}3. columns 字段详情
| 字段名 | 数据类型 | 是否必填 | 说明 | 示例值 |
|---|---|---|---|---|
| measure_point | string | 是 | 测点名 | |
| id | string | 是 | id | |
| substation_name | string | 是 | 厂站名称 | "绿能134团永安光伏站" |
| substation_code | string | 是 | 厂站编码(用名称的首字母简写) | "lnyagfz" |
| record_date | timestamp | 是 | 记录时间(yyyy-MM-dd hh:mm:ss) | "2025-08-19 11:12:20" |
| real_load | string | 否 | 实时负荷 | |
| sum_supply_quantity | string | 否 | 今年累计供电量 | |
| old_sum_supply_quantity | string | 否 | 去年累计供电量 | |
| storage_efficiency | string | 否 | 储能效率 | |
| create_date | timestamp | 否 | 数据推送时间(yyyy-MM-dd hh:mm:ss) | "2025-08-29 11:12:20" |
4. 数据推送频率
十分钟更新一次（1次/十分钟）
微信扫描二维码修改于 2025-08-20 09:35:49