Database Schema

Users

Column Name	Data Type	Details
ID	Int	Not Null, Primary
username	String(16)	Not Null
profile-picture	String(2000)	Not Null
email	String(255)	Not Null
firstname	String(50)	Not Null
lastname	String(50)	Not Null
password	String(24)	Not Null
created_at	Date	Not Null

Follows (Helper Table)

Column Name	Data Type	Details
ID	Int	Not Null, Primary
follower	Int	Not Null, (FK:references Users.id)
followed	Int	Not Null, (FK:references Users.id)
created_at	Date	Not Null

Inks

Column Name	Data Type	Details
Id	Int	Not Null, Primary
creator	Int	Not Null, (fk:references Users)
image	string(2000)	Not Null,
title	string(100)	Not Null,
subtitle	string(500)
destination_link	string(2000)
categoty_1	Int	(fk:references categories)
category_2	Int	(fk:references categories)
category_3	Int	(fk:references categories)
created_at	Date	Not Null
updated_at	Date	Not Null

Canvases

Column Name	Data Type	Details
Id	Int	Not Null, Primary
creator	Int	Not Null, (fk:references Users)
name	string(100)	Not Null
private_canvas	Boolean	Not Null
created_at	Date	Not Null
updated_at	Date	Not Null

InksOnCanvases

Column Name	Data Type	Details
Id	Int	Not Null, Primary
canvas_id	Int	Not Null, (fk:references Canvas)
ink_id	Int	Not Null, (fk:references Inks)
created_at	Date	Not Null
updated_at	Date	Not Null

Categories

Column Name	Data Type	Details
Id	Int	Not Null, Primary
category	string(100)	Not Null

::: static values in the category table :::
portrait
lettering
geometric
minimalist
traditional_jap
traditional_amer
tribal
linework
watercolor
illustrative