demo
Tables (8)
Untitled (Category)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (date_created) — datetime — NOT NULL
- Field (name) — varchar(255) — NOT NULL
Untitled (Comment)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (article_id) — bigint(20) — Foreign key → article.Key — NOT NULL
- Field (content) — varchar(100) — NOT NULL
- Field (date_created) — datetime — NOT NULL
- Field (date_updated) — datetime — NOT NULL
- Key (parent_id) — bigint(20) — Foreign key → Untitled.Key
article
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (author_id) — bigint(20) — Foreign key → user.Key — NOT NULL
- Key (category_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar(255) — NOT NULL
- Field (content) — varchar(1000) — NOT NULL
- Field (view_count) — int — NOT NULL
- Field (date_created) — datetime — NOT NULL
- Field (date_updated) — datetime — NOT NULL
file
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (article_id) — bigint(20) — Foreign key → article.Key — NOT NULL
- Field (file_url) — varchar(100) — NOT NULL
goodbad
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (user_id) — bigint(20) — Foreign key → user.Key — NOT NULL
- Key (article_id) — bigint(20) — Foreign key → article.Key — NOT NULL
- Field (is_good) — varchar(255) — NOT NULL
match
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (author_id) — bigint(20) — Foreign key → user.Key — NOT NULL
- title — varchar(200)
- time — datetime
- address — varchar(200)
- price — int
- info — varchar(200)
- status — varchar(200)
- link — varchar(200)
- sex — int
- Field (type) — varchar(50)
reservation (CopyOfmatch)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (applier_id) — bigint(20) — Foreign key → match.Key — NOT NULL
- Key (match_id) — bigint(20) — Foreign key → user.Key — NOT NULL
user (User)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (role) — varchar(255) — NOT NULL
- Field (email) — varchar(255) — NOT NULL
- Field (username) — varchar(15) — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- Field (date_created) — datetime — NOT NULL
- Field (status) — varchar(255) — NOT NULL