ad_reference

1128 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_reference_id numeric 10 null
a_registrationattribute.ad_reference_id adreference_aregattribute R
a_registrationattribute.ad_reference_value_id adreferencevalue_aregattribute R
ad_attribute.ad_reference_id adreference_adattribute R
ad_attribute.ad_reference_value_id adreferencevalue_adattribute R
ad_column.ad_reference_id ad_reference_columndatatype R
ad_column.ad_reference_value_id ad_reference_columnvalue R
ad_field.ad_reference_id adreference_adfield R
ad_field.ad_reference_value_id adreferencevalue_adfield R
ad_infocolumn.ad_reference_id adreference_adinfocolumn R
ad_infocolumn.ad_reference_value_id adreferencevalue_adinfocolumn R
ad_package_exp_detail.ad_reference_id adreference_adpackageexpdetail R
ad_package_imp_backup.ad_reference_id adreference_adpackageimpbackup R
ad_process_para.ad_reference_id adreference_adprocesspara R
ad_process_para.ad_reference_value_id adreferencevalue_adprocpara R
ad_ref_list.ad_reference_id ad_reference_reflist C
ad_ref_table.ad_reference_id ad_reference_reftable C
ad_reference_trl.ad_reference_id ad_referencetrl C
ad_relationtype.ad_reference_source_id adreferencesource_adrelationty R
ad_relationtype.ad_reference_target_id adreferencetarget_adrelationty R
ad_userdef_field.ad_reference_id adreference_aduserdeffield R
ad_userdef_field.ad_reference_value_id adreferencevalue_aduserdeffiel R
ad_userdef_info_column.ad_reference_id adreference_aduserdefcolumn R
ad_userdef_info_column.ad_reference_value_id adreferencevalue_aduserdefinfo R
ad_userdef_proc_parameter.ad_reference_id adreference_aduserdefprocparam R
ad_userdef_proc_parameter.ad_reference_value_id adreferencevalue_aduserdefproc R
asp_ref_list.ad_reference_id adreference_aspreflist R
hr_concept.ad_reference_id adreference_hrconcept R
m_attribute.ad_reference_id adreference_mattribute R
m_attribute.ad_reference_value_id adreferencevalue_mattribute R
ws_webservicefieldinput.ad_reference_id adreference_wswebservicefieldi R
ws_webservicefieldinput.ad_reference_value_id adreferencevalue_wswebservicef R
ad_client_id numeric 10 null
ad_client.ad_client_id referenceclient R
ad_org_id numeric 10 null
ad_org.ad_org_id referenceorg R
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
help varchar 2000 √ null
validationtype bpchar 1 null
vformat varchar 40 √ null
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adreference R
isorderbyvalue bpchar 1 √ 'N'::bpchar
ad_reference_uu varchar 36 √ NULL::character varying
ad_element_id numeric 10 √ NULL::numeric
ad_element.ad_element_id adelement_adreference R
showinactive varchar 4 'N'::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_reference_pkey Primary key Asc ad_reference_id
ad_reference_name Must be unique Asc name
ad_reference_uu_idx Must be unique Asc ad_reference_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation