mytly
Tables (3)
DailyEngagement (DAILY_ENGAGEMENT)
- id — BIGINT UNSIGNED — Primary key — NOT NULL — UNIQUE
- urlId (url_id) — BIGINT UNSIGNED — Foreign key → Url.id — NOT NULL — UNIQUE
- date (engage_date) — DATE — NOT NULL
- count (engage_count) — MEDIUMINT UNSIGNED — NOT NULL
RefererEngagement (REFERER_ENGAGEMENT)
- id — BIGINT UNSIGNED — Foreign key → Url.id — NOT NULL — UNIQUE
- direct — MEDIUMINT UNSIGNED — NOT NULL
- other — MEDIUMINT UNSIGNED — NOT NULL
- google — MEDIUMINT UNSIGNED — NOT NULL
Url (URL)
- id — BIGINT UNSIGNED — Primary key — NOT NULL — UNIQUE
- shortened — VARCHAR(255) — NOT NULL — UNIQUE
- original — VARCHAR(255) — NOT NULL
- status (url_status) — VARCHAR(255) — NOT NULL
- createdAt (created_at) — TIMESTAMP — NOT NULL
- isExpirable (expirable_yn) — TINYINT(1) — NOT NULL
- expireAt (expire_at) — TIMESTAMP