DB Schema

Users

Column Name	Data Type	Details
id	int	pk, not null
firstName	String(100)	Not Null
lastName	String(100)	Not Null
email	String(255)	Not Null
password	String(24)	Not Null
dob	datetime
cc Info	varchar(27)
address	varchar(100)
created_at	datetime	Not Null
updated_at	datetime	Not Null

Wishlist Item (same layout as cart)

Column Name	Data Type	Details
id	int	pk, Not Null
user_id	int	fk > users.id, Not Null
item.id	int	fk > items.id, Not Null
created_at	datetime	Not Null

Cart Item (same layout as wishlist)

Column Name	Data Type	Details
id	int	pk, Not Null
user_id	int	fk > users.id, Not Null
item.id	int	fk > items.id, Not Null
quantity	int	Not Null
created_at	datetime	Not Null

Reviews

Column Name	Data Type	Details
id	int	pk, Not Null
user_id	int	fk > users.id, Not Null
title	varchar(100	Not Null
content	varchar(1000)	Not Null
rating	int	Not Null
item.id	int	fk > items.id, Not Null
created_at	datetime	Not Null

ReviewLikes

Column Name	Data Type	Details
id	int	pk, Not Null
user_id	int	fk > users.id, Not Null
review_id	int	fk > reviews.id
like	boolean	Not Null

Item

Column Name	Data Type	Details
id	int	pk, Not Null
name	varchar(50)	Not Null
price	int	Not Null
size	varchar(50)	Not Null
gender	varchar(50)	Not Null
color	varchar(50)	Not Null
type	int	fk > item_types, Not Null
image	varchar(999)	Not Null
----------- clothes attr. ---------------------------
warmth	varchar(50)	-
waterproofing	varchar(50)	-
------------ boots attr. ----------------------------
lacing	varchar(50)	-
stiffness	varchar(50)	-
----------- bindings attr.---------------------------
response	varchar(50)	-
----------- boards attr. ----------------------------
personality	varchar(50)	-
terrain	varchar(50)	-

addl_item_images

| id | int | pk - | | item_id | int | fk > items - | | image | varchar(2000) | Not Null - |