mht_brerp10
.adempiere
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
mfa_rule
2
rows
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
mfa_rule_id
numeric
10
null
ad_client_id
numeric
10
null
ad_org_id
numeric
10
null
created
timestamp
29,6
statement_timestamp()
createdby
numeric
10
null
help
varchar
2000
√
NULL::character varying
isactive
bpchar
1
'Y'::bpchar
mfa_rule_uu
varchar
36
√
NULL::character varying
updated
timestamp
29,6
statement_timestamp()
updatedby
numeric
10
null
Showing 1 to 10 of 11 entries
Previous
1
2
Next
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
mfa_rule_key
Primary key
Asc
mfa_rule_id
mfa_rule_uu_idx
Must be unique
Asc
mfa_rule_uu
Showing 1 to 2 of 2 entries
Previous
1
Next
Check Constraints
Search:
Constraint Name
Constraint
mfa_rule_isactive_check
((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
Showing 1 to 1 of 1 entries
Previous
1
Next
Relationships
Close relationships within degrees of separation
One