sns
Tables (6)
Comment
- comment_id — INT
- user_id — VARCHAR(20)
- post_title — VARCHAR(255)
- content — TEXT
Like
- like_id — INT
- user_id — VARCHAR(20)
- post_title — VARCHAR(255)
PersonalSavedPost
- saved_post_id — INT
- user_id — VARCHAR(20)
- post_title — VARCHAR(255)
- saved_at — TIMESTAMP
Post
- post_title — VARCHAR(255)
- user_id — VARCHAR(20)
- content — TEXT
- created_at — TIMESTAMP
- likes_count — INT
PostRank
- rank_id — INT
- post_title — VARCHAR(255)
- rank_type — VARCHAR(50)
- rank_score — DECIMAL(10, 2)
User
- user_id — VARCHAR(20)
- username — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255)