civicrm_sms_provider

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_action_schedule.sms_provider_id FK_civicrm_action_schedule_sms_provider_idN
civicrm_mailing.sms_provider_id FK_civicrm_mailing_sms_provider_idN

SMS Provider ID
name VARCHAR 64 √ null

Provider internal name points to option_value of option_group sms_provider_name
title VARCHAR 64 √ null

Provider name visible to user
username VARCHAR 255 √ null
password VARCHAR 255 √ null
api_type INT UNSIGNED 10 null

points to value in civicrm_option_value for group sms_api_type
api_url VARCHAR 128 √ null
api_params TEXT 65535 √ null

the api params in xml, http or smtp format
is_default TINYINT 3 √ 0
is_active TINYINT 3 √ 0
domain_id INT UNSIGNED 10 √ null
civicrm_domain.id FK_civicrm_sms_provider_domain_idN

Which Domain is this sms provier for

Indexes

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

Relationships

Close relationships within degrees of separation