Table openpetra_trunk.public.p_mailing
Lists mailings that are being tracked. When entering gifts, the mailing that motivated the gift can be indicated.

 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_mailing_code_c varchar 50
a_ep_match.p_mailing_code_c a_ep_match_fk3 R
a_gift_detail.p_mailing_code_c a_gift_detail_fk4 R
a_recurring_gift_detail.p_mailing_code_c a_recurring_gift_detail_fk4 R
p_partner_contact.p_mailing_code_c p_partner_contact_fk2 R
Mailing Code
p_mailing_description_c varchar 160  √  null Mailing Description
p_mailing_date_d date 13  √  null Date Of Mailing
a_motivation_group_code_c varchar 16  √  null This defines a motivation group.
a_motivation_detail_code_c varchar 16  √  null This defines the motivation detail within a motivation group.
p_mailing_cost_n numeric 19,2  √  0 Cost of Mailing
p_mailing_attributed_amount_n numeric 19,2  √  0 Gift amount attributed to this mailing
p_viewable_l bool 1  √  true Indicates if the mailing is viewable in comboboxes where the user can select it
p_viewable_until_d date 13  √  null Date until this mailing is viewable for users (if p_viewable_l is set)
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_mailing_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_mailing_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
p_mailing_code_c Primary key Asc p_mailing_pk
p_mailing_code_c Performance Asc inx_a_ep_match_fk3_ref0
s_created_by_c Performance Asc inx_p_mailing_fkcr_key2
s_modified_by_c Performance Asc inx_p_mailing_fkmd_key3
p_mailing_code_c Must be unique Asc inx_p_mailing_pk1

Close relationships  within of separation: