publication_id BIGINT NOT NULL REFERENCES public.publications(id) ON DELETE CASCADE, profile_id UUID REFERENCES public.profiles(id) ON DELETE CASCADE, ...
CREATE TABLE user_profiles ( user_id UUID PRIMARY KEY, display_name TEXT, bio TEXT, avatar_url TEXT, level INTEGER DEFAULT 1, xp INTEGER DEFAULT 0 approval_expires_at timestamptz last_access_at ...