FAKEBOOK

Tables (6)

Feeds (Untitled5)

  • feed_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → Users.user_id — NOT NULL
  • contents (Field)
  • feed_date (Field2)

Users (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • username (Key3)
  • email (Field2)
  • password (Field)
  • profile_image (Field3)
  • regist_date (Field4)
  • id_deleted (Field5)
  • deleted_date (Field6)

comments (Untitled2)

  • comment_id (Key) — Primary key — NOT NULL
  • user_id (Key3) — Foreign key → Users.user_id — NOT NULL
  • feed_id (Key2) — Foreign key → Feeds.feed_id — NOT NULL
  • contents (Field)
  • feed_date (Field2)

friends (Untitled4)

  • to_user_id (Key2) — Primary key — NOT NULL
  • from_user_id (Key3) — Primary key — NOT NULL
  • to_user_id (Field)
  • friend_date (Field2)

likes (Untitled3)

  • like_id (Key3) — Primary key — NOT NULL
  • user_id (Key) — Foreign key → Users.user_id — NOT NULL
  • feed_id (Key2) — Foreign key → Feeds.feed_id — NOT NULL

reports (Untitled6)

  • report_id (Key3) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → Users.user_id — NOT NULL
  • report_content (Key) — NOT NULL
  • reported_time (Field)