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)

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int8 19
base_entity_attributes.base_entity_id fk93ad1d452f4908cf R
catalogue.id fk56c7cc69aa97c6e1 R
connector.id fkdd79f44daa97c6e1 R
course_info.id fkfb081652aa97c6e1 R
custom_link.id fk96095c08aa97c6e1 R
dyna_collection.id fk1b3a4635aa97c6e1 R
echo_server.id fke882fe9daa97c6e1 R
entity_lock.entity_id fk4c6190077e7398bd R
external_tool.id fkffc5658caa97c6e1 R
federated_search.id fkaf6dfc43aa97c6e1 R
harvester_profile.id fk44e89c40aa97c6e1 R
html_editor_plugin.id fkfe0ad8b1aa97c6e1 R
item_definition.id fk983a75ffaa97c6e1 R
kaltura_server.id fkf1b9ce5caa97c6e1 R
lti_consumer.id fkcc3fde94aa97c6e1 R
oauth_client.id fk193e9a73aa97c6e1 R
payment_gateway.id fk4daeb90baa97c6e1 R
portlet.id fke8a0adfaaa97c6e1 R
power_search.id fka7b59a22aa97c6e1 R
pricing_tier.id fk3fa356bbaa97c6e1 R
region.id fkc84826f4aa97c6e1 R
report.id fkc84c5534aa97c6e1 R
store.id fk68af8e1aa97c6e1 R
store_front.id fka6ba4d4baa97c6e1 R
tax_type.id fkef7b9b4eaa97c6e1 R
taxonomy.id fkf05a3351aa97c6e1 R
tleschemas.id fkac424965aa97c6e1 R
user_script.id fkf61f17bfaa97c6e1 R
workflow.id fk21bd7bfaa97c6e1 R
date_created timestamp 29,6
date_modified timestamp 29,6
disabled bool 1
owner varchar 255  √  null
system_type bool 1
uuid varchar 40
description_id int8 19  √  null
language_bundle.id fk7a02bd11888c44ea R
institution_id int8 19
institution.id fk7a02bd11bc711081 R
name_id int8 19  √  null
language_bundle.id fk7a02bd11d4838ffb R
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

Close relationships  within of separation: