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