r_request

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
r_request_id numeric 10 null
ad_issue.r_request_id rrequest_adissue N
r_issueknown.r_request_id rrequest_rissueknown R
r_request.r_requestrelated_id rrequest_related R
r_requestaction.r_request_id rrequest_rrequestaction R
r_requestupdate.r_request_id rrequest_rrequestupdate R
r_requestupdates.r_request_id rrequest_rrupdates 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
documentno varchar 30 null
r_requesttype_id numeric 10 null
r_requesttype.r_requesttype_id rrequesttype_rrequest R
r_group_id numeric 10 √ null
r_group.r_group_id rgroup_rrequest R
r_category_id numeric 10 √ null
r_category.r_category_id rcategory_rrequest R
r_status_id numeric 10 √ null
r_status.r_status_id rstatus_rrequest R
r_resolution_id numeric 10 √ null
r_resolution.r_resolution_id rresolution_rrequest R
r_requestrelated_id numeric 10 √ null
r_request.r_request_id rrequest_related R
priority bpchar 1 null
priorityuser bpchar 1 √ null
duetype bpchar 1 null
summary varchar 2000 null
confidentialtype bpchar 1 'C'::bpchar
isescalated bpchar 1 'N'::bpchar
isselfservice bpchar 1 'N'::bpchar
salesrep_id numeric 10 null
ad_user.ad_user_id adusersr_rrequest R
ad_role_id numeric 10 √ null
ad_role.ad_role_id adrole_rrequest R
datelastaction timestamp 29,6 √ null
datelastalert timestamp 29,6 √ null
lastresult varchar 2000 √ null
processed bpchar 1 'N'::bpchar
isinvoiced bpchar 1 'N'::bpchar
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id c_bpartner_rrequest R
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_rrequest R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_rrequest R
c_order_id numeric 10 √ null
c_order.c_order_id corder_rrequest R
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id rinvoice_rrequest R
c_payment_id numeric 10 √ null
c_payment.c_payment_id cpayment_rrequest R
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_rrequest R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_rrequest R
a_asset_id numeric 10 √ null
a_asset.a_asset_id aasset_rrequest R
m_inout_id numeric 10 √ null
m_inout.m_inout_id minout_rrequest R
m_rma_id numeric 10 √ null
m_rma.m_rma_id mrma_rrequest R
ad_table_id numeric 10 √ null
ad_table.ad_table_id adtable_rrequest R
record_id numeric 10 √ null
requestamt numeric 0 0
r_mailtext_id numeric 10 √ null
r_mailtext.r_mailtext_id rmailtext_rrequest R
result varchar 2000 √ null
confidentialtypeentry bpchar 1 null
r_standardresponse_id numeric 10 √ null
r_standardresponse.r_standardresponse_id rstandardresponse_rrequest R
nextaction bpchar 1 √ null
datenextaction timestamp 29,6 √ null
starttime timestamp 29,6 √ null
endtime timestamp 29,6 √ null
qtyspent numeric 0 √ 0
qtyinvoiced numeric 0 √ 0
m_productspent_id numeric 10 √ null
m_product.m_product_id mproductspent_rrequest R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_rrequest R
startdate timestamp 29,6 √ null
closedate timestamp 29,6 √ null
c_invoicerequest_id numeric 10 √ null
c_invoice.c_invoice_id cinvoicerequest_rrequest R
m_changerequest_id numeric 10 √ null
m_changerequest.m_changerequest_id mchangerequest_rrequest R
taskstatus bpchar 1 √ null
qtyplan numeric 0 √ null
datecompleteplan timestamp 29,6 √ null
datestartplan timestamp 29,6 √ null
m_fixchangenotice_id numeric 10 √ null
m_changenotice.m_changenotice_id mfixchangenotice_rrequest R
r_request_uu varchar 36 √ NULL::character varying
title varchar 40 √ null
messageid varchar 120 √ NULL::character varying
record_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
r_request_pkey Primary key Asc r_request_id
r_request_bpartner Performance Asc c_bpartner_id
r_request_c_invoice_id_idx Performance Asc c_invoice_id
r_request_c_invoicerequest_id_idx Performance Asc c_invoicerequest_id
r_request_c_order_id_idx Performance Asc c_order_id
r_request_table_recorduu_idx Performance Asc/Asc ad_table_id + record_uu
r_request_user Performance Asc ad_user_id
r_request_uu_idx Must be unique Asc r_request_uu

Check Constraints

Constraint Name Constraint
r_request_isescalated_check ((isescalated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
r_request_isinvoiced_check ((isinvoiced = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
r_request_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
r_request_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
r_request_isselfservice_check ((isselfservice = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation