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