dream
Tables (8)
article
- title — String — Primary key — NOT NULL
- fetchTime — Number — Primary key — NOT NULL
- imageUrl — String
- publishDate — String
- path — String
- keywords — List Of String
nickname
- email — String — Foreign key → user.email — NOT NULL
- Field
ps_email_validation
- email — String — Primary key — NOT NULL
- state — Number
- setTime — Number
- code — String
- email (email2) — String — Foreign key → user.email — NOT NULL
readArticle
- reader (email) — String — Primary key — NOT NULL
- article (title$fetchTime) — String — Primary key — NOT NULL
- readTime — Number
- imageUrl — String
- email (email2) — String — Foreign key → user.email — NOT NULL
- title (title2) — String — Foreign key → article.title — NOT NULL
- fetchTime (fetchTime2) — Number — Foreign key → article.fetchTime — NOT NULL
readVisit
- reader (email) — String — Primary key — NOT NULL
- visit (writer$createdTime) — String — Primary key — NOT NULL — it is a combination of writer and createdTime from visit table format: writer:createdTime
- lastReadTime — Number
- like — Bool
- address — String
- type — String
- tags — List of String
- title — String
- nickname — String
- writer (email2) — String — Foreign key → visit.writer — NOT NULL — it is email from user table
- createdTime (createdTime2) — Number — Foreign key → visit.createdTime — NOT NULL
signup_email_validation
- email — String — Primary key — NOT NULL
- state — Number
- setTime (Field) — Number
- code — String
- email (email2) — String — Foreign key → user.email — NOT NULL
user
- email — String — Primary key — NOT NULL
- name — String
- password — String
- nickname — String
visit
- writer (email) — String — Primary key — NOT NULL — it is email from user table
- createdTime — Number — Primary key — NOT NULL
- address — String
- type — String
- tags — List of String
- title — String
- content — List of Json — exmaple as below: [ { "type": "text", "content": "...." }, { "type":"spacer", }, { "type": "image", "content": "<image_…
- nickname — String
- numbRead — Number
- email (email2) — String — Foreign key → user.email — NOT NULL