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": "" }