ERD PTW - dbdiagram.io

Table users {
  id_users int [pk, increment]
  fullname varchar
  email varchar
  password varchar
  role varchar
  email_verified boolean
  create_date datetime
  update_date datetime
}

Table rooms {
  id_rooms int [pk, increment]
  name varchar
  start_date datetime
  end_date datetime
  is_recording boolean
  is_start_meeting boolean
  is_join_before_host boolean
  create_date datetime
  update_date datetime
}

Table attendances {
  id_attendances int [pk, increment]
  id_rooms int
  id_users int
  create_date datetime
  update_date datetime
}

Table notification {
  id_notification int [pk, increment]
  id_users int
  type varchar
  sender varchar
  message varchar
  create_date datetime
  update_date datetime
}

Ref: "rooms"."id_rooms" < "attendances"."id_rooms"
Ref: "attendances"."id_users" < "users"."id_users"


Ref: "users"."id_users" < "notification"."id_users"