Data modelling - Githubissues

cbarkr / transmiss

🚌 For when transit misses the mark

https://transmiss.ca

2 stars 0 forks source link

Data modelling #7

Closed cbarkr closed 11 months ago

cbarkr commented 11 months ago

Design (non-relational) models to be used for reporting stop and bus information. These models will be used in DynamoDB (NoSQL) and must use appropriate partition and (optionally) sort keys.

Helpful Links:

Stops

Used to report how many transit users are at a given stop.

Attributes:

Report ID
Stop ID
Number of transit users at stop
Report datetime

Buses

Used to report when a bus is beyond capacity and/or skips a stop.

Attributes:

Report ID
Stop ID
Report datetime
(Optional) Bus ID (the vehicle ID on the bus itself)
(Optional) Route ID
(Optional) Number of transit users at stop

cbarkr commented 11 months ago

Partition Key

Report ID?

Sort Key

Report Datetime?