Database Schema

Database

users

column name	data type	details
id	integer	not null, primary key
name	string(30)	not null
email	string(250)	not null, unique
biography	text(2000)	nullable
profilePhoto	string(9999)	nullable
eventPhoto	string(9999)	nullable
hashedPassword	string.binary	not null
created_at	datetime	not null
updated_at	datetime	not null

events

column name	data type	details
id	integer	not null, primary key
name	string(50)	not null
details	string(9999)	nullable
date	date	not null
imgUrl	string	not null
userId	integer	not null, foreignKey
created_at	datetime	not null
updated_at	datetime	not null

comments

column name	data type	details
id	integer	not null, primary key
content	text(2000)	not null
userId	integer	not null, foreignKey
eventId	integer	not null, foreignKey
created_at	datetime	not null
updated_at	datetime	not null