ad_rule

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_rule_id numeric 10 null
ad_table_scriptvalidator.ad_rule_id adrule_adtablescriptvalidator R
c_tax.ad_rule_id adrule_ctax R
hr_attribute.ad_rule_id adrule_hrattribute R
hr_movement.ad_rule_id adrule_hrmovement R
hr_payrollconcept.ad_rule_id adrule_hrpayrollconcept R
accesslevel bpchar 1 √ null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
description varchar 255 √ null
entitytype varchar 40 √ 'U'::character varying
ad_entitytype.entitytype entityt_adrule R
eventtype bpchar 1 √ null
help varchar 2000 √ null
isactive bpchar 1 'Y'::bpchar
name varchar 60 null
ruletype bpchar 1 √ null
script varchar 4000 √ null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
value varchar 40 null
ad_rule_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_rule_key Primary key Asc ad_rule_id
ad_rule_uu_idx Must be unique Asc ad_rule_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation