Table openpetra_trunk.public.p_addressee_title_override
This is used to override titles that might be different in the address than that in the letter. Eg German Herr Herrn Sehr geehrter Herr Starling in the letter and Herrn Starling in the address.

 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_language_code_c varchar 20 '99'::character varying
p_language.p_language_code_c p_addressee_title_override_fk1 R
This is the code used to identify a language.
p_title_c varchar 64 The partner's title
p_title_override_c varchar 64 The title to override the partner
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_addressee_title_override_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_addressee_title_override_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 0 rows at Mi Nov 09 18:02 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
p_language_code_c + p_title_c Primary key Asc/Asc p_addressee_title_override_pk
p_language_code_c + p_title_c Must be unique Asc/Asc inx__addressee_title_override_pk0
p_language_code_c Performance Asc inx_essee_title_override_fk1_key1
s_created_by_c Performance Asc inx_ssee_title_override_fkcr_key2
s_modified_by_c Performance Asc inx_ssee_title_override_fkmd_key3

Close relationships  within of separation: