Database Schema

Users

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

APIs

column name	data type	details
id	integer	not null, primary key
name	string	not null
url	string	not null, unique
free	boolean	not null
description	string	not null
logo_url	string	not null
tags_id	integer	not null, foreign key

• tags_id references tags table

Tags

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

Reviews

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, foreign key
api_id	integer	not null, foreign key
review	text	not null
rating	integer	not null

• user_id references users table
• api_id references apis table

Toolboxes

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

• user_id references users table

Implementations

column name	data type	details
id	integer	not null, primary key
toolbox_id	integer	not null, foreign key
api_id	integer	not null, foreign key

• toolbox_id references toolboxes table
• api_id references apis table