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