When creating entities, can we build a wizard style experience for the developers to choose from?
The options and underlying logic for this wizard would be similar to Slow Changing Dimension Types i.e.
#1 SCD Type 0 — Dimension is never updated
#2 SCD Type 1 — Dimension is overwritten
#3 SCD Type 2 — Maintain all the old records for the dimension by versioning the row
#4 SCD Type 3 — Maintain an old attribute but in the same row (by adding a previous value column)
#5 SCD Type 4 — Maintain current record and older record in two different tables
This would greatly help database modeling, data versioning strategy and have a standardized approach for the application being developed.