aㅁㅁㅁ
Tables (6)
Comment (Untitled5)
- comment_id (Key) — long — Primary key — NOT NULL
- post_id (Key2) — long — Foreign key → Post.post_id — NOT NULL
- comment_contents (Field2) — string
- created_at (Field3) — date
Follow (Untitled2)
- follow_id (Key) — long — Primary key — NOT NULL
- follower_id (Key3) — User — Foreign key → User.user_id — NOT NULL
- following_id (Key2) — User — Foreign key → User.user_id — NOT NULL
- created_at (Field3) — date
Likes (Untitled)
- like_id (Key) — long — Primary key — NOT NULL
- user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
- post_id (Key3) — long — Foreign key → Post.post_id — NOT NULL
- created_at (Field) — date
Newsfeed (Untitled6)
- newsfeed_id (Key) — long — Primary key — NOT NULL
- user_id (Key7) — long — Foreign key → User.user_id — NOT NULL
- comment_id (Key3) — long — Foreign key → Comment.comment_id — NOT NULL
- like_id (Key4) — long — Foreign key → Likes.like_id — NOT NULL
- follow_id (Key5) — long — Foreign key → Follow.follow_id — NOT NULL
- post_id (Key6) — long — Foreign key → Post.post_id — NOT NULL
- created_at (Field4) — date
Post (Untitled4)
- post_id (Key) — long — Primary key — NOT NULL
- user_id (Key3) — long — Foreign key → User.user_id — NOT NULL
- post_title (Field2) — string
- post_contents (Field3) — string
- created_at (Field4) — date
- updated_at (Field5) — date
User (Untitled3)
- user_id (Key) — long — Primary key — NOT NULL
- user_email (Field) — string
- user_pwd (Field2) — string
- user_name (Field3) — string
- user_profile (Field4) — string
- user_intro (Field5) — string
- created_at (Field6) — date
- updated_at (Field7) — date