Database Schema

Table Users {
  id int [pk, increment] // auto-increment
  username varchar
  createdAt timestamp
  updatedAt timestamp
}

Table Categories {
  id int [pk, increment] // auto-increment
  categoryName varchar
  createdAt timestamp
  updatedAt timestamp
}

Table Events {
  id int [pk, increment] // auto-increment
  title varchar
  eventBody text
  startTime datetime
  endTime datetime
  imgUrl varchar
  location varchar
  organizerName varchar
  ownerId int
  categoryId int
  createdAt timestamp
  updatedAt timestamp
 }
 
Table UserTickets {
  id int [pk, increment] // auto-increment
  userId int
  eventId int
  createdAt timestamp
  updatedAt timestamp
}

Table UserBookmarks {
  id int [pk, increment] // auto-increment
  userId int
  eventId int
  createdAt timestamp
  updatedAt timestamp
}

Ref: Events.ownerId > Users.id
Ref: Events.categoryId > Categories.id
Ref: UserTickets.userId > Users.id
Ref: UserBookmarks.userId > Users.id
Ref: UserTickets.eventId > Events.id
Ref: UserBookmarks.eventId > Events.id