mail_resp


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
resp_attach.rn_id resp_attach_ibfk_1 R
resp_forward.rn_id resp_forward_ibfk_1 R
mn_id INT UNSIGNED 10 0
mail.id mail_resp_ibfk_1 R
resp_name VARCHAR 245 null
keystr VARCHAR 255 √ null
key_where enum('subj', 'body', 'no') 5 no
subject VARCHAR 255 √ null
reply_to VARCHAR 255 √ null
text MEDIUMTEXT 16777215 √ null
resp_on enum('false', 'true') 6 false
ans_freq INT 10 √ 10
mem_limit INT 10 √ 1000
content_type VARCHAR 245 text/plain
charset VARCHAR 245 UTF-8
apsServiceInstanceId INT UNSIGNED 10 0
endDate DATE 10 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
mn_id_resp_name Performance Asc/Asc mn_id + resp_name

Relationships

Close relationships within degrees of separation