Add Logical FK's #1754
DcPublished
started this conversation in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
For certain types of environments, physical FK's are neither normal nor recommended. In my experience, physical FK's are not used for most tables in a data warehouse. This can improve performance and allow flexibility to handle this FK relationship in the ETL code.
That said, Logical FK's are useful for documenting those relationships in a data model to help reviewers understand those relationships. They also provide a place to document how the code will (or will not) handle the FK relationship.
Am I missing something? Is it feasible to add a Logical FK in the current version of pgModeler? If not, please add this capacity.
Thanks,
Dan.
Beta Was this translation helpful? Give feedback.
All reactions