ad_val_rule

523 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_val_rule_id numeric 10 null
ad_attribute.ad_val_rule_id advalrule_adattribute N
ad_column.ad_val_rule_id ad_valrule_column R
ad_column.ad_val_rule_lookup_id advalrulelookup_adcolumn R
ad_field.ad_val_rule_id advalrule_adfield R
ad_field.ad_val_rule_lookup_id advalrulefind_adfield R
ad_field_backup.ad_val_rule_id Implied Constraint R
ad_field_v.ad_val_rule_id Implied Constraint R
ad_field_vt.ad_val_rule_id Implied Constraint R
ad_infocolumn.ad_val_rule_id advalrule_adinfocolumn R
ad_infocolumn_backup.ad_val_rule_id Implied Constraint R
ad_package_exp_detail.ad_val_rule_id advalrule_adpackageexpdetail R
ad_process_para.ad_val_rule_id advalrule_ad_processpara R
ad_table.ad_val_rule_id ad_valrule_table R
ad_userdef_field.ad_val_rule_id advalrule_aduserdeffield R
ad_userdef_field.ad_val_rule_lookup_id advalrulefind_aduserdeffield R
ad_userdef_info_column.ad_val_rule_id advalrule_aduserdefinfocolumn R
ad_userdef_proc_parameter.ad_val_rule_id advalrule_aduserdefprocparamet R
m_attribute.ad_val_rule_id advalrule_mattribute R
ad_client_id numeric 10 null
ad_client.ad_client_id val_ruleclient R
ad_org_id numeric 10 null
ad_org.ad_org_id val_ruleorg 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
type bpchar 1 √ null
code varchar 4000 √ null
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_advalrule R
ad_val_rule_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_val_rule_pkey Primary key Asc ad_val_rule_id
ad_val_rule_uu_idx Must be unique Asc ad_val_rule_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation