database_ER_diagrams.md

Database

ER diagrams

AUTH DB

---
title: ER diagram(AUTH DB)
---
erDiagram

ROLE {
  INT id PK "Auto"
  VARCHAR(50) name UK "NOT NULL"
  TIMESTAMPTZ created_at "Auto"
}

RESOURCE {
  INT id PK "Auto"
  VARCHAR(50) name UK "NOT NULL"
  TIMESTAMPTZ created_at "Auto"
}

ACCESS_CONTROL {
  INT role_id PK, FK "NOT NULL"
  INT resource_id PK, FK "NOT NULL"
  BOOLEAN readable "NOT NULL"
  BOOLEAN writable "NOT NULL"
  TIMESTAMPTZ created_at "Auto"
}

USER {
  INT id PK "Auto"
  VARCHAR(50) email UK "NOT NULL"
  CHAR(44) pw
  CHAR(16) salt
  INT role_id FK "NOT NULL"
  TEXT surname
  TEXT given_name
  TIMESTAMPTZ last_login
  TIMESTAMPTZ created_at "Auto"
}

REFRESH_TOKEN {
  INT user_id PK, FK "NOT NULL"
  TEXT device PK "NOT NULL"
  CHAR(44) token
  TIMESTAMPTZ created_at "Auto"
}

ROLE ||--o{ ACCESS_CONTROL : ""
RESOURCE ||--o{ ACCESS_CONTROL : ""

USER }o--|| ROLE : ""
USER ||--o{ REFRESH_TOKEN : ""

Loading

Push Notification DB

---
title: ER diagram(Push Notification DB)
---
erDiagram

TOPIC {
  INT id PK "Auto"
  VARCHAR(50) name UK "NOT NULL"
  TIMESTAMPTZ created_at "Auto"
}

SUBSCRIPTION {
  INT id PK "Auto"
  TEXT sub UK "NOT NULL"
  INT topic_id FK "NOT NULL"
  TIMESTAMPTZ created_at "Auto"
}

TOPIC ||--o{ SUBSCRIPTION : ""

Loading