Table institution
Institutions for this install

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
access_entry.institution_id fk8b9a85d7bc711081 R
audit_log_entry.institution_id fk40704c53bc711081 R
audit_log_lms.institution_id fkf406b33bc711081 R
base_entity.institution_id fk7a02bd11bc711081 R
bookmark.institution_id fk7787a536bc711081 R
cached_value.institution_id fk671d5414bc711081 R
entity_lock.institution_id fk4c619007bc711081 R
favourite_search.institution_id fkdb761febc711081 R
hierarchy_topic.institution_id fk12ba86a5bc711081 R
hierarchy_topic_dynamic_key_re.institution_id fk46014edbc711081 R
item.institution_id fk317b13bc711081 R
item_lock.institution_id fk805cf6d7bc711081 R
language.institution_id fk9fd29358bc711081 R
mime_entry.institution_id fk94eb98a7bc711081 R
notification.institution_id fk237a88ebbc711081 R
oauth_token.institution_id fk1a879e51bc711081 R
order.institution_id fk651874ebc711081 R
pss_callback_log.institution_id fk85481159bc711081 R
purchase.institution_id fk67e90501bc711081 R
purchased_content.institution_id fk81b843bdbc711081 R
qti_assessment_item.institution_id fk98d3e6d7bc711081 R
qti_assessment_test.institution_id fk98d8b056bc711081 R
sale.institution_id fk35c047bc711081 R
share_pass.institution_id fk956be071bc711081 R
subscription_period.institution_id fkf2590f23bc711081 R
thumbnail_request.institution_id fkf33e3cbc711081 R
tlegroup.institution_id fk1563c1b2bc711081 R
tleuser.institution_id fkb6646e38bc711081 R
admin_password varchar 255
enabled bool 1
short_name varchar 20
name varchar 100
quota float8 17,17  √  null
time_zone varchar 20  √  null
unique_id int8 19
url varchar 100  √  null
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc institution_pkey
short_name Must be unique Asc institution_short_name_key
url Must be unique Asc institution_url_key

Close relationships  within of separation: