subscriptions

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
subscription_id bigserial 19 nextval('subscriptions_subscription_id_seq'::regclass)
institutional_subscriptions.subscription_id institutional_subscriptions_subscription_idC
journal_id int8 19 null
journals.journal_id subscriptions_journal_idC
user_id int8 19 null
users.user_id subscriptions_user_idC
type_id int8 19 null
subscription_types.type_id subscriptions_type_idC
date_start date 13 null
date_end timestamp 22 null
status int2 5 '1'::smallint
membership varchar 40 null
reference_number varchar 40 null
notes text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
subscriptions_pkey 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