ad_process_para

3151 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_process_para_id numeric 10 null
ad_process_drillrule.ad_process_para_id adprocesspara_adprocessdrillru R
ad_process_drillrule_para.ad_process_para_id adprocesspara_addrillrulepara R
ad_process_para_trl.ad_process_para_id adprocpara_adprocparatrl C
ad_scheduler_para.ad_process_para_id adprocesspara_adschedulerpara C
ad_userdef_proc_parameter.ad_process_para_id adprocesspara_aduserdefprocpar R
ad_wf_node_para.ad_process_para_id adprocesspara_adwfnodepara C
asp_clientexception.ad_process_para_id adprocesspara_aspclientexcepti R
asp_process_para.ad_process_para_id adprocesspara_aspprocesspara 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
help varchar 2000 √ null
ad_process_id numeric 10 null
ad_process.ad_process_id adprocess_adprocesspara C
seqno numeric 10 null
ad_reference_id numeric 10 null
ad_reference.ad_reference_id adreference_adprocesspara R
ad_reference_value_id numeric 10 √ null
ad_reference.ad_reference_id adreferencevalue_adprocpara R
ad_val_rule_id numeric 10 √ null
ad_val_rule.ad_val_rule_id advalrule_ad_processpara R
columnname varchar 40 null
iscentrallymaintained bpchar 1 'Y'::bpchar
fieldlength numeric 10 null
ismandatory bpchar 1 'N'::bpchar
isrange bpchar 1 'N'::bpchar
defaultvalue varchar 2000 √ null
defaultvalue2 varchar 2000 √ null
vformat varchar 255 √ null
valuemin varchar 20 √ null
valuemax varchar 20 √ null
ad_element_id numeric 10 √ null
ad_element.ad_element_id adelement_adprocesspara R
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adprocesspara R
readonlylogic varchar 2000 √ null
displaylogic varchar 2000 √ null
ad_process_para_uu varchar 36 √ NULL::character varying
isencrypted bpchar 1 'N'::bpchar
mandatorylogic varchar 2000 √ NULL::character varying
placeholder varchar 255 √ NULL::character varying
placeholder2 varchar 255 √ NULL::character varying
isautocomplete bpchar 1 'N'::bpchar
ad_fieldgroup_id numeric 10 √ NULL::numeric
ad_fieldgroup.ad_fieldgroup_id adfieldgroup_adprocesspara R
query varchar 2000 √ NULL::character varying
daterangeoption bpchar 1 'D'::bpchar
isshownegatebutton bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
ad_process_para_pkey Primary key Asc ad_process_para_id
ad_process_para_uu_idx Must be unique Asc ad_process_para_uu
ad_procpara_procseqno Must be unique Asc/Asc ad_process_id + seqno

Check Constraints

Constraint Name Constraint
ad_process_para_ismandatory_check ((ismandatory = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_process_para_isautocomplete_check ((isautocomplete = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_process_para_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_process_para_isencrypted_check ((isencrypted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_process_para_isrange_check ((isrange = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_process_para_isshownegatebutton_check ((isshownegatebutton = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_process_para_iscentrallymaintained_check ((iscentrallymaintained = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation