Ket'says database

Tables (9)

Copy Of Untitled2 (Post_hashtags)

  • Key — UUID — Primary key — NOT NULL
  • Key (Key2) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field — timestamp — NOT NULL

Untitled (Posts)

  • Key — UUID — Primary key — NOT NULL
  • Key2 — UUID — Primary key — NOT NULL — The creator of the post
  • Field — TEXT — NOT NULL — There is no limit on the text length
  • Field2 — timestamp — NOT NULL
  • Field3 — timestamp
  • Field5 — Replicative business in a niche geographical area or new invention business
  • Field4 — timestamp

Untitled (Comments)

  • Key — UUID — Primary key — NOT NULL — Primary key
  • Key2 — UUID — Primary key — Foreign key
  • Key (Key3) — UUID — Foreign key → Untitled.Key — NOT NULL — Foreign key
  • Key2 (Key22) — UUID — Foreign key → Untitled.Key2 — NOT NULL — Also regist_charger
  • Field — TEXT — NOT NULL — Should set a max length
  • Field3 — timestamp — NOT NULL
  • Field5 — timestamp — NOT NULL
  • Field2 — timestamp

Untitled (Agree)

  • Key — UUID — Primary key — NOT NULL — The three keys form the primary key
  • Key2 — VARCHAR(20) — Primary key — NOT NULL — Can be a post or a comment
  • Key3 — UUID — Primary key — NOT NULL
  • Field4 — timestamp — NOT NULL
  • Field5 — bool — NOT NULL

Untitled (Follow)

  • Key4 — UUID — Primary key — NOT NULL
  • Key (Key2) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field3 — bool — NOT NULL
  • Field4 — timestamp — NOT NULL

Untitled (user_identities)

  • Key — Primary key — NOT NULL
  • Key2 — VARCHAR(30) — Primary key — NOT NULL
  • Key3 — VARCHAR(255) — Primary key — NOT NULL
  • Field — UUID — NOT NULL
  • Field2 — timestamp — NOT NULL — "Same as created at"

Untitled2 (User _hashtags(Interests))

  • Key — UUID — Primary key — NOT NULL
  • Key (Key2) — UUID — Foreign key → Users.Key — NOT NULL
  • Field — timestamp — NOT NULL

Untitled2 (Hashtags)

  • Key — UUID — Primary key — NOT NULL — This will be used to get all posts with "#sports" for example
  • Field — VARCHAR(50) — NOT NULL
  • Field2 — VARCHAR(50) — NOT NULL — This is to avoid duplicate hashtags with different spelling
  • Field3 — timestamp — NOT NULL

Users

  • Key — UUID — Primary key — NOT NULL
  • Field8 — VARCHAR(30) — NOT NULL — Should be "UNIQUE"
  • Field3 — VARCHAR(255) — NOT NULL — Should be "UNIQUE"
  • Field4 — VARCHAR(10)
  • Field5 — VARCHAR(100)
  • Field6 — TEXT — Same as hashtags, but displayed as "interest" to the user
  • Field7 — BOOLEAN — NOT NULL — Default to "false"
  • Field10 — timestamp — NOT NULL
  • Field12 — timestamp
  • Field9 — timestamp
  • Field11 — VARCHAR(30) — NOT NULL — Default "creator", user can select business account