like
Tables (3)
Like
- post_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME
- INDEX — idx_post_id
- user_id — BIGINT — NOT NULL
- user_id (user_id2) — BIGINT — Foreign key → User.user_id
- user_id (user_id3) — BIGINT — Foreign key → Post.user_id — NOT NULL
- post_id (post_id2) — BIGINT — Foreign key → Post.post_id
Post
- user_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Primary key
- content — TEXT — NOT NULL
- created_at — DATETIME
- user_id (user_id2) — BIGINT — Foreign key → User.user_id
User
- user_id — BIGINT — Primary key
- username — VARCHAR(50) — NOT NULL
- created_at — DATETIME