| Column | MySQL Type | Oracle Type | Nullable | Description |
|---|---|---|---|---|
| WID | BIGINT | NUMBER | No | Warehouse ID for this interaction |
| Type | VARCHAR | VARCHAR2(100) | Yes | Interaction type. It is recommended to use external controled vacabulary terms, such as PSI-MI
Interaction Type CV.
|
| Name | VARCHAR | VARCHAR2(120) | Yes | Name of the interaction. |
| DataSetWID | BIGINT | NUMBER | No | WID of the dataset the interaction is from. |
| Table | Column |
|---|---|
| InteractionParticipant | InteractionWID |
| Name | Columns |
|---|---|
| INTERACTION_DWID | DataSetWID |