institutions


Description

Institutions for statistics and subscriptions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
institution_id BIGINT 19 √ null
institution_ip.institution_id institution_ip_institution_id_foreignC
institution_settings.institution_id institution_settings_institution_id_foreignC
institutional_subscriptions.institution_id institutional_subscriptions_institution_id_foreignC
metrics_counter_submission_institution_daily.institution_id msid_institution_id_foreignC
metrics_counter_submission_institution_monthly.institution_id msim_institution_id_foreignC
usage_stats_institution_temporary_records.institution_id usi_institution_id_foreignC
context_id BIGINT 19 null
journals.journal_id institutions_context_id_foreignC
ror VARCHAR 255 √ NULL

ROR (Research Organization Registry) ID
deleted_at TIMESTAMP 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc institution_id
institutions_context_id Performance Asc context_id

Relationships

Close relationships within degrees of separation