Table base_entity All entities (schemas, collections, advanced searches etc., but not items) extend this table. Stores the common information for entities (e.g. uuid, institution)
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
id | Primary key | Asc | base_entity_pkey |
institution_id + uuid | Must be unique | Asc/Asc | base_entity_institution_id_uuid_key |
description_id | Performance | Asc | baseentitydescription |
name_id | Performance | Asc | baseentityname |
system_type | Performance | Asc | baseentitysystemtypeindex |
disabled | Performance | Asc | disabledindex |
institution_id | Performance | Asc | institutionindex |
uuid | Performance | Asc | uuidindex |
![]() ![]() |