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