Boolog_MyBatis

Tables (4)

Untitled (member)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (email) — varchar — NOT NULL
  • Field (password) — varchar — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (picture) — varchar
  • Field (introduction) — varchar
  • Field (provider) — varchar
  • Field (provider_id) — varchar
  • Field (role) — varchar — NOT NULL
  • Field (reg_date) — datetime — NOT NULL

Untitled (post)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (thumbnail) — varchar
  • Field (title) — varchar — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (liked) — int — NOT NULL
  • Field (tags) — varchar
  • Field (created_date) — datetime — NOT NULL
  • Field (modified_date) — datetime — NOT NULL

Untitled (liked_posts)

  • Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (tag)

  • Key (tag_name) — varchar — Primary key — NOT NULL
  • Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL