subscriptions


Description

A list of subscriptions, both institutional and individual, for journals that use subscription-based publishing.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
subscription_id BIGINT 19 √ null
institutional_subscriptions.subscription_id institutional_subscriptions_subscription_idC
journal_id BIGINT 19 null
journals.journal_id subscriptions_journal_idC
user_id BIGINT 19 null
users.user_id subscriptions_user_idC
type_id BIGINT 19 null
subscription_types.type_id subscriptions_type_idC
date_start DATE 10 √ NULL
date_end DATETIME 19 √ NULL
status SMALLINT 5 1
membership VARCHAR 40 √ NULL
reference_number VARCHAR 40 √ NULL
notes TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc subscription_id
subscriptions_journal_id Performance Asc journal_id
subscriptions_type_id Performance Asc type_id
subscriptions_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation