dim_companies


Description

Information about each company.

Columns

Column Type Children Parents Comments
company_id int8
dim_communities.company_id Implied Constraint R
dim_helpers.company_id Implied Constraint R
dim_members.company_id Implied Constraint R
dim_membership_plans.company_id Implied Constraint R
dim_memberships.company_id Implied Constraint R
dim_products.company_id Implied Constraint R
dim_profiles.company_id Implied Constraint R
dim_taxes.company_id Implied Constraint R
fct_budgets.company_id Implied Constraint R
fct_care_management_tasks.company_id Implied Constraint R
fct_chsp_service_transactions.company_id Implied Constraint R
fct_chsp_service_visits.company_id Implied Constraint R
fct_company_hosts.company_id Implied Constraint R
fct_contract_products.company_id Implied Constraint R
fct_contracts.company_id Implied Constraint R
fct_event_attendees.company_id Implied Constraint R
fct_event_occurrences.company_id Implied Constraint R
fct_events.company_id Implied Constraint R
fct_finance_transactions.company_id Implied Constraint R
fct_helper_communities.company_id Implied Constraint R
fct_helper_leave_periods.company_id Implied Constraint R
fct_helper_matching_preferences.company_id Implied Constraint R
fct_helper_services.company_id Implied Constraint R
fct_helper_verification_renewals.company_id Implied Constraint R
fct_helper_verifications.company_id Implied Constraint R
fct_incident_actions.company_id Implied Constraint R
fct_incidents.company_id Implied Constraint R
fct_invoice_items.company_id Implied Constraint R
fct_invoices.company_id Implied Constraint R
fct_last_invocation.company_id Implied Constraint R
fct_membership_cohorts.company_id Implied Constraint R
fct_membership_communities.company_id Implied Constraint R
fct_membership_leave_periods.company_id Implied Constraint R
fct_membership_roles.company_id Implied Constraint R
fct_monthly_membership_reporting.company_id Implied Constraint R
fct_observations.company_id Implied Constraint R
fct_purchase_order_items.company_id Implied Constraint R
fct_purchase_order_lines_services.company_id Implied Constraint R
fct_purchase_orders.company_id Implied Constraint R
fct_schedule_rules.company_id Implied Constraint R
fct_survey_question_responses.company_id Implied Constraint R
fct_survey_questions.company_id Implied Constraint R
fct_surveys.company_id Implied Constraint R
fct_ticket_assignees.company_id Implied Constraint R
fct_ticket_todos.company_id Implied Constraint R
fct_tickets.company_id Implied Constraint R
fct_visit_actions.company_id Implied Constraint R
fct_visit_services.company_id Implied Constraint R
fct_visits.company_id Implied Constraint R

The company ID, e.g.: 345.
name varchar

The name of the company, e.g.: “ACME Home Care”.
timezone varchar
created_at timestamp

The date and time created (in UTC), e.g.: 2021-03-02 00:12:59.996101.

Indexes

Constraint Name Type Sort Column(s)
dim_companies_pkey Primary key Asc company_id

Relationships

Close relationships within degrees of separation