The following figure shows the relationships between the fact tables and the dimension tables:

In the figure, each table displays the column names and key types. Columns that function as primary keys are underlined. The connectors indicate the primary-foreign key relationship between the tables.

The following table describes the tables and relationships:

Table Name	Primary Key Name	Foreign Key Usage
DX_ODS_CUSTOM_FACTS	FACT_ROW_ID EVENT_ATTRIBUTE_ID	Not used.
DX_ODS_EVENT_FACTS	ROW_ID	Used as a foreign key in the following tables: DX_ODS_EVENT_FACTS
DX_ODS_ACCOUNT	ACCOUNT_ID	Used as a foreign key in the following tables: DX_ODS_EVENT_FACTS
DX_ODS_CUSTOM_FACTS_EAV	ID	Used as a foreign key in the following tables: DX_ODS_CUSTOM_FACTS. The foreign key is named FACT_ROW_ID.
DX_ODS_EVENT_STATUS	EVENT_STATUS_ID	Used as a foreign key in the following tables: DX_ODS_EVENT_FACTS
DX_ODS_EVENT_TYPE	EVENT_TYPE_ID	Used as a foreign key in the following tables: DX_ODS_EVENT_FACTS
DX_ODS_PARTNER	PARTNER_ID	Used as a foreign key in the following tables: DX_ODS_ACCOUNT DX_ODS_EVENT_FACTS
DX_ODS_TIME_BREAKDOWN	TIMESLICE	Not used.

In addition to the fact tables and dimension tables, the operational data store contains user access tables. There are no direct relationships between the user access tables and the other tables. You use the user access tables to restrict access to specific information in the operational data store.

The following figure shows the user access tables:

In the figure, each table displays the column names and key types. Columns that function as primary keys are underlined.

The operational data store schema contains the following user access tables:

DX_ODS_USER_ACCESS table
DX_ODS_USER_EVENT_TYPE table
DX_ODS_USER_SUPER table