Social
Tables (4)
Feed (Heart)
- tweet_id (heart_id) — VARCHAR(30) — Primary key — NOT NULL
- user_id — VARCHAR(15) — NOT NULL
- created_date — DATETIME — NOT NULL
Follow
- follower_id — VARCHAR(30) — NOT NULL
- follow_id — VARCHAR(30) — Foreign key → User.user_id — NOT NULL
Tweet
- tweet_id — BIGINT — Primary key — NOT NULL
- writer_id — VARCHAR(15) — NOT NULL
- content — VARCHAR(140) — NOT NULL
- created_date — DATETIME — NOT NULL
- user_id — VARCHAR(30) — Foreign key → User.user_id — NOT NULL
- heart_id — VARCHAR(30) — Foreign key → Feed.tweet_id — NOT NULL
User
- user_id — VARCHAR(30) — Primary key — NOT NULL
- password — VARCHAR(20) — NOT NULL
- profile_photo — BLOB
- header_photo — BLOB
- name — VARCHAR(20) — NOT NULL
- joined_date — DATETIME — NOT NULL