sms_messages

0 rows


Description

SMS Messages sent via the SMS subsystem

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
recipientnumber VARCHAR 30 ''
content LONGTEXT 2147483647 √ NULL
component VARCHAR 100 ''
messagetype VARCHAR 100 ''
recipientuserid BIGINT 19 √ NULL
issensitive TINYINT 3 0
gatewayid BIGINT 19 √ NULL
sms_gateways.id smsmess_gat2_fkR
status VARCHAR 100 √ NULL
timecreated BIGINT 19 null

Indexes

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

Relationships