Database Changes After Adding Liferay Account Organization
Created: 9 December 2024 Modified:What data changes occur when an account organization is added to Liferay. Accounts do not have the ability
to add new organizations. It can only associate existing organizations. In this example the Bedstone organization
is associated with the existing account Rock Seller. This association was added by administrator user Test Test
with email test@test.com. Keep in mind that Liferay doesn’t enforce referential integrity in the database.
Instead it is “enforced” in the code.
Tables that were changed after associating the Bedstone organization with Rock Seller account.
- AccountEntryOrganizationRel
- Table to store account group data.
- Primary key is accountEntryOrganizationRelId which is 32803.
- AccountEntryId is 32503 which points to Rock Seller Account.
- OrganizationId is 32306 which points to Bedstone organization.
- PortalPreferenceValue
- Table to store data defining portal preference values.
- These additional rows were added for Test Test admin user.
Diagram is only showing the relationships most relevant.
Resources
tags: java - liferay ce - liferay - ce - mariadb - fedora - 41 - fedora 41 - linux - account - organization