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 |