Database Schema - lentzsch/Syphr GitHub Wiki

Table users {
  id int [pk, increment] // auto-increment
  codeName varchar
  email varchar
  avatar varchar
  hashedPassword varchar
  createdAt timestamp
  updatedAt timestamp
}

Table messages {
  id int [pk, increment]
  message text
  selfDestructDate date
  senderId int
  receiverId int
}



Ref: "users"."id" < "messages"."senderId"

Ref: "users"."id" < "messages"."receiverId"