rate_inclusion

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
rateplan_id int4 10 null
rate_plan.id rate_inclusion_rateplan_id_fk C
inclusion_id int4 10 null
inclusion.id rate_inclusion_fk C
charge_rate t_money 15,2 √ null
charge_dept int4 10 √ null
department.id rate_inclusion_dept_id_fk R
qty int4 10 1

Indexes

Constraint Name Type Sort Column(s)
pk_rate_inclusion Primary key Asc/Asc rateplan_id + inclusion_id
rate_inclusion_charge_dept_idx Performance Asc charge_dept
rate_inclusion_inclusion_id_idx Performance Asc inclusion_id
rate_inclusion_rateplan_id_idx Performance Asc rateplan_id

Relationships

Close relationships within degrees of separation