post
Tables (3)
comment (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- post_id (Key2) — bigint — Foreign key → post.id — NOT NULL
- member_id (Key3) — bigint — Foreign key → member.id — NOT NULL
- comment_content (Field) — varchar(200)
- comment_like (Field2) — bigint
- create_at (Field3) — datetime
member (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- email (Field) — varchar(40)
- password (Field2) — varchar(60)
- create_at (Field3) — datetime
post (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
- title (Field2) — varchar(50)
- content (Field3) — text
- view_count (Field4) — bigint
- like_count (Field5) — bigint
- bad_count (Field6) — bigint
- created_at (Field) — datetime