sql schema

organizationSummaries
SELECT d.KEY, d.DATE, d.group_id, d.organization_id, d.DATA
FROM public.data_summaries AS d
WHERE (date_trunc('day', d.DATE) >= date_trunc('day', date_trunc('day', now()))) AND (d.organization_id = @__organizationId_0)

agents
SELECT a.id, a.category_id, a.created_at, a.datetime_end, a.datetime_start, a.duration, a.efficiency_id, a.machine_user_id, a.organization_id, a.group_id, a.tracked_id, a.updated_at
FROM organization_17.agent_collectors AS a
WHERE date_trunc('day', a.datetime_start) >= date_trunc('day', date_trunc('day', now()))

get_machine users
SELECT m.id, m.active, m.agent_version, m.alias, m.collect_logs, m.created_at, m.DOMAIN, m.email, m.generated_by_ad, m.IGNORE, m.last_activity, m.organization_id, m.pending_revision_ad, m.group_id, m.token, m.updated_at, m.username
FROM organization_17.machine_users AS m
WHERE m.active

agentCollectors =
-- @__user_Id_0='10685' (Nullable = true)
SELECT a.id, a.category_id, a.created_at, a.datetime_end, a.datetime_start, a.duration, a.efficiency_id, a.machine_user_id, a.organization_id, a.group_id, a.tracked_id, a.updated_at
FROM organization_17.agent_collectors AS a
WHERE (a.datetime_start >= date_trunc('day', now())) AND (a.machine_user_id = @__user_Id_0)

team  GROUP
-- @__user_Id_0='10685' (Nullable = true)
SELECT a.id, a.category_id, a.created_at, a.datetime_end, a.datetime_start, a.duration, a.efficiency_id, a.machine_user_id, a.organization_id, a.group_id, a.tracked_id, a.updated_at
FROM organization_17.agent_collectors AS a
WHERE (a.datetime_start >= date_trunc('day', now())) AND (a.machine_user_id = @__user_Id_0)

USER mood
-- @__user_Id_0='10620'
SELECT m.id, m.datetime_start, m.group_id, m.machine_user_id, m.mood
FROM organization_17.moods AS m
WHERE (m.machine_user_id = @__user_Id_0) AND (date_trunc('day', m.datetime_start) = date_trunc('day', date_trunc('day', now())))

GET USER ok
SELECT m.id, m.datetime_start, m.group_id, m.machine_user_id, m.mood
FROM organization_17.moods AS m
WHERE (m.mood = 1) AND (m.datetime_start >= date_trunc('day', now()))

GET USER sad
SELECT m.id, m.datetime_start, m.group_id, m.machine_user_id, m.mood
FROM organization_17.moods AS m
WHERE (m.mood = 0) AND (m.datetime_start >= date_trunc('day', now()))

GET USER happy
SELECT m.id, m.datetime_start, m.group_id, m.machine_user_id, m.mood
FROM organization_17.moods AS m
WHERE (m.mood = 2) AND (m.datetime_start >= date_trunc('day', now()))