civicrm_sms_provider


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_id N
civicrm_mailing.sms_provider_id FK_civicrm_mailing_sms_provider_id N

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_id N

Which Domain is this sms provier for

Table contained 0 rows

Indexes

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

Relationships