sms_campaign

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
sms_messages_outbound.campaign_id FKCAMPAIGN00000001R
campaign_name VARCHAR 100 null
campaign_type INT 10 null
campaign_trigger_type INT 10 null
report_id INT 10 null
stretchy_report.id sms_campaign_ibfk_1R
provider_id BIGINT 19 √ NULL
param_value TEXT 65535 √ NULL
status_enum INT 10 null
message TEXT 65535 null
submittedon_date DATE 10 √ NULL
submittedon_userid BIGINT 19 √ NULL
approvedon_date DATE 10 √ NULL
approvedon_userid BIGINT 19 √ NULL
closedon_date DATE 10 √ NULL
closedon_userid BIGINT 19 √ NULL
recurrence VARCHAR 100 √ NULL
next_trigger_date DATETIME 19 √ NULL
last_trigger_date DATETIME 19 √ NULL
recurrence_start_date DATETIME 19 √ NULL
is_visible BIT 1 √ b'1'
is_notification BIT 1 √ b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
report_id Performance Asc report_id

Relationships

Close relationships within degrees of separation