dft street manager spike 0004 data model

Data model and standards

Alpha model

draw.io diagram

This is a high level proposed data model, subject to change as our knowledge improves.

Versioning

TODO

Auditing

TODO

Optimistic concurrency control

TODO

Archiving

TODO

Database change control

TODO

Permissions and restrictions

TODO

Standards

TODO - Database standards and approach will be based on implementation choice, we should declare we will follow best practises and conventions upfront, as well as standard approach for common structures like reference data tables.