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