public.odmessagingcampaigndetails

public.odmessagingcampaigndetails

Description

Outbound Messaging Campaign Lookup Data (SMS, Email, WhatsApp)

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false Messaging Campaign GUID
name varchar(200) true Messaging Campaign Name
datecreated timestamp without time zone true Campaign Date Created (UTC)
datecreatedltc timestamp without time zone true Campaign Date Created (LTC)
datemodified timestamp without time zone true Campaign Date Modified (UTC)
datemodifiedltc timestamp without time zone true Campaign Date Modified (LTC)
version integer true
division varchar(50) true Campaign Division GUID
divisionname varchar(200) true Campaign Division Name
contactlist varchar(50) true Contact List GUID
contactlistname varchar(200) true Contact List Name
campaignstatus varchar(50) true Campaign Status
messagingtype varchar(50) true Messaging Type (sms, email, whatsapp)
callablewindowid varchar(50) true
contactsort varchar(50) true
messagesperminute numeric(20,2) true Messages Per Minute Rate Limit
ruleset varchar(50) true Rule Set GUID
rulesetname varchar(200) true Rule Set Name
sendersmsphonenumber varchar(50) true Sender SMS Phone Number
smsconfigmessagecolumn varchar(100) true
smsconfigphonenumbercolumn varchar(100) true
emailconfigemailcolumns text true
emailconfigfromaddress varchar(255) true
emailconfigfromname varchar(255) true
emailconfigreplytoaddress varchar(255) true
emailconfigsubject varchar(500) true
updated timestamp without time zone true Date Row Updated (UTC)

Constraints

Name Type Definition
odmessagingcampaigndetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
odmessagingcampaigndetails_pkey CREATE UNIQUE INDEX odmessagingcampaigndetails_pkey ON public.odmessagingcampaigndetails USING btree (id)