Database Schema

Database Schema

users

column	data type	details
id	integer	not null, primary key
name	string	not null, unique
username	string	not null, unique
email	string	not null, unique
hashed_password	string	not null

tickets

column	data type	details
id	integer	not null, primary key
item_name	string	not null
location	string	not null
description	string	not null
department_id	integer	not null, foreign key
owner_id	integer	not null, foreign key

• department_id references departments table
• owner_id references users table

departments

column	data type	details
id	integer	not null, primary key
name	string	not null

messages

column	data type	details
id	integer	not null, primary key
content	string	not null
owner_id	integer	not null, foreign key
ticket_id	integer	not null, foreign key

• owner_id references users table
• ticket_id references tickets table