fct_idle_period


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idle_period_id int8 19 √ null
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id Implied Constraint R
customer_id int8 19 √ null
dim_customer.customer_id Implied Constraint R
rate_id int8 19 √ null
dim_rate.rate_id Implied Constraint R
contract_id int8 19 √ null
fct_contract.contract_id fct_idle_period_contract_id_fkey R
idle_period_property_id varchar 256 √ null
dim_idle_period_property.idle_period_property_id Implied Constraint R
start_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
end_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
charge_amount numeric 18 √ null
currency_id varchar 256 √ null
dim_currency.currency_id Implied Constraint R
last_updated timestamptz 35 √ null

Relationships

Close relationships within degrees of separation