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_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

current_timestamp()

to_address

LONGTEXT

2147483647

√

null

from_address

LONGTEXT

2147483647

√

null

content_type

MEDIUMTEXT

16777215

√

null

Showing 1 to 12 of 12 entries

Table contained 0 rows

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