pa_hierarchy

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pa_hierarchy_id numeric 10 null
pa_measure.pa_hierarchy_id pahierarchy_pameasure 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_tree_org_id numeric 10 null
ad_tree.ad_tree_id adtreeorg_pahierarchy R
ad_tree_bpartner_id numeric 10 null
ad_tree.ad_tree_id adtreebpartner_pahierarchy R
ad_tree_project_id numeric 10 null
ad_tree.ad_tree_id adtreeproject_pahierarchy R
ad_tree_salesregion_id numeric 10 null
ad_tree.ad_tree_id adtreesr_pahierarchy R
ad_tree_product_id numeric 10 null
ad_tree.ad_tree_id adtreeproduct_pahierarchy R
ad_tree_campaign_id numeric 10 null
ad_tree.ad_tree_id adtreecampaign_pahierarchy R
ad_tree_activity_id numeric 10 null
ad_tree.ad_tree_id adtreeactivity_pahierarchy R
ad_tree_account_id numeric 10 null
ad_tree.ad_tree_id adtreeaccount_pahierarchy R
pa_hierarchy_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
pa_hierarchy_pkey Primary key Asc pa_hierarchy_id
pa_hierarchy_uu_idx Must be unique Asc pa_hierarchy_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation