Layout with Tools

1 mirth (c) DbSchema Hover columns to read the comments. Fk d_ma1_fkey d_ma1 ref d_m1 ( message_id -> id ) Fk d_ma1_fkey d_ma1 ref d_m1 ( message_id -> id ) message_id Fk d_mc1_fkey d_mc1 ref d_mm1 ( message_id, metadata_id -> id ) Fk d_mc1_fkey d_mc1 ref d_mm1 ( message_id, metadata_id -> id ) message_id,metadata_id Fk d_mcm1_fkey d_mcm1 ref d_mm1 ( message_id, metadata_id -> id ) Fk d_mcm1_fkey d_mcm1 ref d_mm1 ( message_id, metadata_id -> id ) message_id,metadata_id Fk d_mm1_fkey d_mm1 ref d_m1 ( message_id -> id ) Fk d_mm1_fkey d_mm1 ref d_m1 ( message_id -> id ) message_id Fk person_password_person_id_fkey person_password ref person ( person_id -> id ) Fk person_password_person_id_fkey person_password ref person ( person_id -> id ) person_id Fk person_preference_person_id_fkey person_preference ref person ( person_id -> id ) Fk person_preference_person_id_fkey person_preference ref person ( person_id -> id ) person_id alertTable public.alert Pk alert_pkey ( id ) idid * char(36) char(36) Unq alert_name_key ( name ) namename * varchar(255) varchar(255) alertalert * text text channelTable public.channel Pk channel_pkey ( id ) idid * char(36) char(36) namename * varchar(40) varchar(40) revisionrevision integer integer channelchannel text text channel_groupTable public.channel_group Pk channel_group_pkey ( id ) idid * varchar(255) varchar(255) Unq channel_group_name_key ( name ) namename * varchar(255) varchar(255) revisionrevision integer integer channel_groupchannel_group text text channel_snapshotTable public.channel_snapshot Pk channel_snapshot_pkey ( id ) idid * integer default nextval('channel_snapshot_sequence'::regclass) integer revisionrevision * integer integer channel_idchannel_id * char(36) char(36) user_iduser_id * integer integer date_createddate_created timestamptz timestamptz channelchannel text text code_templateTable public.code_template Pk code_template_pkey ( id ) idid * varchar(255) varchar(255) namename * varchar(255) varchar(255) revisionrevision integer integer code_templatecode_template text text code_template_libraryTable public.code_template_library Pk code_template_library_pkey ( id ) idid * varchar(255) varchar(255) Unq code_template_library_name_key ( name ) namename * varchar(255) varchar(255) revisionrevision integer integer librarylibrary text text code_template_library_snapshotTable public.code_template_library_snapshot Pk code_template_library_snapshot_pkey ( id ) idid * integer default nextval('code_template_library_snapshot_sequence'::regclass) integer revisionrevision * integer integer library_idlibrary_id * char(36) char(36) user_iduser_id * integer integer date_createddate_created timestamptz timestamptz librarylibrary text text code_template_snapshotTable public.code_template_snapshot Pk code_template_snapshot_pkey ( id ) idid * integer default nextval('code_template_snapshot_sequence'::regclass) integer revisionrevision * integer integer code_template_idcode_template_id * char(36) char(36) user_iduser_id * integer integer date_createddate_created timestamptz timestamptz code_templatecode_template text text configurationTable public.configuration Pk configuration_pkey ( category, name ) categorycategory * varchar(255) varchar(255) Pk configuration_pkey ( category, name ) namename * varchar(255) varchar(255) valuevalue text text d_channelsTable public.d_channels Pk d_channels_pkey ( local_channel_id ) local_channel_idlocal_channel_id * bigint bigint Unq unique_channel_id ( channel_id ) channel_idchannel_id * varchar(36) varchar(36) d_m1Table public.d_m1 Pk d_m1_pkey ( id ) d_m1_index1 ( id, server_id ) idid * bigint bigintReferred by d_ma1 ( message_id -> id ) Referred by d_mm1 ( message_id -> id ) d_m1_index1 ( id, server_id ) server_idserver_id * varchar(36) varchar(36) received_datereceived_date timestamptz timestamptz processedprocessed * boolean default false boolean original_idoriginal_id bigint bigint import_idimport_id bigint bigint import_channel_idimport_channel_id varchar(36) varchar(36) d_ma1Table public.d_ma1 d_ma1_index1 ( id ) idid * varchar(255) varchar(255) d_ma1_fki ( message_id ) message_idmessage_id * bigint bigintReferences d_m1 ( message_id -> id ) typetype varchar(40) varchar(40) segment_idsegment_id * integer integer attachment_sizeattachment_size * integer integer contentcontent bytea bytea d_mc1Table public.d_mc1 Pk d_mc1_pkey ( message_id, metadata_id, content_type ) d_mc1_fki ( message_id, metadata_id ) metadata_idmetadata_id * integer integerReferences d_mm1 ( message_id, metadata_id -> id ) Pk d_mc1_pkey ( message_id, metadata_id, content_type ) d_mc1_fki ( message_id, metadata_id ) message_idmessage_id * bigint bigintReferences d_mm1 ( message_id, metadata_id -> id ) Pk d_mc1_pkey ( message_id, metadata_id, content_type ) content_typecontent_type * integer integer contentcontent text text is_encryptedis_encrypted * boolean boolean data_typedata_type varchar(255) varchar(255) d_mcm1Table public.d_mcm1 Pk d_mcm1_pkey ( message_id, metadata_id ) metadata_idmetadata_id * integer integerReferences d_mm1 ( message_id, metadata_id -> id ) Pk d_mcm1_pkey ( message_id, metadata_id ) message_idmessage_id * bigint bigintReferences d_mm1 ( message_id, metadata_id -> id ) d_mm1Table public.d_mm1 Pk d_mm1_pkey ( message_id, id ) d_mm1_index1 ( message_id, id, status ) d_mm1_index2 ( message_id, server_id, id ) d_mm1_index3 ( id, status, server_id ) idid * integer integerReferred by d_mc1 ( message_id, metadata_id -> id ) Referred by d_mcm1 ( message_id, metadata_id -> id ) Pk d_mm1_pkey ( message_id, id ) d_mm1_index1 ( message_id, id, status ) d_mm1_index2 ( message_id, server_id, id ) d_mm1_fki ( message_id ) message_idmessage_id * bigint bigintReferences d_m1 ( message_id -> id ) Referred by d_mc1 ( message_id, metadata_id -> id ) Referred by d_mcm1 ( message_id, metadata_id -> id ) d_mm1_index2 ( message_id, server_id, id ) d_mm1_index3 ( id, status, server_id ) server_idserver_id * varchar(36) varchar(36) received_datereceived_date timestamptz timestamptz d_mm1_index1 ( message_id, id, status ) d_mm1_index3 ( id, status, server_id ) statusstatus * char(1) char(1) connector_nameconnector_name text text send_attemptssend_attempts * integer default 0 integer send_datesend_date timestamptz timestamptz response_dateresponse_date timestamptz timestamptz error_codeerror_code * integer default 0 integer chain_idchain_id * integer integer order_idorder_id * integer integer d_ms1Table public.d_ms1 d_ms1_index1 ( metadata_id, server_id ) metadata_idmetadata_id integer integer d_ms1_index1 ( metadata_id, server_id ) server_idserver_id * varchar(36) varchar(36) receivedreceived * bigint default 0 bigint received_lifetimereceived_lifetime * bigint default 0 bigint filteredfiltered * bigint default 0 bigint filtered_lifetimefiltered_lifetime * bigint default 0 bigint sentsent * bigint default 0 bigint sent_lifetimesent_lifetime * bigint default 0 bigint errorerror * bigint default 0 bigint error_lifetimeerror_lifetime * bigint default 0 bigint eventTable public.event Pk event_pkey ( id ) idid * integer default nextval('event_sequence'::regclass) integer date_createddate_created timestamptz timestamptz namename * text text event_levelevent_level * varchar(40) varchar(40) outcomeoutcome * varchar(40) varchar(40) attributesattributes text text user_iduser_id * integer integer ip_addressip_address varchar(40) varchar(40) server_idserver_id varchar(36) varchar(36) personTable public.person Pk person_pkey ( id ) idid * integer default nextval('person_sequence'::regclass) integerReferred by person_password ( person_id -> id ) Referred by person_preference ( person_id -> id ) usernameusername * varchar(40) varchar(40) firstnamefirstname varchar(40) varchar(40) lastnamelastname varchar(40) varchar(40) organizationorganization varchar(255) varchar(255) industryindustry varchar(255) varchar(255) emailemail varchar(255) varchar(255) phonenumberphonenumber varchar(40) varchar(40) descriptiondescription varchar(255) varchar(255) last_loginlast_login timestamptz timestamptz grace_period_startgrace_period_start timestamptz timestamptz strike_countstrike_count integer integer last_strike_timelast_strike_time timestamptz timestamptz logged_inlogged_in * boolean boolean person_passwordTable public.person_password person_idperson_id * integer integerReferences person ( person_id -> id ) passwordpassword * varchar(255) varchar(255) password_datepassword_date timestamptz timestamptz person_preferenceTable public.person_preference person_preference_index1 ( person_id ) person_idperson_id * integer integerReferences person ( person_id -> id ) namename * varchar(255) varchar(255) valuevalue text text schema_infoTable public.schema_info versionversion varchar(40) varchar(40) scriptTable public.script Pk script_pkey ( group_id, id ) group_idgroup_id * varchar(40) varchar(40) Pk script_pkey ( group_id, id ) idid * varchar(40) varchar(40) scriptscript text text
Tables



Table alert
IdxField NameData Type
* id char(36)
* name varchar(255)
* alert text
Indexes
alert_pkey ON id
alert_name_key ON name


Table channel
IdxField NameData Type
* id char(36)
* name varchar(40)
  revision integer
  channel text
Indexes
channel_pkey ON id


Table channel_group
IdxField NameData Type
* id varchar(255)
* name varchar(255)
  revision integer
  channel_group text
Indexes
channel_group_pkey ON id
channel_group_name_key ON name


Table channel_snapshot
IdxField NameData 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


Table code_template
IdxField NameData Type
* id varchar(255)
* name varchar(255)
  revision integer
  code_template text
Indexes
code_template_pkey ON id


Table code_template_library
IdxField NameData 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


Table code_template_library_snapshot
IdxField NameData 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


Table code_template_snapshot
IdxField NameData 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


Table configuration
IdxField NameData Type
* category varchar(255)
* name varchar(255)
  value text
Indexes
configuration_pkey ON category, name


Table d_channels
IdxField NameData Type
* local_channel_id bigint
* channel_id varchar(36)
Indexes
d_channels_pkey ON local_channel_id
unique_channel_id ON channel_id


Table d_m1
IdxField NameData 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


Table d_ma1
IdxField NameData 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)


Table d_mc1
IdxField NameData 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)


Table d_mcm1
IdxField NameData 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)


Table d_mm1
IdxField NameData 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)


Table d_ms1
IdxField NameData 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


Table event
IdxField NameData 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


Table person
IdxField NameData Type
* id integer DEFAULT nextval('person_sequence'::regclass)
* username varchar(40)
  firstname varchar(40)
  lastname varchar(40)
  organization varchar(255)
  industry varchar(255)
  email 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


Table person_password
IdxField NameData Type
* person_id integer
* password varchar(255)
  password_date timestamptz
Foreign Keys
person_password_person_id_fkey ( person_id ) ref person (id)


Table person_preference
IdxField NameData 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)


Table schema_info
IdxField NameData Type
  version varchar(40)


Table script
IdxField NameData Type
* group_id varchar(40)
* id varchar(40)
  script text
Indexes
script_pkey ON group_id, id


Schema public
SequencesDescription
channel_snapshot_sequence
code_template_library_snapshot_sequence
code_template_snapshot_sequence
configuration_sequence
d_msq1
event_sequence
person_sequence