Table openpetra_trunk.public.s_job_group
Associates groups with roles

 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
pt_position_name_c varchar 60
um_job.pt_position_name_c s_job_group_fk1 R
Name of the position.
pt_position_scope_c varchar 24
um_job.pt_position_scope_c s_job_group_fk1 R
Scope of the position.
um_job_key_i int4 10
um_job.um_job_key_i s_job_group_fk1 R
Position record identifier
s_group_id_c varchar 20
s_group.s_group_id_c s_job_group_fk2 R
identifies a system group
s_unit_key_n numeric 10 0
s_group.s_unit_key_n s_job_group_fk2 R
um_job.pm_unit_key_n s_job_group_fk1 R
Field that this role/group assignment relates to
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c s_job_group_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c s_job_group_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
pt_position_name_c + pt_position_scope_c + um_job_key_i + s_group_id_c + s_unit_key_n Primary key Asc/Asc/Asc/Asc/Asc s_job_group_pk
s_unit_key_n + pt_position_name_c + pt_position_scope_c + um_job_key_i Performance Asc/Asc/Asc/Asc inx_s_job_group_fk1_key1
s_group_id_c + s_unit_key_n Performance Asc/Asc inx_s_job_group_fk2_key2
s_created_by_c Performance Asc inx_s_job_group_fkcr_key3
s_modified_by_c Performance Asc inx_s_job_group_fkmd_key4
pt_position_name_c + pt_position_scope_c + um_job_key_i + s_group_id_c + s_unit_key_n Must be unique Asc/Asc/Asc/Asc/Asc inx_s_job_group_pk0

Close relationships  within of separation: