Pixels Schema

pixels

Tracking pixel definitions (Facebook, Google, etc.).

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
name	text	NO	—
type	text	NO	—
pixel_id	text	NO	—
status	text	NO	'active'
metadata	jsonb	YES	'{}'
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

pixel_assignments

Pixels assigned to specific app resources.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
pixel_id	uuid	NO	—
user_id	uuid	NO	—
target_app	text	NO	—
target_id	uuid	NO	—
created_at	timestamptz	NO	now()