cof_orcamentoconfig

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_orcamentoconfig_id numeric 10 null
cof_orcamentoconfig_uu varchar 36 √ NULL::character varying
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_coforcamentoconfig R
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_coforcamentoconfig R
user1_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user1_coforcamentoconfig R
user2_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user2_coforcamentoconfig R
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id ccampaign_coforcamentoconfig R
cof_locationto_id numeric 10 √ NULL::numeric
c_location.c_location_id coflocationto_coforcamentoconf R
cof_locationfrom_id numeric 10 √ NULL::numeric
c_location.c_location_id coflocationfrom_coforcamentoco R
c_project_id numeric 10 √ NULL::numeric
c_project.c_project_id cproject_coforcamentoconfig R
c_salesregion_id numeric 10 √ NULL::numeric
c_salesregion.c_salesregion_id csalesregion_coforcamentoconfi R
cof_orcamentoitem_id numeric 10 √ null
cof_orcamentoitem.cof_orcamentoitem_id coforcamentoitem_coforcamentoc R
c_activity_id numeric 10 √ NULL::numeric
c_activity.c_activity_id cactivity_coforcamentoconfig R
account_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id account_coforcamentoconfig R
accounttype bpchar 1 √ NULL::bpchar
amount numeric 0 √ null
cof_valorcalculado numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
cof_orcamentoconfig_key Primary key Asc cof_orcamentoconfig_id
cof_orcamentoconfig_uu_idx Must be unique Asc cof_orcamentoconfig_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation