woobeeblog

Tables (10)

category

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255)
  • parent_id — bigint — Foreign key → category.id — NOT NULL

comment

  • id — bigint — Primary key — NOT NULL
  • context — varchar(255)
  • created_at — datetime
  • deleted_at — datetime
  • modified_at — datetime
  • parent_id — bigint — Foreign key → comment.id — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • post_id — bigint — Foreign key → post.id — NOT NULL

image

  • id — bigint — Primary key — NOT NULL
  • url — varchar(255)
  • post_id — bigint — Foreign key → post.id — NOT NULL

like

  • id — bigint — Primary key — NOT NULL
  • status — varchar(255)
  • created_at — datetime
  • deleted_at — datetime
  • modified_at — datetime
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • post_id — bigint — Foreign key → post.id — NOT NULL

member

  • id — bigint — Primary key — NOT NULL
  • login_id — varchar(255)
  • password — varchar(255)
  • name — varchar(255)
  • email — varchar(255)
  • status — varchar(255)
  • auth — varchar(255)
  • created_at — datetime
  • deleted_at — datetime
  • modified_at — datetime

post

  • id — bigint — Primary key — NOT NULL
  • title — varchar(255)
  • context — text
  • status — varchar(255)
  • count — bigint
  • created_at — datetime
  • deleted_at — datetime
  • modified_at — datetime

postcategory

  • id — bigint — Primary key — NOT NULL
  • category_id — bigint — Foreign key → category.id — NOT NULL
  • post_id — bigint — Foreign key → post.id — NOT NULL
  • created_at — datetime
  • deleted_at — datetime
  • modified_at — datetime

posttag

  • id — bigint — Primary key — NOT NULL
  • tag_id — bigint — Foreign key → tag.id — NOT NULL
  • post_id — bigint — Foreign key → post.id — NOT NULL
  • created_at — datetime
  • deleted_at — datetime
  • modified_at — datetime

tag

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255)

visit

  • id — bigint — Primary key — NOT NULL
  • date — datetime
  • count — bigint