1- No to a single look-up table:
a - Scalability.
b - Data Maintainability (Error prone)
2- Integrity on deletion:
a - Deletion stored procedure with the logic to restrict deletion for consumed records.
(The reason that foreign keys are not enough since typically they reside within a single DB; however, references are usually consumed from other DBs.) [My recommendation]
b- Don't delete: Just mark as deleted or add a status per record to be defined by the business.
a - Scalability.
b - Data Maintainability (Error prone)
2- Integrity on deletion:
a - Deletion stored procedure with the logic to restrict deletion for consumed records.
(The reason that foreign keys are not enough since typically they reside within a single DB; however, references are usually consumed from other DBs.) [My recommendation]
b- Don't delete: Just mark as deleted or add a status per record to be defined by the business.
No comments:
Post a Comment