Database Changes After Adding Liferay Account Address
Created: 11 December 2024 Modified:What data changes occur when an account address is added to Liferay. The account address 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.
Many tables have columns classNameId and classPK. These act as a psuedo foreign key to the ClassName_ table. The ClassName_ table basically references Java classes. These Java classes have associated database tables. ClassPK contains an identifier that references a row in the table. This seems to be used to add levels of abstraction for second order relationships.
Tables that were changed after adding the new account address Rock Seller Address.
- Address
- Table to store address data.
- Primary key is addressId and ctCollectionId.
- AddressId had value 32906.
- ClassNameId had value 28707 which points to com.liferay.account.model.AccountEntry.
- ClassPK had value 32503 which points to the Rock Seller account.
- Phone
- Table to store phone data.
- Primary key is phoneId and ctCollectionId.
- PhoneId had value 32907.
- ClassNameId had value 20020 which points to com.liferay.portal.kernel.model.Address.
- ClassPK had value 32906 which points to the Rock Seller Address.
Diagram is only showing the relationships most relevant.
Resources
tags: java - liferay ce - liferay - ce - mariadb - fedora - 41 - fedora 41 - linux - account - address