Operational Data Store Schema Reference

Operational Data Store Schema Reference

DX_ODS_PARTNER Table

DX_ODS_PARTNER Table

The DX_ODS_PARTNER table contains information about the partners for which
B2B Data Exchange
processes events.

Oracle Server DX_ODS_PARTNER Table

The following table describes the columns and data types of the DX_ODS_PARTNER table in the Oracle server:
Column Name
data type
Description
PARTNER_ID*
NUMBERPS(19,0), NOT NULL
Unique identifier for the related partner.
PARTNER_NAME
VARCHAR2(255)
Name of the related partner.
* Primary key. Used in the DX_ODS_EVENT_FACTS table as a foreign key.

SQL Server DX_ODS_PARTNER Table

The following table describes the columns and data types of the DX_ODS_PARTNER table in the SQL server:
Column Name
data type
Description
PARTNER_ID*
NUMBERIC(19,0), NOT NULL
Unique identifier for the related partner.
PARTNER_NAME
VARCHAR(255)
Name of the related partner.
* Primary key. Used in the DX_ODS_EVENT_FACTS table as a foreign key.

0 COMMENTS

We’d like to hear from you!