Database Changes After Adding Liferay Account Contact Information
Created: 13 December 2024 Modified:What data changes occur when an account contact information is added to Liferay. Contact information which includes Email, Phone, Website and various Social Media accounts. This information 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 contact information for account Rock Seller. Primary key 32503.
- Contact_
- Table to store contact data.
- Row added for account Rock Seller.
- ContactId was 32919.
- Foreign key userId has value 20123. This references the Adminstrator account that added the data.
- ClassNameId was 28707 which points to com.liferay.account.model.AccountEntry in the ClassName_ table.
- ClassPk was 32503 which points to the Rock Seller account.
- EmailAddress
- Table to store email address data.
- Primary key is addressId and ctCollectionId.
- EmailAddressId had value 32917.
- ClassNameId was 28707 which points to com.liferay.account.model.AccountEntry in the ClassName_ table.
- ClassPk was 32503 which points to the Rock Seller account.
- Phone
- Table to store phone data.
- Primary key is phoneId and ctCollectionId.
- PhoneId had value 32916.
- ClassNameId was 28707 which points to com.liferay.account.model.AccountEntry in the ClassName_ table.
- ClassPk was 32503 which points to the Rock Seller account.
- Website
- Table to store website data.
- Primary key is websiteId.
- WebsiteId had value 32918.
- ClassNameId was 28707 which points to com.liferay.account.model.AccountEntry in the ClassName_ table.
- ClassPk was 32503 which points to the Rock Seller account.
Diagram is only showing the relationships most relevant.
Resources
tags: java - liferay ce - liferay - ce - mariadb - fedora - 41 - fedora 41 - linux - account - contact information - contact - information