Table openpetra_trunk.public.p_contact_attribute_detail
Possible attribute details for each contact attribute. Breaks down the attribute into more specifice information that applies to a contact with a partner.

 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_contact_attribute_code_c varchar 32
p_partner_contact_attribute.p_contact_attribute_code_c p_partner_contact_attribute_fk1 R
p_contact_attribute.p_contact_attribute_code_c p_contact_attribute_detail_fk1 R
Contact Attribute Code
p_contact_attr_detail_code_c varchar 32
p_partner_contact_attribute.p_contact_attr_detail_code_c p_partner_contact_attribute_fk1 R
code for attribute detail
p_contact_attr_detail_descr_c varchar 64  √  null This is a contact attribute detail description.
p_active_l bool 1 true allowed to use this attribute detail for new contacts?
p_comment_c varchar 8000  √  null Contact attribute detail comment
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_contact_attribute_detail_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_contact_attribute_detail_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
p_contact_attribute_code_c + p_contact_attr_detail_code_c Primary key Asc/Asc p_contact_attribute_detail_pk
p_contact_attribute_code_c + p_contact_attr_detail_code_c Must be unique Asc/Asc inx__contact_attribute_detail_pk0
p_contact_attribute_code_c Performance Asc inx_act_attribute_detail_fk1_key1
s_created_by_c Performance Asc inx_ct_attribute_detail_fkcr_key2
s_modified_by_c Performance Asc inx_ct_attribute_detail_fkmd_key3

Close relationships  within of separation: