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"
Comments