intake_attachment


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
ticket_id BIGINT 19 null
intake.id fk_intake_attachment_intake R
field_id BIGINT 19 null
intake_field.id fk_intake_attachment_field R
user_id INT 10 √ null
sys_users.user_id fk_intake_attachment_user R
name VARCHAR 256 √ null
size BIGINT 19 √ null
timestamp DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_intake_attachment_field_idx Performance Asc field_id
fk_intake_attachment_intake_idx Performance Asc ticket_id
fk_intake_attachment_user_idx Performance Asc user_id

Relationships

Close relationships within degrees of separation