c_region

399 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_region_id numeric 10 null
c_city.c_region_id cregion_ccity R
c_invoicepayschedule.pag_ufpag_id pagufpag_cinvoicepayschedule R
c_location.c_region_id c_region_location R
c_orderpayschedule.pag_ufpag_id pagufpag_corderpayschedule R
c_region_trl.c_region_id cregion_cregiontrl C
c_tax.c_region_id c_region_c_tax R
c_tax.to_region_id c_regionto_c_tax R
cof_c_adjustment.c_region_id cregion_cofcadjustment R
cof_c_adjusttable.c_region_id cregion_cofcadjusttable R
cof_c_taxdetermination_fact.c_region_id cregion_cofctaxdeterminationfa R
cof_c_taxdetermination_hdr.cof_estadodestino_id cofestadodestino_cofctaxdeterm R
cof_c_taxdetermination_line.c_region_id cregion_cofctaxdeterminationli R
cof_controlemulta.c_region_id cregion_cofcontrolemulta R
cof_controlemulta.cof_uf_id cofuf_cofcontrolemulta R
cof_creditreferences.c_region_id cregion_cofcreditreferences R
cof_equipments.cof_stateplate_id cofstateplate_cofequipments R
cof_mdfe.cof_mdfe_uf_id cofmdfeuf_cofmdfe R
cof_mdfe.cof_mdfe_ufequip_id cofmdfeufequip_cofmdfe R
cof_mdfe.cof_mdfe_uffim_id cofmdfeuffim_cofmdfe R
cof_mdfe.cof_mdfe_ufini_id cofmdfeufini_cofmdfe R
cof_mdfe_percurso.c_region_id cregion_cofmdfepercurso R
cof_mdfe_reboque.cof_mdfe_ufequip_id cofmdfeufequip_cofmdfereboque R
cof_packinglist.cof_stateplate_id cofstateplate_cofpackinglist R
cof_participant.cof_regioncrc_id cofregioncrc_cofparticipant R
cof_preferenciaxml.c_region_id cregion_cofpreferenciaxml N
cof_realgoods.c_region_id cregion_cofrealgoods R
cof_rps.cof_destinatarioregion_id cofdestinatarioregion_cofrps R
cof_rps.dest_region_id destregion_cofrps R
cte_cte.cof_ufinicio_id cofufinicio_ctecte R
cte_cte.cof_uftermino_id cofuftermino_ctecte R
cte_cte.cte_dest_region_id ctedestregion_ctecte R
cte_cte.cte_emit_region_id cteemitregion_ctecte R
cte_cte.cte_exped_region_id cteexpedregion_ctecte R
cte_cte.cte_receb_region_id cterecebregion_ctecte R
cte_cte.cte_rem_region_id cteremregion_ctecte R
cte_cte.cte_toma_region_id ctetomaregion_ctecte R
cte_info.cof_ufinicio_id cofufinicio_cteinfo R
cte_info.cof_uftermino_id cofuftermino_cteinfo R
i_bpartner.c_region_id cregion_ibpartner N
i_invoice.c_region_id cregion_iinvoice N
i_order.c_region_id cregion_iorder N
lbr_docfiscal.retira_region_id retiraregion_lbrdocfiscal R
lbr_docfiscal_detpag.pag_ufpag_id pagufpag_lbrdocfiscaldetpag R
m_freight.c_region_id cregion_mfreight R
m_freight.to_region_id cregionto_mfreight R
ad_client_id numeric 10 null
ad_client.ad_client_id c_regionclient R
ad_org_id numeric 10 null
ad_org.ad_org_id c_regionorg 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
c_country_id numeric 10 null
c_country.c_country_id ccountry_cregion R
isdefault bpchar 1 √ 'N'::bpchar
c_region_uu varchar 36 √ NULL::character varying
lbr_regioncode numeric 10 √ NULL::numeric

Indexes

Constraint Name Type Sort Column(s)
c_region_pkey Primary key Asc c_region_id
c_region_name Must be unique Asc/Asc c_country_id + name
c_region_uu_idx Must be unique Asc c_region_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation