Table openpetra_trunk.public.p_subscription
Details of which partners receive which publications.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
p_publication_code_c varchar 20
p_publication.p_publication_code_c p_subscription_fk1 R
The is the key to the publication table
p_partner_key_n numeric 10 0
p_partner.p_partner_key_n p_subscription_fk2 R
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number.
p_publication_copies_i int4 10  √  1
p_reason_subs_given_code_c varchar 24
p_reason_subs_cancelled_code_c varchar 24  √  null
p_reason_subscription_cancelled.p_code_c p_subscription_fk5 R
p_expiry_date_d date 13  √  null Date the subscription expires
p_provisional_expiry_date_d date 13  √  null Provisional date on which the subscription may expire
p_gratis_subscription_l bool 1 true
p_date_notice_sent_d date 13  √  null
p_date_cancelled_d date 13  √  null
p_start_date_d date 13 ('now'::text)::date
p_number_issues_received_i int4 10 0
p_number_complimentary_i int4 10 1 The number of issues sent after a subscription has ceased
p_subscription_renewal_date_d date 13  √  null
p_subscription_status_c varchar 24  √  'PERMANENT'::character varying
p_first_issue_d date 13  √  null
p_last_issue_d date 13  √  null
p_gift_from_key_n numeric 10  √  0
p_partner.p_partner_key_n p_subscription_fk3 R
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_subscription_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_subscription_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 66.132 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
p_publication_code_c + p_partner_key_n Primary key Asc/Asc p_subscription_pk
p_publication_code_c Performance Asc inx_p_subscription_fk1_key1
p_partner_key_n Performance Asc inx_p_subscription_fk2_key2
p_gift_from_key_n Performance Asc inx_p_subscription_fk3_key3
p_reason_subs_given_code_c Performance Asc inx_p_subscription_fk4_key4
p_reason_subs_cancelled_code_c Performance Asc inx_p_subscription_fk5_key5
s_created_by_c Performance Asc inx_p_subscription_fkcr_key6
s_modified_by_c Performance Asc inx_p_subscription_fkmd_key7
p_publication_code_c + p_partner_key_n Must be unique Asc/Asc inx_p_subscription_pk0
p_expiry_date_d Performance Asc p_expiry_k0

Close relationships  within of separation: