FindTrueMe
Tables (8)
Comment
- comment_id — int — Primary key — NOT NULL
- post_id (post_id2) — int — Foreign key → Post.post_id — NOT NULL
- user_id (user_id2) — int — Foreign key → User.user_id — NOT NULL
- parent_id — int — Foreign key → Comment.comment_id — NOT NULL
- content — varchar(30)
- like_count — int
- status — boolean
- created_at — timestamp
- updated_at — timestamp
Follow
- Table id (follow_id) — int — Primary key — NOT NULL
- following_id (user_id) — int — Foreign key → User.user_id — NOT NULL
- follwer_id (user_id2) — int — Foreign key → User.user_id — NOT NULL
- status — boolean
Hashtag
- hashtag_id — int — Primary key — NOT NULL
- hashtag_name — varchar(30)
- status — boolean
- created_at — timestamp
- updated_at — timestamp
Hashtag_Post
- hashtag_post_id — int — Primary key — NOT NULL
- post_id (post_id2) — int — Foreign key → Post.post_id — NOT NULL
- hashtag_id (hashtag_id2) — int — Foreign key → Hashtag.hashtag_id — NOT NULL
Image
- image_id — int — Primary key — NOT NULL
- post_id — int — Foreign key → Post.post_id — NOT NULL
- user_id — int — Foreign key → User.user_id — NOT NULL
- image_url — varchar(30)
- type — varchar(30)
- status — boolean
- created_at — timestamp
- updated_at — timestamp
Like_Post
- user_like_post_id (user_post_like_id) — int — Primary key — NOT NULL
- user_id (user_id2) — int — Foreign key → User.user_id — NOT NULL
- post_id (post_id2) — int — Foreign key → Post.post_id — NOT NULL
Post
- post_id — int — Primary key — NOT NULL
- user_id (user_id2) — int — Foreign key → User.user_id — NOT NULL
- title — varchar(30)
- content — varchar(30)
- status — boolean
- created_at — timestamp
- updated_at — timestamp
User
- user_id — int — Primary key — NOT NULL
- email — varchar(30)
- username — varchar(30)
- password — varchar(30)
- status — boolean
- created_at — timestamp
- updated_at — timestamp