Forum Stats

  • 3,837,096 Users
  • 2,262,225 Discussions


Suggestion on design of History table

User_3ZQRH Member Posts: 70 Red Ribbon
edited May 28, 2021 9:44AM in OLAP


I am building a live table ( and its' corresponding history table which will hold any changes made to the live table)

As such the history table is not used by the application (except is rare scenario) for audit purpose/tracing back a data quality issue.

There is unique constraint (business validation) built on the Live table. Do I need to replicate the same constraint on the history table as well ? Is that the practice ? or I should not be creating any constraint on history table because it will only be populated via Live table ( and there is already an constraint implemented on the live table)

Note : I have asked in question in SQL forum as well so this might be a duplicate