Database Setup

PSQL Database Schema

users

Column Name	Datatype	Constraints
username	TEXT	not null
email	TEXT	not null
password	TEXT	not null
phone_number	TEXT	not null
is_artist	BOOLEAN	not null
is_gallery	boolean	not null

artwork

Column Name	Datatype	Constraints
title.	TEXT	not null
artist_id	INT	not null
image.	TEXT	not null.

artist_request

Column Name	Datatype	Constraints
artist_id	INT	not null
owner_id	INT	not null
gallery_id	INT	not null
message	TEXT	not null

galleries

Column Name	Datatype	Constraints
name	TEXT	not null
owner_id	INT	not null
address	TEXT	not null

gallery_request

Column Name	Datatype	Constraints
artist_id	INT	not null
owner_id	INT	not null
gallery_id	INT	not null
message	TEXT	not null

gallery_images

Column Name	Datatype	Constraints
gallery_id	INT	not null
photo_url	TEXT	not null