sns project
Tables (9)
ACTIVITIES
- activity_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- from_user_id — INT — NOT NULL
- post_id — INT — NOT NULL
- type — ENUM('like') — NOT NULL
- created_at — DATETIME — NOT NULL
COMMENTS
- comment_id — INT — Primary key — NOT NULL
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- parent_comment_id — INT
- created_at — DATETIME — NOT NULL
COMMENT_TAGS
- comment_id — INT — NOT NULL
- tagged_user_id — INT — NOT NULL
FOLLOWERS
- follower_id — INT — Primary key — NOT NULL
- following_id — INT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
LIKES
- like_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- post_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
POSTS
- post_id — INT — Primary key — NOT NULL
- user_id (user_id2) — INT — Foreign key → USERS.user_id — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
POST_IMAGES
- image_id — INT — Primary key — NOT NULL
- post_id — INT — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- sort_order — INT
POST_TAGS
- post_id — INT — NOT NULL
- tagged_user_id — INT — NOT NULL
USERS
- user_id — INT — Primary key — NOT NULL
- userName — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- email — VARCHAR(100)
- pwd — VARCHAR(255) — NOT NULL
- birth — DATE
- profile_image — VARCHAR(255)
- nickname — VARCHAR(30)
- website — VARCHAR(255)
- bio — TEXT