Table openpetra_trunk.public.pm_person_vision 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_partner_key_n numeric 10 0
p_person.p_partner_key_n pm_person_vision_fk1 R
pt_vision_area_name_c varchar 32
pt_vision_area.pt_vision_area_name_c pm_person_vision_fk2 R
pt_vision_level_i int4 10 0
pt_vision_level.pt_vision_level_i pm_person_vision_fk3 R
pm_vision_comment_c varchar 250  √  null
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c pm_person_vision_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c pm_person_vision_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_partner_key_n + pt_vision_area_name_c Primary key Asc/Asc pm_person_vision_pk
p_partner_key_n Performance Asc inx_pm_person_vision_fk1_key1
pt_vision_area_name_c Performance Asc inx_pm_person_vision_fk2_key2
pt_vision_level_i Performance Asc inx_pm_person_vision_fk3_key3
s_created_by_c Performance Asc inx_pm_person_vision_fkcr_key4
s_modified_by_c Performance Asc inx_pm_person_vision_fkmd_key5
p_partner_key_n + pt_vision_area_name_c Must be unique Asc/Asc inx_pm_person_vision_pk0
p_partner_key_n + pt_vision_level_i + pt_vision_area_name_c Performance Asc/Asc/Asc pm_pers_vision_k0

Close relationships  within of separation: