| 1 |
CREATE TABLE contact_revocations ( |
| 2 |
buyer_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE, |
| 3 |
seller_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE, |
| 4 |
revoked_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), |
| 5 |
PRIMARY KEY (buyer_id, seller_id) |
| 6 |
); |
| 7 |
|