new_daily_alarm

Tables (3)

Untitled (Notification)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Field (title) — VARCHAR(255)
  • Field (content) — VARCHAR(255)
  • Field (url) — VARVAHAR(255)
  • Field (created_time) — DATETIME

Untitled (User)

  • Key (id) — INT(11) — Primary key — NOT NULL

Untitled (Notification - User)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Key (target_user) — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
  • Key (notification) — INT(11) FK — Foreign key → Untitled.Key — NOT NULL
  • Field (is_viewed) — BOOLEAN
  • Field (viewed_time) — DATETIME
  • Field (deleted) — BOOLEAN
  • Field