DB Wiki - COS301-SE-2023/Event-Participation-Trends GitHub Wiki

Below is a EER representation of the MongoDB used during this project

Below is a Representation of this DB as collections and documents

"event":{
	"EventId": 1,
	"StartTime": "08:00:00",
	"EndTime": "15:00:00",
	"Name": "Project Day",
	"Date": "2023-05-06",
	"FloorLayout":{
			"LayoutId": 1,
			"Scale": 1.5,
	}
	"Stalls":["0": {
			"Stall_Name": "Indlovu"
			"Coordinates": [
					"x1": 10,
					"y1": 20,
					...
			]
	          } ...]
	"Sensor":["0":{
			"SensorId": 1,
			"x-coordiante": 10,
			"y-coordiante": 20,
		} ...]
	"Device":[
		"DeviceId":1
		"Location":[
			"y-coordinate":16,
			"x-coordinate":12,
			"TimeStamp": "08:15:00",
			...]
		]
	"TEMP_DEVICE_TO_DT":[
		"0":{
                        "BTID":"00:11:22:33:FF:EE",
		        "DeviceId": 1
		},
		...]
	"TEMP_DEVICE_BUFFER":[
		"0":{
			"BTID":"00:11:22:33:FF:EE",
			"SensorId":1
			"TimeStamp": "08:15:00",
			"SignalStrenght": 0.9
			}
		]
}

"User":["0":{
		"UserId":"1234567890123",
		"Type":"AUDIENCE",
		"Views":"1"   //EventId
	},"1":{
		"UserId":"1234567890124",
		"Type":"ADMINE",
		"Manages":[ 
			        1,    //EventId
				2,    //EventId
			...]
		}
	...]

"FloorLayout":[
	"0":{
		"LayoutId": 1
		//other attributes to be added
	}
]