零点轰趴馆开发日记:一

选择预定日期和场次
接口:https://moduo.luluhoo.cn/appApi/app/free/querySession?selectedDate=2025-01-15&shopId=5a8c709d531f455f81a065de099f7aa3
返回数据:
{
“data”: [
{
“createBy”: “”,
“createTime”: “2024-03-04 00:25:05”,
“updateBy”: “”,
“updateTime”: “2024-12-13 17:13:26”,
“remark”: null,
“id”: “7”,
“sessionId”: “24c247939eec496a81ed40ad2ec07a34”,
“sessionName”: “白天场”,
“fromTime”: “10:00”,
“toTime”: “17:00”,
“sessionStatus”: “0”,
“shopId”: “5a8c709d531f455f81a065de099f7aa3”,
“price”: 1880,
“delFlag”: “0”,
“loginIp”: “”,
“loginDate”: null,
“createDept”: null,
“updateIp”: null,
“version”: null,
“sessionFlag”: “0”,
“startDate”: null,
“endDate”: null,
“groupId”: 1,
“editFlag”: false,
“selectedDate”: null,
“hasOrdered”: false
},
{
“createBy”: “”,
“createTime”: “2024-03-04 00:25:05”,
“updateBy”: “”,
“updateTime”: “2024-12-13 17:13:26”,
“remark”: null,
“id”: “2”,
“sessionId”: “0e9983875a45473b85c3c6802ce0a7b7”,
“sessionName”: “晚上场”,
“fromTime”: “18:00”,
“toTime”: “08:00”,
“sessionStatus”: “0”,
“shopId”: “5a8c709d531f455f81a065de099f7aa3”,
“price”: 1880,
“delFlag”: “0”,
“loginIp”: “”,
“loginDate”: null,
“createDept”: null,
“updateIp”: null,
“version”: null,
“sessionFlag”: “0”,
“startDate”: null,
“endDate”: null,
“groupId”: 1,
“editFlag”: false,
“selectedDate”: null,
“hasOrdered”: false
}
]
}

sessionName和sessionId都是静态不变的,不同日期有不同的id以及不同的价格,请你好好设计一下数据表,并给出mysql语句