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)