sns
Tables (6)
Comment
- comment_id — INT
- user_id — VARCHAR(20)
- post_title — VARCHAR(255)
- content — BLOB
Like
- like_id — INT
- user_id — VARCHAR(20)
- post_title — VARCHAR(255)
Post
- post_title — VARCHAR(255)
- user_id — VARCHAR(20)
- content — BLOB
- created_at — DATE
- likes_count — INT
PostRank
- rank_id — INT
- post_title — VARCHAR(255)
- rank_type — VARCHAR(50)
- rank_score — Number(10, 0)
SavedPost
- saved_post_id — INT
- user_id — VARCHAR(20)
- post_title — VARCHAR(255)
- saved_at — DATE
User
- user_id — VARCHAR(20)
- username — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255)