message_queue - testsql_comments Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

message_id

INT

10

√

null

borrowernumber

INT

10

√

null

borrowers.borrowernumber

messageq_ibfk_1C

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_2R

status

enum('sent', 'pending', 'failed', 'deleted')

7

pending

time_queued

TIMESTAMP

19

√

null

updated_on

TIMESTAMP

19

CURRENT_TIMESTAMP

Showing 1 to 10 of 15 entries

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees