week_07_weibo_clonecoding

Tables (4)

comment (Untitled3)

  • comment_id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → post.post_id — NOT NULL
  • user_id (Key22) — Foreign key → post.user_id — NOT NULL
  • contents (Field)
  • created_at (Field2)

like (Untitled4)

  • like_id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → post.post_id — NOT NULL
  • user_id (Key22) — Foreign key → post.user_id — NOT NULL

post (Untitled2)

  • post_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • imagefilename (Field)
  • contents (Field2)
  • created_at (Field3)
  • comment_count (Field4)
  • like_count (Field5)

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • userprofileimage (Field3)