CREATE TABLE profiles (
    aturi VARCHAR(1024) PRIMARY KEY,
    cid VARCHAR(256) NOT NULL,
    did VARCHAR(256) NOT NULL,
    display_name VARCHAR(1024) NOT NULL,
    record JSON NOT NULL,
    updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW ()
);

CREATE INDEX idx_profiles_did ON profiles (did);