fgh

Tables (7)

chat\_room

  • room\_id — SERIAL
  • room\_type — VARCHAR(20) — NOT NULL
  • created\_at — TIMESTAMP — NOT NULL

chat\_room\_member

  • room\_id — INT — Primary key — NOT NULL
  • user\_id — INT — Primary key — NOT NULL
  • joined\_at — TIMESTAMP — NOT NULL
  • last\_read\_message\_id — INT

friend\_request

  • request\_id — SERIAL
  • sender\_id — INT — NOT NULL
  • receiver\_id — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created\_at — TIMESTAMP — NOT NULL
  • responded\_at — TIMESTAMP

friendship

  • user\_id — INT — Primary key — NOT NULL
  • friend\_id — INT — Primary key — NOT NULL
  • since — DATE — NOT NULL

message

  • message\_id — SERIAL
  • room\_id — INT — NOT NULL
  • sender\_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • message\_type — VARCHAR(20) — NOT NULL
  • created\_at — TIMESTAMP — NOT NULL

profile

  • profile\_id — SERIAL
  • user\_id — INT — NOT NULL
  • profile\_img\_url — VARCHAR(2083)
  • background\_img\_url — VARCHAR(2083)
  • status\_message — VARCHAR(255)
  • updated\_at — TIMESTAMP — NOT NULL

users

  • user\_id — SERIAL
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password\_hash — VARCHAR(255) — NOT NULL
  • created\_at — TIMESTAMP — NOT NULL
  • last\_login — TIMESTAMP