channels
Communication channels for entity notifications and updates.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | integer | Channel ID | ||
owneruser users.ID | integer | Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) | ||
ownergroup groups.ID | integer | Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`) | ||
creator | integer | Creator user ID (defaults to authenticated user on creation) | ||
creationdate | bigint | date_part('epoch', now()) | Creation date and time as a Unix timestamp (defaults to current date and time on creation) | |
lastmodified | bigint | EXTRACT(epoch FROM now()) | Last modification date and time as a Unix timestamp (auto-reset on modification) | |
activity | smallint | 0 | Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED) | |
name | text | Name | ||
description | text | '' | Detailed general description |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| fk_channels_ownergroup | gin | ownergroup | ||||
| fk_channels_owneruser | gin | owneruser | ||||
| pk_channels | btree | ID | ||||
| s_channels_name | gin | name |
| Name | Type |
|---|---|
| dc_channels_activity | check |
| dc_channels_description | check |
| dc_channels_name | check |
| fk_channels_ownergroup | foreign_key |
| fk_channels_owneruser | foreign_key |
| pk_channels | primary_key |
Loading...