evaluations

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

registration_id

int4

√

null

registration_sent_timestamp

timestamp

29,6

√

null

registration_number

varchar

√

null

registration_category

varchar

255

√

null

registration_agent_id

int4

√

null

opportunity_id

int4

√

null

valuer_user_id

int4

√

null

valuer_agent_id

int4

√

null

evaluation_id

int4

√

null

evaluation_result

text

2147483647

√

null

evaluation_status

int2

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT evaluations_view.registration_id,
    evaluations_view.registration_sent_timestamp,
    evaluations_view.registration_number,
    evaluations_view.registration_category,
    evaluations_view.registration_agent_id,
    evaluations_view.opportunity_id,
    evaluations_view.valuer_user_id,
    evaluations_view.valuer_agent_id,
    max(evaluations_view.evaluation_id) AS evaluation_id,
    max((evaluations_view.evaluation_result)::text) AS evaluation_result,
    max(evaluations_view.evaluation_status) AS evaluation_status
   FROM ( SELECT r.id AS registration_id,
            r.sent_timestamp AS registration_sent_timestamp,
            r.number AS registration_number,
            r.category AS registration_category,
            r.agent_id AS registration_agent_id,
            re.user_id AS valuer_user_id,
            u.profile_id AS valuer_agent_id,
            r.opportunity_id,
            re.id AS evaluation_id,
            re.result AS evaluation_result,
            re.status AS evaluation_status
           FROM ((registration r
             JOIN registration_evaluation re ON ((re.registration_id = r.id)))
             JOIN usr u ON ((u.id = re.user_id)))
          WHERE (r.status > 0)
        UNION
         SELECT r2.id AS registration_id,
            r2.sent_timestamp AS registration_sent_timestamp,
            r2.number AS registration_number,
            r2.category AS registration_category,
            r2.agent_id AS registration_agent_id,
            p2.user_id AS valuer_user_id,
            u2.profile_id AS valuer_agent_id,
            r2.opportunity_id,
            NULL::integer AS evaluation_id,
            NULL::character varying AS evaluation_result,
            NULL::smallint AS evaluation_status
           FROM (((registration r2
             JOIN pcache p2 ON (((p2.object_id = r2.id) AND (p2.object_type = 'MapasCulturais\Entities\Registration'::object_type) AND (p2.action = 'evaluateOnTime'::permission_action))))
             JOIN usr u2 ON ((u2.id = p2.user_id)))
             JOIN evaluation_method_configuration emc ON ((emc.opportunity_id = r2.opportunity_id)))
          WHERE (r2.status > 0)) evaluations_view
  GROUP BY evaluations_view.registration_id, evaluations_view.registration_sent_timestamp, evaluations_view.registration_number, evaluations_view.registration_category, evaluations_view.registration_agent_id, evaluations_view.valuer_user_id, evaluations_view.valuer_agent_id, evaluations_view.opportunity_id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views