max / goingson

466 B · 13 lines History Blame Raw

1	-- Custom fields for contacts: arbitrary label/value pairs with optional URL links.
2	-- Enables flexible per-contact metadata (e.g., Reddit username with profile URL).
3
4	CREATE TABLE contact_custom_fields (
5	id TEXT PRIMARY KEY NOT NULL,
6	contact_id TEXT NOT NULL REFERENCES contacts(id) ON DELETE CASCADE,
7	label TEXT NOT NULL,
8	value TEXT NOT NULL,
9	url TEXT
10	);
11
12	CREATE INDEX idx_contact_custom_fields_contact_id ON contact_custom_fields(contact_id);
13