Users

column name	data type	details
id	integer	not null, PK
userName	string(50)	not null, unique
email	string(255)	not null, unique
hashedPassword		not null
createdAt	date	not null
updatedAt	date	not null

• User hasMany Registration
• User hasMany Event

Events

column name	datatype	details
id	integer	not null, PK
hostId	string(255)	not null
categoryId	int	not null
name	varchar	not null
image	string	not null
date	datetime	not null
address	string(255)	not null
city	string(255)	not null
state	string(255)	not null
capacity	int	not null
createdAt	date	not null
updatedAt	date	not null

• Events belongsTo User
• Events hasMany Registration
• Events belongsTo Categories

Registration

column name	datatype	details
id	integer	not null, PK
userId	integer	not null
eventId	integer	not null
createdAt	date	not null
updatedAt	date	not null

• Registration belongsTo User
• Registration belongTo Events

Categories

column name	datatype	details
id	integer	not null, PK
type	varchar	not null
createdAt	date	not null
updatedAt	date	not null

• Categories hasMany Events