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
borrower_attribute_types.code Implied Constraint R
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