Idx | Field Name | Data Type |
---|---|---|
* | id | char(36) |
* | name | varchar(255) |
* | alert | text |
Indexes | ||
alert_pkey | ON id | |
alert_name_key | ON name |
Idx | Field Name | Data Type |
---|---|---|
* | id | char(36) |
* | name | varchar(40) |
revision | integer | |
channel | text | |
Indexes | ||
channel_pkey | ON id |
Idx | Field Name | Data Type |
---|---|---|
* | id | varchar(255) |
* | name | varchar(255) |
revision | integer | |
channel_group | text | |
Indexes | ||
channel_group_pkey | ON id | |
channel_group_name_key | ON name |
Idx | Field Name | Data Type |
---|---|---|
* | id | integer DEFAULT nextval('channel_snapshot_sequence'::regclass) |
* | revision | integer |
* | channel_id | char(36) |
* | user_id | integer |
date_created | timestamptz | |
channel | text | |
Indexes | ||
channel_snapshot_pkey | ON id |
Idx | Field Name | Data Type |
---|---|---|
* | id | varchar(255) |
* | name | varchar(255) |
revision | integer | |
code_template | text | |
Indexes | ||
code_template_pkey | ON id |
Idx | Field Name | Data Type |
---|---|---|
* | id | varchar(255) |
* | name | varchar(255) |
revision | integer | |
library | text | |
Indexes | ||
code_template_library_pkey | ON id | |
code_template_library_name_key | ON name |
Idx | Field Name | Data Type |
---|---|---|
* | id | integer DEFAULT nextval('code_template_library_snapshot_sequence'::regclass) |
* | revision | integer |
* | library_id | char(36) |
* | user_id | integer |
date_created | timestamptz | |
library | text | |
Indexes | ||
code_template_library_snapshot_pkey | ON id |
Idx | Field Name | Data Type |
---|---|---|
* | id | integer DEFAULT nextval('code_template_snapshot_sequence'::regclass) |
* | revision | integer |
* | code_template_id | char(36) |
* | user_id | integer |
date_created | timestamptz | |
code_template | text | |
Indexes | ||
code_template_snapshot_pkey | ON id |
Idx | Field Name | Data Type |
---|---|---|
* | category | varchar(255) |
* | name | varchar(255) |
value | text | |
Indexes | ||
configuration_pkey | ON category, name |
Idx | Field Name | Data Type |
---|---|---|
* | local_channel_id | bigint |
* | channel_id | varchar(36) |
Indexes | ||
d_channels_pkey | ON local_channel_id | |
unique_channel_id | ON channel_id |
Idx | Field Name | Data Type |
---|---|---|
* | id | bigint |
* | server_id | varchar(36) |
received_date | timestamptz | |
* | processed | boolean DEFAULT false |
original_id | bigint | |
import_id | bigint | |
import_channel_id | varchar(36) | |
Indexes | ||
d_m1_pkey | ON id | |
d_m1_index1 | ON id, server_id |
Idx | Field Name | Data Type |
---|---|---|
* | id | varchar(255) |
* | message_id | bigint |
type | varchar(40) | |
* | segment_id | integer |
* | attachment_size | integer |
content | bytea | |
Indexes | ||
d_ma1_index1 | ON id | |
d_ma1_fki | ON message_id | |
Foreign Keys | ||
d_ma1_fkey | ( message_id ) ref d_m1 (id) |
Idx | Field Name | Data Type |
---|---|---|
* | metadata_id | integer |
* | message_id | bigint |
* | content_type | integer |
content | text | |
* | is_encrypted | boolean |
data_type | varchar(255) | |
Indexes | ||
d_mc1_pkey | ON message_id, metadata_id, content_type | |
d_mc1_fki | ON message_id, metadata_id | |
Foreign Keys | ||
d_mc1_fkey | ( message_id, metadata_id ) ref d_mm1 (message_id, id) |
Idx | Field Name | Data Type |
---|---|---|
* | metadata_id | integer |
* | message_id | bigint |
Indexes | ||
d_mcm1_pkey | ON message_id, metadata_id | |
Foreign Keys | ||
d_mcm1_fkey | ( message_id, metadata_id ) ref d_mm1 (message_id, id) |
Idx | Field Name | Data Type |
---|---|---|
* | id | integer |
* | message_id | bigint |
* | server_id | varchar(36) |
received_date | timestamptz | |
* | status | char(1) |
connector_name | text | |
* | send_attempts | integer DEFAULT 0 |
send_date | timestamptz | |
response_date | timestamptz | |
* | error_code | integer DEFAULT 0 |
* | chain_id | integer |
* | order_id | integer |
Indexes | ||
d_mm1_pkey | ON message_id, id | |
d_mm1_index1 | ON message_id, id, status | |
d_mm1_index2 | ON message_id, server_id, id | |
d_mm1_index3 | ON id, status, server_id | |
d_mm1_fki | ON message_id | |
Foreign Keys | ||
d_mm1_fkey | ( message_id ) ref d_m1 (id) |
Idx | Field Name | Data Type |
---|---|---|
metadata_id | integer | |
* | server_id | varchar(36) |
* | received | bigint DEFAULT 0 |
* | received_lifetime | bigint DEFAULT 0 |
* | filtered | bigint DEFAULT 0 |
* | filtered_lifetime | bigint DEFAULT 0 |
* | sent | bigint DEFAULT 0 |
* | sent_lifetime | bigint DEFAULT 0 |
* | error | bigint DEFAULT 0 |
* | error_lifetime | bigint DEFAULT 0 |
Indexes | ||
d_ms1_index1 | ON metadata_id, server_id |
Idx | Field Name | Data Type |
---|---|---|
* | id | integer DEFAULT nextval('event_sequence'::regclass) |
date_created | timestamptz | |
* | name | text |
* | event_level | varchar(40) |
* | outcome | varchar(40) |
attributes | text | |
* | user_id | integer |
ip_address | varchar(40) | |
server_id | varchar(36) | |
Indexes | ||
event_pkey | ON id |
Idx | Field Name | Data Type |
---|---|---|
* | id | integer DEFAULT nextval('person_sequence'::regclass) |
* | username | varchar(40) |
firstname | varchar(40) | |
lastname | varchar(40) | |
organization | varchar(255) | |
industry | varchar(255) | |
varchar(255) | ||
phonenumber | varchar(40) | |
description | varchar(255) | |
last_login | timestamptz | |
grace_period_start | timestamptz | |
strike_count | integer | |
last_strike_time | timestamptz | |
* | logged_in | boolean |
Indexes | ||
person_pkey | ON id |
Idx | Field Name | Data Type |
---|---|---|
* | person_id | integer |
* | password | varchar(255) |
password_date | timestamptz | |
Foreign Keys | ||
person_password_person_id_fkey | ( person_id ) ref person (id) |
Idx | Field Name | Data Type |
---|---|---|
* | person_id | integer |
* | name | varchar(255) |
value | text | |
Indexes | ||
person_preference_index1 | ON person_id | |
Foreign Keys | ||
person_preference_person_id_fkey | ( person_id ) ref person (id) |
Idx | Field Name | Data Type |
---|---|---|
version | varchar(40) |
Idx | Field Name | Data Type |
---|---|---|
* | group_id | varchar(40) |
* | id | varchar(40) |
script | text | |
Indexes | ||
script_pkey | ON group_id, id |
Sequences | Description |
---|---|
channel_snapshot_sequence | |
code_template_library_snapshot_sequence | |
code_template_snapshot_sequence | |
configuration_sequence | |
d_msq1 | |
event_sequence | |
person_sequence |