Table openpetra_trunk.public.um_unit_cost
Details pertaining to the costs of being on in the unit.

 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_unit.p_partner_key_n um_unit_cost_fk1 R
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number.
um_valid_from_date_d date 13 Date from which these costs are applicable.
um_single_costs_period_intl_n numeric 24,10  √  0 Indicates amount it costs a single to be on the team.
um_couple_costs_period_intl_n numeric 24,10  √  0 Indicates amount it costs a couple to be on the team.
um_child1_costs_period_intl_n numeric 24,10  √  0 Indicates amount it costs a child to be on the team.
um_child2_costs_period_intl_n numeric 24,10  √  0 Indicates amount it costs a child to be on the team.
um_child3_costs_period_intl_n numeric 24,10  √  0 Indicates amount it costs a child to be on the team.
um_adult_joining_charge_intl_n numeric 24,10  √  0 Indicates the joining charge for adults.
um_couple_joining_charge_intl_n numeric 24,10  √  0 Indicates the joining charge for couples.
um_child_joining_charge_intl_n numeric 24,10  √  0 Indicates the joining charge for a child.
a_local_currency_code_c varchar 16  √  null
a_currency.a_currency_code_c um_unit_cost_fk2 R
Indicates the local currency.
um_charge_period_c varchar 24 The charge period for the unit, eg. monthly, quarterly.
um_single_costs_period_base_n numeric 24,10  √  0 Indicates amount it costs a single to be on the team.
um_couple_costs_period_base_n numeric 24,10  √  0 Indicates amount it costs a couple to be on the team.
um_child1_costs_period_base_n numeric 24,10  √  0 Indicates amount it costs a child to be on the team.
um_child2_costs_period_base_n numeric 24,10  √  0 Indicates amount it costs a child to be on the team.
um_child3_costs_period_base_n numeric 24,10  √  0 Indicates amount it costs a child to be on the team.
um_adult_joining_charge_base_n numeric 24,10  √  0 Indicates the joining charge for adults.
um_couple_joining_charge_base_n numeric 24,10  √  0 Indicates the joining charge for couples.
um_child_joining_charge_base_n numeric 24,10  √  0 Indicates the joining charge for a child.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c um_unit_cost_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c um_unit_cost_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
p_partner_key_n + um_valid_from_date_d Primary key Asc/Asc um_unit_cost_pk
p_partner_key_n Performance Asc inx_um_unit_cost_fk1_key1
a_local_currency_code_c Performance Asc inx_um_unit_cost_fk2_key2
s_created_by_c Performance Asc inx_um_unit_cost_fkcr_key3
s_modified_by_c Performance Asc inx_um_unit_cost_fkmd_key4
p_partner_key_n + um_valid_from_date_d Must be unique Asc/Asc inx_um_unit_cost_pk0

Close relationships  within of separation: