subscription_types

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
type_id bigserial 19 nextval('subscription_types_type_id_seq'::regclass)
subscription_type_settings.type_id subscription_type_settings_type_idC
subscriptions.type_id subscriptions_type_idC
journal_id int8 19 null
journals.journal_id subscription_types_journal_idC
cost float8 17,17 null
currency_code_alpha varchar 3 null
duration int2 5 null
format int2 5 null
institutional int2 5 '0'::smallint
membership int2 5 '0'::smallint
disable_public_display int2 5 null
seq float8 17,17 null

Indexes

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

Relationships