dream_re

Tables (13)

article (Untitled2)

  • title (Key) — String — Primary key — NOT NULL
  • fetchTime (Key2) — Number — Primary key — NOT NULL
  • pictUrl (Field) — String
  • path (Field2) — String
  • keywords (Field3) — List
  • is (Field4) — String

articleFetchtimeIndex (Untitled12)

  • is (Key) — Number — Primary key — NOT NULL
  • fetchTime (Field) — Number
  • title (Field2) — String
  • pictUrl (Field3) — String
  • path (Field4) — String

articleIndex (Untitled6)

  • keyword (Key) — String — Primary key — NOT NULL
  • listOfArticle (Field) — List — { "title": <>, "fetchTime":<>, "pictUrl": <>, "path": <> }

likeVisit (Untitled4)

  • email (Key) — String — Primary key — NOT NULL
  • visit (Key2) — String — Primary key — NOT NULL — "titleㅅㅁㅇwriter"
  • likedTime (Field2) — Number

nickname (Untitled8)

  • nickname (Key) — String — Primary key — NOT NULL

ps_email_validation (Untitled9)

  • email (Key) — String — Primary key — NOT NULL
  • state (Field) — Number
  • setTime (Field2) — Number
  • code (Field3) — String

readArticle (Untitled3)

  • email (Key) — String — Primary key — NOT NULL
  • article (Key2) — String — Primary key — NOT NULL — ' { "title": "", "fetchTime": } '
  • readTime (Field2) — Number

signup_email_validation (Untitled10)

  • email (Key) — String — Primary key — NOT NULL
  • state (Field) — Number
  • setTime (Field2) — Number
  • code (Field3) — String

sortVisit (Untitled11)

  • is (Key) — Number — Primary key — NOT NULL
  • writtenTime (Key2) — Number — Primary key — NOT NULL
  • title (Field) — String
  • writer (Field2) — String
  • tags (Field3) — List

user

  • email (Key) — String — Primary key — NOT NULL
  • name (title) — String
  • password (Field) — String
  • nickname (Field2) — String

userKeywords (Untitled)

  • email (Key) — String — Primary key — NOT NULL
  • seenArticle (Field) — List — ex) { "title":<>, "fetchTime": <> }
  • keyword1 (Field2) — Number
  • keyword2 (Field3) — Number

visit (Untitled5)

  • writer (Key) — String — Primary key — NOT NULL
  • title (Key2) — String — Primary key — NOT NULL
  • address (Field) — String
  • detailAddress (Field2) — String
  • content (Field3) — List — exmaple as below: [ { "type": "text", "content": "...." }, { "type":"spacer", }, { "type": "image", "content": "<image_…
  • writtenTime (Field4) — Number
  • readView (Field5) — Number
  • nickname (Field6) — String
  • tags (Field7) — List
  • is (Field8) — Number

visitTag (Untitled7)

  • tag (Key) — String — Primary key — NOT NULL
  • listOfVisit (Field) — List — { "title":<>, "writer":<>, "address": <>, "tags":["", "", ""], "writtenTime": "" }