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