rv_requestupdates

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

isactive

bpchar

√

null

created

timestamp

29,6

√

null

createdby

numeric

√

null

updated

timestamp

29,6

√

null

updatedby

numeric

√

null

r_request_id

numeric

√

null

r_request.r_request_id

Implied Constraint

ad_user_id

numeric

√

null

isselfservice

bpchar

2147483647

√

null

r_group_id

numeric

√

null

r_requesttype_id

numeric

√

null

r_category_id

numeric

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT r_requestupdates.ad_client_id,
    r_requestupdates.ad_org_id,
    r_requestupdates.isactive,
    r_requestupdates.created,
    r_requestupdates.createdby,
    r_requestupdates.updated,
    r_requestupdates.updatedby,
    r_requestupdates.r_request_id,
    r_requestupdates.ad_user_id,
    r_requestupdates.isselfservice,
    NULL::numeric AS r_group_id,
    NULL::numeric AS r_requesttype_id,
    NULL::numeric AS r_category_id
   FROM r_requestupdates
UNION
 SELECT u.ad_client_id,
    u.ad_org_id,
    u.isactive,
    u.created,
    u.createdby,
    u.updated,
    u.updatedby,
    r.r_request_id,
    u.ad_user_id,
    u.isselfservice,
    r.r_group_id,
    NULL::numeric AS r_requesttype_id,
    NULL::numeric AS r_category_id
   FROM (r_groupupdates u
     JOIN r_request r ON ((u.r_group_id = r.r_group_id)))
UNION
 SELECT u.ad_client_id,
    u.ad_org_id,
    u.isactive,
    u.created,
    u.createdby,
    u.updated,
    u.updatedby,
    r.r_request_id,
    u.ad_user_id,
    u.isselfservice,
    NULL::numeric AS r_group_id,
    r.r_requesttype_id,
    NULL::numeric AS r_category_id
   FROM (r_requesttypeupdates u
     JOIN r_request r ON ((u.r_requesttype_id = r.r_requesttype_id)))
UNION
 SELECT u.ad_client_id,
    u.ad_org_id,
    u.isactive,
    u.created,
    u.createdby,
    u.updated,
    u.updatedby,
    r.r_request_id,
    u.ad_user_id,
    u.isselfservice,
    NULL::numeric AS r_group_id,
    NULL::numeric AS r_requesttype_id,
    r.r_category_id
   FROM (r_categoryupdates u
     JOIN r_request r ON ((u.r_category_id = r.r_category_id)))
UNION
 SELECT r_request.ad_client_id,
    r_request.ad_org_id,
    r_request.isactive,
    r_request.created,
    r_request.createdby,
    r_request.updated,
    r_request.updatedby,
    r_request.r_request_id,
    r_request.ad_user_id,
    r_request.isselfservice,
    NULL::numeric AS r_group_id,
    NULL::numeric AS r_requesttype_id,
    NULL::numeric AS r_category_id
   FROM r_request
  WHERE (r_request.ad_user_id IS NOT NULL)
UNION
 SELECT u.ad_client_id,
    u.ad_org_id,
    u.isactive,
    u.created,
    u.createdby,
    u.updated,
    u.updatedby,
    r.r_request_id,
    u.ad_user_id,
    NULL::bpchar AS isselfservice,
    NULL::numeric AS r_group_id,
    NULL::numeric AS r_requesttype_id,
    r.r_category_id
   FROM (ad_user u
     JOIN r_request r ON ((u.ad_user_id = r.salesrep_id)))
UNION
 SELECT r.ad_client_id,
    r.ad_org_id,
    u.isactive,
    r.created,
    r.createdby,
    r.updated,
    r.updatedby,
    r.r_request_id,
    u.ad_user_id,
    NULL::bpchar AS isselfservice,
    NULL::numeric AS r_group_id,
    NULL::numeric AS r_requesttype_id,
    NULL::numeric AS r_category_id
   FROM (r_request r
     JOIN ad_user_roles u ON ((u.ad_role_id = r.ad_role_id)));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views