Table openpetra_trunk.public.p_method_of_contact
How contacts are made

 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_method_of_contact_code_c varchar 16
p_partner_contact.p_contact_code_c p_partner_contact_fk3 R
p_description_c varchar 64  √  null
p_contact_type_c varchar 16  √  null
p_valid_method_l bool 1 true
p_deletable_l bool 1 true This defines if the method of contact code can be deleted. This can only be updated by the system manager. At the risk of serious operational integrity. Default to Yes
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_method_of_contact_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_method_of_contact_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
p_method_of_contact_code_c Primary key Asc p_method_of_contact_pk
s_created_by_c Performance Asc inx_p_method_of_contact_fkcr_key1
s_modified_by_c Performance Asc inx_p_method_of_contact_fkmd_key2
p_method_of_contact_code_c Must be unique Asc inx_p_method_of_contact_pk0

Close relationships  within of separation: