after creating the custom data types and datastores, we want to use foreign key

after creating the custom data types and datastores, we want to use foreign key in mysql to relate multiple mysql tables to each other so that the main table can display values from some other tables.
so that when we use a simple query rule in appian and could get dynamic data for example, a query rule querying user info main table would return the user status, vacation days used, current project status, etc from different tables...
before starting I wish to know about howto achieve this, the best practices and also if there are any limitations and howto's in the documentation... thanks ...

OriginalPostID-122753

OriginalPostID-122753