Add Logical FK's

[DcPublished]

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.