-
Notifications
You must be signed in to change notification settings - Fork 0
Database Schema
JackPercival edited this page Sep 20, 2021
·
12 revisions
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
first_name | string | not null |
last_name | string | not null |
string | not null, unique | |
hashed_password | string | not null |
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
referencestags
table
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
name | string | not null |
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
referencesusers
table -
api_id
referencesapis
table
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
user_id | integer | not null, foreign key |
name | string | not null |
-
user_id
referencesusers
table
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
referencestoolboxes
table -
api_id
referencesapis
table