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