sms_messages_outbound

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
group_id int8 19 √ null
m_group.id fkgroup000000001 R
client_id int8 19 √ null
m_client.id fkclient00000001 R
staff_id int8 19 √ null
m_staff.id fkstaff000000001 R
status_enum int4 10 100
mobile_no varchar 50 √ null
message varchar 1000 null
campaign_id int8 19 √ null
sms_campaign.id fkcampaign00000001 R
external_id varchar 100 √ null
submittedon_date date 13 √ null
delivered_on_date timestamp 29,6 √ null
is_notification bool 1 false

Indexes

Constraint Name Type Sort Column(s)
sms_messages_outbound_pkey Primary key Asc id
fkcampaign00000001 Performance Asc campaign_id
fkclient00000001 Performance Asc client_id
fkgroup000000001 Performance Asc group_id
fkstaff000000001 Performance Asc staff_id

Relationships

Close relationships within degrees of separation