PPM_CHAT_MS_TEAMS_INFO
This table stores Microsoft Teams user information.
Foreign Keys
| Primary Key Table |
Primary Key Column |
Foreign Key Column |
| PPM_CHAT_MS_TEAMS_INFO |
TEAMS_INFO_ID |
|
Column Descriptions
| Column Name |
Null? |
Data Type |
Description |
| TEAMS_INFO_ID |
NOT NULL |
NUMBER |
System-generated identifier |
| EMAIL_ADDRESS |
NOT NULL |
VARCHAR2 (100 Char) |
Email address |
| TEAMS_USER_ID |
NOT NULL |
VARCHAR2 (100 Char) |
Microsoft Teams user ID |
| CONVERSATION_REFERENCE |
NOT NULL |
VARCHAR2 (2000 Char) |
Microsoft Teams conversation reference |
| NOTIFICATION_ENABLED |
NOT NULL |
VARCHAR2 (1 Char) |
Enable chatbot notification |
| USER_ID |
NULLABLE |
NUMBER |
User ID |
| UUID |
NULLABLE |
VARCHAR2 (50 Char) |
UUID |
| UUID_EXPIRE_DATE |
NULLABLE |
TIMESTAMP(6) |
The expiration date of UUID |
| CREATED_ BY |
NOT NUL |
NUMBER |
Identifier for the user who created the record |
| CREATION_ DATE |
NOT NULL |
DATE |
Date when the record was created |
| LAST_ UPDATED_ BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
| LAST_ UPDATE_ DATE |
NOT NULL |
DATE |
Date when the record was last updated |
Indexes
| Index Name |
Index Type |
Sequence |
Column Name |
| PPM_CHAT_MS_TEAMS_INFO_IDX1 |
NONUNIQUE |
1 |
UUID |
| PPM_CHAT_MS_TEAMS_INFO_IDX2 |
UNIQUE |
1 |
TEAMS_USER_ID |
| PPM_CHAT_MS_TEAMS_INFO_IDX3 |
UNIQUE |
1 |
USER_ID |
| PPM_CHAT_MS_TEAMS_INFO_PK |
UNIQUE |
1 |
TEAMS_INFO_ID |
Sequences
| Sequence Name |
Sequence Type |
| PPM_CHAT_MS_TEAMS_INFO_S |
TEAMS_INFO_ID |
