subscription_types


Description

Subscription types represent the kinds of subscriptions that a user or institution may have, such as an annual subscription or a discounted subscription.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
type_id BIGINT 19 √ null
subscription_type_settings.type_id subscription_type_settings_type_idC
subscriptions.type_id subscriptions_type_idC
journal_id BIGINT 19 null
journals.journal_id subscription_types_journal_idC
cost DOUBLE 8,2 null
currency_code_alpha VARCHAR 3 null
duration SMALLINT 5 √ NULL
format SMALLINT 5 null
institutional SMALLINT 5 0
membership SMALLINT 5 0
disable_public_display SMALLINT 5 null
seq DOUBLE 8,2 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc type_id
subscription_types_journal_id Performance Asc journal_id

Relationships

Close relationships within degrees of separation