| 1 | -- Followers: a user following another user. Public. |
| 2 | CREATE TABLE follows ( |
| 3 | id TEXT PRIMARY KEY, |
| 4 | follower_id TEXT NOT NULL REFERENCES users(id) ON DELETE CASCADE, |
| 5 | followee_id TEXT NOT NULL REFERENCES users(id) ON DELETE CASCADE, |
| 6 | created_at BIGINT NOT NULL |
| 7 | ); |
| 8 | CREATE UNIQUE INDEX idx_follows_pair ON follows (follower_id, followee_id); |
| 9 | CREATE INDEX idx_follows_followee ON follows (followee_id); |