Notifications
The table below describes the Notifications table in the Platform database schema.
This is a virtual table, and is linked to the Notification_Scheme_Events table in the Platform database schema (see Notification_Scheme_Events).
This table contains the following virtual tables:
None of the columns in this table are updatable.
This table contains the following foldable column:
- Notification_Scheme_Events_Index
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Nullable |
|---|---|---|
|
Id Primary Key Foreign Key linked to column Id in Notification_Scheme_Events table |
SQL_BIGINT(unsigned) | False |
|
Notification_Scheme_Events_Index Primary Key Foreign Key linked to column Notification_Scheme_Events_Index in Notification_Scheme_Events table |
SQL_BIGINT(unsigned) | True |
|
Notifications_Index Primary Key |
SQL_BIGINT(unsigned) | True |
|
Notifications_emailAddress |
SQL_VARCHAR(1024) | True |
|
Notifications_expand |
SQL_VARCHAR(1024) | True |
|
Notifications_field_custom |
SQL_BIT | True |
|
Notifications_field_id |
SQL_VARCHAR(1024) | True |
|
Notifications_field_name |
SQL_VARCHAR(1024) | True |
|
Notifications_field_navigable |
SQL_BIT | True |
|
Notifications_field_orderable |
SQL_BIT | True |
|
Notifications_field_schema_custom |
SQL_VARCHAR(1024) | True |
|
Notifications_field_schema_customId |
SQL_BIGINT(unsigned) | True |
|
Notifications_field_schema_items |
SQL_VARCHAR(1024) | True |
|
Notifications_field_schema_type |
SQL_VARCHAR(1024) | True |
|
Notifications_field_searchable |
SQL_BIT | True |
|
Notifications_group_name |
SQL_VARCHAR(1024) | True |
|
Notifications_group_self |
SQL_VARCHAR(1024) | True |
|
Notifications_id |
SQL_BIGINT(unsigned) | True |
|
Notifications_notificationType |
SQL_VARCHAR(1024) | True |
|
Notifications_parameter |
SQL_VARCHAR(1024) | True |
|
Notifications_projectRole_description |
SQL_LONGVARCHAR(16777215) | True |
|
Notifications_projectRole_id |
SQL_BIGINT(unsigned) | True |
|
Notifications_projectRole_name |
SQL_VARCHAR(1024) | True |
|
Notifications_projectRole_self |
SQL_VARCHAR(1024) | True |
|
Notifications_user_active |
SQL_BIT | True |
|
Notifications_user_avatarUrls_16x16 |
SQL_VARCHAR(1024) | True |
|
Notifications_user_avatarUrls_24x24 |
SQL_VARCHAR(1024) | True |
|
Notifications_user_avatarUrls_32x32 |
SQL_VARCHAR(1024) | True |
|
Notifications_user_avatarUrls_48x48 |
SQL_VARCHAR(1024) | True |
|
Notifications_user_displayName |
SQL_VARCHAR(1024) | True |
|
Notifications_user_emailAddress |
SQL_VARCHAR(1024) | True |
|
Notifications_user_key |
SQL_VARCHAR(1024) | True |
|
Notifications_user_name |
SQL_VARCHAR(1024) | True |
|
Notifications_user_self |
SQL_VARCHAR(1024) | True |
|
Notifications_user_timeZone |
SQL_VARCHAR(1024) | True |