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