message_queue

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
message_id INT 10 √ null
letter_id INT 10 √ null
letter.id letter_fk N

Foreign key to the letters table
borrowernumber INT 10 √ null
borrowers.borrowernumber messageq_ibfk_1 C
subject MEDIUMTEXT 16777215 √ null
content MEDIUMTEXT 16777215 √ null
metadata MEDIUMTEXT 16777215 √ null
letter_code VARCHAR 64 √ null
message_transport_type VARCHAR 20 null
message_transport_types.message_transport_type messageq_ibfk_2 R
status enum('sent', 'pending', 'failed', 'deleted') 7 pending
time_queued TIMESTAMP 19 √ null
updated_on TIMESTAMP 19 current_timestamp()
to_address LONGTEXT 2147483647 √ null
cc_address LONGTEXT 2147483647 √ null
from_address LONGTEXT 2147483647 √ null
reply_address LONGTEXT 2147483647 √ null
content_type MEDIUMTEXT 16777215 √ null
failure_code MEDIUMTEXT 16777215 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc message_id
borrowernumber Performance Asc borrowernumber
letter_fk Performance Asc letter_id
message_transport_type Performance Asc message_transport_type

Relationships

Close relationships within degrees of separation