hotlist table

hotlist Table (363)

The table is used by the hotlist to store the relationship between tickets and users

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
user_id	The reference to the user.	FK ejuser	No
ticket_id	The ticket the user what to have in his hotlist	FK ticket	No

Fields	Types	Description
user_id	FK	Index
ticket_id	FK	Index

Table	Description
ejuser	This table contains entries for the users of the system.
ticket	This table contains the tickets (requests) of the system. Its purpose should be evident.