Table p_subscription
Description:
Details of which partners receive which publications.
PRIMARY KEY
p_publication_code_c
varchar (20) NOT NULL
The is the key to the publication table p_publication
p_partner_key_n
bigint default: 0 NOT NULL
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number. p_partner

p_publication_copies_i
integer default: 1
p_reason_subs_given_code_c
varchar (24) NOT NULL
p_reason_subscription_given
p_reason_subs_cancelled_code_c
varchar (24)
p_reason_subscription_cancelled
p_expiry_date_d
date
Date the subscription expires
p_provisional_expiry_date_d
date
Provisional date on which the subscription may expire
p_gratis_subscription_l
boolean default: '1' NOT NULL
p_date_notice_sent_d
date
p_date_cancelled_d
date
p_start_date_d
date default: CURRENT_DATE NOT NULL
p_number_issues_received_i
integer default: 0 NOT NULL
p_number_complimentary_i
integer default: 1 NOT NULL
The number of issues sent after a subscription has ceased
p_subscription_renewal_date_d
date
p_subscription_status_c
varchar (24) default: 'PERMANENT'
p_first_issue_d
date
p_last_issue_d
date
p_gift_from_key_n
bigint
p_partner
s_date_created_d
date default: CURRENT_DATE
The date the record was created.
s_created_by_c
varchar (20)
User ID of who created this record. s_user
s_date_modified_d
date
The date the record was modified.
s_modified_by_c
varchar (20)
User ID of who last modified this record. s_user
s_modification_id_t
timestamp
This identifies the current version of the record.


FOREIGN KEY
p_subscription_fk1: p_publication_code_c => p_publication
p_subscription_fk2: p_partner_key_n => p_partner
p_subscription_fk3: p_gift_from_key_n => p_partner
p_subscription_fk4: p_reason_subs_given_code_c => p_reason_subscription_given
p_subscription_fk5: p_reason_subs_cancelled_code_c => p_reason_subscription_cancelled
p_subscription_fkcr: s_created_by_c => s_user
p_subscription_fkmd: s_modified_by_c => s_user