DowaDream
DowaDream ERD
Tables (8)
Untitled (Review)
- Key (rid) — INT — Primary key — NOT NULL
- Field (title) — CHAR
- Field (content) — LONGTEXT
- Field (is_public) — TINYINT
- Field (tag) — CHAR
- Field (created_at) — DATETIME
- Field (updated_at) — DATETIME
- Key (uid) — INT — Foreign key → User.Key — NOT NULL
- Key (pid) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (Image)
- Key (image_id) — INT — Primary key — NOT NULL
- Field (image) — VARCHAR
- Key (rid) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (Comment)
- Key (cid) — INT — Primary key — NOT NULL
- Field (content) — LONGTEXT
- Field (created_at) — DATETIME
- Field (updated_at) — DATETIME
- Key (rid) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (uid) — INT — Foreign key → User.Key — NOT NULL
Untitled (Program)
- Key (pid) — INT — Primary key — NOT NULL
Untitled (User-Pro-CheerUp)
- Key (uid) — INT — Foreign key → User.Key — NOT NULL
- Key (pid) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (created_at) — DATETIME
Untitled (User-Pro-Participated)
- Key (uid) — INT — Foreign key → User.Key — NOT NULL
- Key (pid) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (created_at) — DATETIME
Untitled (User-Pro-Clipped)
- Key (uid) — INT — Foreign key → User.Key — NOT NULL
- Key (pid) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (created_at) — DATETIME
User
- Key (uid) — INT — Primary key — NOT NULL
- Field (username) — CHAR
- Field (email) — CHAR
- Field (profile_img) — VARCHAR
- Field (date_joined) — DATETIME
- Field (fighting) — INT
- Field (tags) — VARCHAR
- Field (regions) — VARCHAR