| Table openpetra_trunk.public.p_partner_contact_attribute Associates a p_contact_attribute_detail with a p_partner_contact. A contact with a partner may have more than one p_contact_attribute_detail associated with it.
|
Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 1.391 rows at Do Nov 10 18:00 MEZ 2011 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| p_contact_id_i + p_contact_attribute_code_c + p_contact_attr_detail_code_c | Primary key | Asc/Asc/Asc | p_partner_contact_attribute_pk |
| p_contact_attribute_code_c + p_contact_attr_detail_code_c | Performance | Asc/Asc | inx_er_contact_attribute_fk1_key1 |
| p_contact_id_i | Performance | Asc | inx_er_contact_attribute_fk2_key2 |
| p_contact_id_i + p_contact_attribute_code_c + p_contact_attr_detail_code_c | Must be unique | Asc/Asc/Asc | inx_partner_contact_attribute_pk0 |
| s_created_by_c | Performance | Asc | inx_r_contact_attribute_fkcr_key3 |
| s_modified_by_c | Performance | Asc | inx_r_contact_attribute_fkmd_key4 |
| p_contact_attribute_code_c + p_contact_attr_detail_code_c + p_contact_id_i | Must be unique | Asc/Asc/Asc | p_partner_contact_attribute_k0 |
|