ticket_updates

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null

primary key

ticket_id INT 10 null
tickets.id ticket_updates_ibfk_1C

id of catalog ticket the update relates to

user_id INT 10 0
borrowers.borrowernumber ticket_updates_ibfk_2C

id of the user who logged the update

public BIT 0 0

boolean flag to denote whether this update is public

date TIMESTAMP 19 current_timestamp()

date and time this update was logged

message TEXT 65535 null

update message content

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ticket_updates_ibfk_1 Performance Asc ticket_id
ticket_updates_ibfk_2 Performance Asc user_id

Relationships