Database schema

1 Database schema

Gentics Portal.Node stores in the database different types of entities:

  • users
  • profiles
  • accounts
  • comments
  • likes
  • friendship
  • personalisation attributes

Each of this entities is represented by one or set of tables.

Tables are using indices for attributes which extensively used for search.

This database schema was tested under high load and proof its viability.

Below you can see names and data types of table attributes.

  • Primary keys are marked with “key”.
  • NOT NULL attributes marked with filled rectangle
  • below each table shows keys which are used inside table