PARSLEY

Tables (7)

Account

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (email) — varchar(255) — NOT NULL
  • Field (password) — varchar(255) — NOT NULL
  • Field (device_token) — varchar(255)
  • Field (refresh_token) — varchar(255)

Copy Of Untitled (AccountKeywordMapping)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Key (account_id) — bigint(20) — Foreign key → Account.Key — NOT NULL
  • Key (keyword_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL

Copy Of Untitled2 (KeywordPhraseMapping)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Key (keyword_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (phrase_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (Keyword)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (text) — varchar(255) — NOT NULL
  • Field (language) — varchar(255) — NOT NULL

Untitled (Phrase)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (text) — varchar(255) — NOT NULL

Untitled (Article)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Field (title) — varchar(255) — NOT NULL
  • Field (description) — varchar(255) — NOT NULL
  • Field (url) — varchar(255) — NOT NULL
  • Field (thumbnail) — varchar(255)
  • Field (category) — varchar(255) — NOT NULL
  • Field (brand) — varchar(255) — NOT NULL

WatchedList

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Key (article_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (account_id) — bigint(20) — Foreign key → Account.Key — NOT NULL
  • Field (count) — int — NOT NULL