首页 新闻 会员 周边 捐助

请问下根据如下json怎么设计数据库表

0
悬赏园豆:20 [已关闭问题] 关闭于 2014-09-18 19:19

第一个Json:

{
    "ActionInfo": {
        "Success": true,
        "ExceptionMsg": null,
        "ActionName": null,
        "ActionUser": null,
        "ActionTime": "/Date(-62135596800000+0800)/"
    },
    "Total": 405,
    "TotalCompare": "-4.39%",
    "TotalLastMon": 423.58,
    "IsOnlyElec": false,
    "ItemValues": [
        {
            "ItemCode": "01000",
            "CName": "",
            "Unit": " kWh",
            "EneryValue": 2916256,
            "MonthCompare": "-5.37%",
            "EnergyLastMonth": 3081896,
            "EnergyValue2Coal": 376.2
        },
        {
            "ItemCode": "02000",
            "CName": "",
            "Unit": " t",
            "EneryValue": 139175,
            "MonthCompare": "24.46%",
            "EnergyLastMonth": 111826,
            "EnergyValue2Coal": 11.93
        },
        {
            "ItemCode": "03000",
            "CName": "",
            "Unit": " m3",
            "EneryValue": 13901,
            "MonthCompare": "2.70%",
            "EnergyLastMonth": 13536,
            "EnergyValue2Coal": 16.88
        },
        {
            "ItemCode": "04000",
            "CName": "",
            "Unit": " m3",
            "EneryValue": 0,
            "MonthCompare": null,
            "EnergyLastMonth": 0,
            "EnergyValue2Coal": 0
        }
    ],
    "PeriodValues": [
        {
            "PeriodType": 1,
            "MonthCompare": "-26.43%",
            "Value1": 99416,
            "Value2": 73144
        },
        {
            "PeriodType": 2,
            "MonthCompare": "-49.15%",
            "Value1": 695912,
            "Value2": 353901
        },
        {
            "PeriodType": 3,
            "MonthCompare": "6.67%",
            "Value1": 961546,
            "Value2": 1025712
        },
        {
            "PeriodType": 4,
            "MonthCompare": "-0.63%",
            "Value1": 17323950,
            "Value2": 17215610
        }
    ]
}

第二个json:

{
    "ActionInfo": {
        "Success": true,
        "ExceptionMsg": null,
        "ActionName": null,
        "ActionUser": null,
        "ActionTime": "/Date(-62135596800000+0800)/"
    },
    "series": [
        {
            "name": null,
            "data": [
                756,
                938,
                774,
                744,
                785,
                947,
                844,
                828,
                897,
                2451,
                2554,
                3035,
                2535,
                4026,
                2587,
                3099,
                2568,
                2537
            ]
        }
    ],
    "Unit": "kwh"
}

第三个json:

{
    "ActionInfo": {
        "Success": true,
        "ExceptionMsg": "",
        "ActionName": "",
        "ActionUser": null,
        "ActionTime": "/Date(1411035879341+0800)/"
    },
    "AllAlarm": {
        "Value": 0,
        "YesterdayValue": 2,
        "CompareValue": "-100"
    },
    "UndoAlarm": {
        "Value": 0,
        "YesterdayValue": 2,
        "CompareValue": "-100"
    },
    "ProcessedAlarm": {
        "Value": 0,
        "YesterdayValue": 0,
        "CompareValue": "-"
    }
}
加加貝的主页 加加貝 | 菜鸟二级 | 园豆:274
提问于:2014-09-18 18:48
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册