subscriptions

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
subscription_id BIGINT 19 √ null
institutional_subscription_ip.subscription_id Implied Constraint R
institutional_subscriptions.subscription_id Implied Constraint R
journal_id BIGINT 19 null
journals.journal_id Implied Constraint R
user_id BIGINT 19 null
users.user_id Implied Constraint R
type_id BIGINT 19 null
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

Relationships

Close relationships within degrees of separation