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
default: CURRENT_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