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)