todo
Tables (9)
categories
- id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
followers
- id — INT — Primary key
- follower_id — INT — NOT NULL
- followee_id — INT — NOT NULL
hashtags
- id — INT — Primary key
- tag — VARCHAR(100) — NOT NULL
likes
- id — INT — Primary key
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
posts
- id — INT — Primary key
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- time — DATETIME — NOT NULL
- like_count — INT — NOT NULL
- view_count — INT — NOT NULL
- author_id — INT — NOT NULL
posts_hashtags
- id — INT — Primary key
- post_id — INT — NOT NULL
- hashtag_id — INT — NOT NULL
reports
- id — INT — Primary key
- user_id — INT — NOT NULL
- post_id — INT — NOT NULL
- reason — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
users
- 사용자아이디 (id) — INT — Primary key
- 이메일 (email) — VARCHAR(255) — NOT NULL
- 패스워드 (password_hash) — VARCHAR(255) — NOT NULL
- 이름 (name) — VARCHAR(100) — NOT NULL
- 나이 (age) — TINYINT
views
- id — INT — Primary key
- post_id — INT — NOT NULL
- user_id — INT