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