institutional_subscriptions


Description

A list of institutional subscriptions, linking a subscription with an institution.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
institutional_subscription_id BIGINT 19 √ null
subscription_id BIGINT 19 null
subscriptions.subscription_id institutional_subscriptions_subscription_idC
institution_id BIGINT 19 null
institutions.institution_id institutional_subscriptions_institution_id_foreignC
mailing_address VARCHAR 255 √ NULL
domain VARCHAR 255 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc institutional_subscription_id
institutional_subscriptions_domain Performance Asc domain
institutional_subscriptions_institution_id Performance Asc institution_id
institutional_subscriptions_subscription_id Performance Asc subscription_id

Relationships

Close relationships within degrees of separation