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