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