Rail Data: 09-Floor3-1

{
  "uuid": "03c0xxxxx927405abfexxxxxbb881bf",
  "buildId": "200036",
  "floorNo": "Floor3",
  "railName": "09-Floor3-1",
  "railType": 1,
  "concernType": "all",
  "createTime": "2020-07-17T09:23:30.000+0000",
  "createBy": "2",
  "updateTime": "2020-07-17T09:23:30.000+0000",
  "updateBy": "2",
  "userRailType": null,
  "remark": "09-Floor3-1",
  "stopTimeLimitSeconds": 0,
  "points": [],
  "mapType": 1,
  "color": null,
  "pushEventFlag": true
}

This JSON object represents a data structure for a rail entity with attributes like UUID, build ID, floor number, rail name, rail type, concern type, creation and update timestamps, user rail type, remark, stop time limit, map type, color, and push event flag. It can be used for database storage and retrieval.

The following SQL table structure can be used to store this data:

CREATE TABLE `rail` (
  `uuid` varchar(32) NOT NULL,
  `buildId` varchar(10) DEFAULT NULL,
  `floorNo` varchar(10) DEFAULT NULL,
  `railName` varchar(20) DEFAULT NULL,
  `railType` int(11) DEFAULT NULL,
  `concernType` varchar(10) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `createBy` varchar(10) DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `updateBy` varchar(10) DEFAULT NULL,
  `userRailType` varchar(10) DEFAULT NULL,
  `remark` varchar(20) DEFAULT NULL,
  `stopTimeLimitSeconds` int(11) DEFAULT NULL,
  `mapType` int(11) DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  `pushEventFlag` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;