r_requesttype

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
r_requesttype_id numeric 10 null
ad_userbpaccess.r_requesttype_id rrequesttype_aduserbpaccess C
cof_r_requesttypecategory.r_requesttype_id rrequesttype_cofrrequesttypeca R
cof_r_requesttypegroup.r_requesttype_id rrequesttype_cofrrequesttypegr R
k_index.r_requesttype_id rrequesttype_kindex C
k_indexstop.r_requesttype_id rrequesttype_kindexstop C
pa_measure.r_requesttype_id rrequesttype_pameasure R
r_request.r_requesttype_id rrequesttype_rrequest R
r_requestaction.r_requesttype_id rrequesttype_rrequestaction R
r_requestprocessor.r_requesttype_id rrequesttype_rrequestprocessor R
r_requestprocessor_route.r_requesttype_id rrequesttype_rprocessorrule R
r_requesttypeupdates.r_requesttype_id rrequesttype_rrtupdates R
r_requestupdate.r_requesttype_id rrequesttype_rrequestupdate R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
isdefault bpchar 1 'N'::bpchar
isselfservice bpchar 1 'Y'::bpchar
duedatetolerance numeric 10 7
isemailwhenoverdue bpchar 1 'N'::bpchar
isemailwhendue bpchar 1 'N'::bpchar
isinvoiced bpchar 1 √ null
autoduedatedays numeric 10 √ null
confidentialtype bpchar 1 'C'::bpchar
isautochangerequest bpchar 1 'N'::bpchar
isconfidentialinfo bpchar 1 'N'::bpchar
r_statuscategory_id numeric 10 null
r_statuscategory.r_statuscategory_id rstatuscategory_rrequesttype R
isindexed bpchar 1 'Y'::bpchar
r_requesttype_uu varchar 36 √ NULL::character varying
headercolor varchar 7 √ NULL::character varying
contentcolor varchar 7 √ NULL::character varying
ad_user_id numeric 10 √ NULL::numeric
ad_user.ad_user_id aduser_rrequesttype R
r_mailtext_id numeric 10 √ NULL::numeric
r_mailtext.r_mailtext_id rmailtext_rrequesttype R

Indexes

Constraint Name Type Sort Column(s)
r_requesttype_pkey Primary key Asc r_requesttype_id
r_requesttype_uu_idx Must be unique Asc r_requesttype_uu

Check Constraints

Constraint Name Constraint
r_requesttype_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation