popo
Tables (6)
comment
- comment_id — int — Primary key — NOT NULL
- email — varchar(50) — Foreign key → user.email
- post_id — int — Foreign key → post.post_id — NOT NULL
- nickname — varchar(50) — Foreign key → user.nickname — NOT NULL
- content — varchar(300)
- created_at — datetime
- modified_at — datetime
notice
- ntice_id — int — Primary key — NOT NULL
- title — varchar(100)
- content — varchar(5000)
- created_at
- modified_at
post
- post_id — int — Primary key — NOT NULL
- email — varchar(50) — Foreign key → user.email
- nickname — varchar(50) — Foreign key → user.nickname — NOT NULL
- content — varchar(300)
- image_url — varchar(800)
- category — varchar(50)
- created_at — datetime
- modified_at — datetime
- like_count — int
user
- email — varchar(50) — Primary key
- nickname — varchar(50) — Primary key — NOT NULL
- password — varchar(200)
- phone — varchar(11)
- introduce — varchar(200)
- gender — enum
- profile_image — varchar(200)
- role — enum
- visit_count — int
- post_count — int
- follower_count — int
- following_count — int
user_follow
- follow_id — int — Primary key — NOT NULL
- follower — varchar(50) — Foreign key — NOT NULL — 팔로우를 신청한 user_id
- email — varchar(50) — Foreign key → user.email
- is_follow — tinyint — NOT NULL
user_post_like
- post_like_id — int — Primary key — NOT NULL
- post_id — int — Foreign key → post.post_id — NOT NULL
- email — varchar(50) — Foreign key → user.email
- is_liked — tinyint — NOT NULL