Smashing_COP

Tables (6)

COMMENT (Untitled7)

  • id (Key3) — varchar(50) — Primary key — NOT NULL
  • post_id (Key) — varchar(50) — Foreign key → POST.post_id — NOT NULL
  • poster (Key32) — Foreign key → POST.poster — NOT NULL
  • comment (Field) — varchar(1000)
  • sentiment (Field2)

POST (Untitled5)

  • post_id (Key) — varchar(50) — Primary key — NOT NULL
  • poster (Key3) — Primary key — NOT NULL
  • username (Key2) — varchar(50) — Foreign key → USER.username — NOT NULL
  • img (Field2) — varchar(200)
  • n_comment (Field3) — int(11)
  • n_likes (Field4) — int(11)
  • datetime (Field5) — datetime

POST_LIKE (Untitled6)

  • post_id (Key) — varchar(50) — Foreign key → POST.post_id — NOT NULL
  • poster (Key3) — Foreign key → POST.poster — NOT NULL
  • like_username (Field3) — varchar(50)

USER (Untitled)

  • username (Key) — varchar(50) — Primary key — NOT NULL

USER_FOLLOWER (Untitled2)

  • username (Field) — varchar(50)
  • follower_name (Field2) — varchar(50)
  • Field3

USER_POST (Untitled4)

  • username (Key) — varchar(50) — Foreign key → USER.username — NOT NULL
  • post_id (Key2) — varchar(50) — Foreign key → POST.post_id — NOT NULL