Twilio messages
twilio_messages
- Schema: public
- PK: id (int4, serial)
Columns
| Column |
Type |
Nullable |
Default |
Notes |
| id |
int4 |
NO |
serial |
PK |
| sid |
varchar |
NO |
|
Twilio SID, UNIQUE |
| account_sid |
varchar |
YES |
|
|
| from |
varchar |
YES |
|
|
| to |
varchar |
YES |
|
|
| body |
text |
YES |
|
|
| status |
varchar |
YES |
|
|
| direction |
varchar |
YES |
|
|
| date_created |
timestamp |
YES |
|
|
| date_updated |
timestamp |
YES |
|
|
| date_sent |
timestamp |
YES |
|
|
| error_code |
int4 |
YES |
|
|
| error_message |
text |
YES |
|
|
| price |
numeric |
YES |
|
|
| price_unit |
varchar |
YES |
|
|
| num_segments |
int4 |
YES |
|
|
| num_media |
int4 |
YES |
|
|
| messaging_service_sid |
varchar |
YES |
|
|
| uri |
text |
YES |
|
|
| subresource_uris |
jsonb |
YES |
|
|
| tags |
jsonb |
YES |
|
|
| api_version |
varchar |
YES |
|
|
| created_at |
timestamp |
YES |
CURRENT_TIMESTAMP |
|
| updated_at |
timestamp |
YES |
CURRENT_TIMESTAMP |
|
Key indexes
twilio_messages_pkey — primary key on idtwilio_messages_sid_key — UNIQUE on sid