c_city

5575 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_city_id numeric 10 null
c_location.c_city_id ccity_clocation R
cof_controlemulta.c_city_id ccity_cofcontrolemulta R
cof_creditreferences.c_city_id ccity_cofcreditreferences R
cof_m_shipregion_city.c_city_id ccity_cofmshipregioncity R
cof_mdfe.cof_mdfe_cidade_id cofmdfecidade_cofmdfe R
cof_mdfe_muncarregamento.c_city_id ccity_cofmdfemuncarregamento R
cof_mdfe_mundescarregamento.c_city_id ccity_cofmdfemundescarregament R
cof_preferenciaxml.c_city_id ccity_cofpreferenciaxml N
cof_realgoods.c_city_id ccity_cofrealgoods R
cof_rps.cof_destinatariocity_id cofdestinatariocity_cofrps R
cof_rps.dest_city_id destcity_cofrps R
cte_cte.cof_municipioinicio_id cofmunicipioinicio_ctecte R
cte_cte.cof_municipiotermino_id cofmunicipiotermino_ctecte R
cte_cte.cte_dest_city_id ctedestcity_ctecte R
cte_cte.cte_emit_city_id cteemitcity_ctecte R
cte_cte.cte_exped_city_id cteexpedcity_ctecte R
cte_cte.cte_receb_city_id cterecebcity_ctecte R
cte_cte.cte_rem_city_id cteremcity_ctecte R
cte_cte.cte_toma_city_id ctetomacity_ctecte R
cte_info.cof_municipioinicio_id cofmunicipioinicio_cteinfo R
cte_info.cof_municipiotermino_id cofmunicipiotermino_cteinfo R
i_fixedasset.c_city_id ccity_ifixedasset R
lbr_docfiscal.retira_city_id retiracity_lbrdocfiscal R
lbr_taxdefinition.c_city_id ccity_lbrtaxdefinition R
ad_client_id numeric 10 null
ad_client.ad_client_id c_cityclient R
ad_org_id numeric 10 null
ad_org.ad_org_id c_cityorg 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
locode varchar 10 √ null
coordinates varchar 15 √ null
postal varchar 10 √ null
areacode varchar 10 √ null
c_country_id numeric 10 √ null
c_country.c_country_id ccountry_ccity R
c_region_id numeric 10 √ null
c_region.c_region_id cregion_ccity R
c_city_uu varchar 36 √ NULL::character varying
lbr_citycode varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
c_city_pkey Primary key Asc c_city_id
c_city_uu_idx Must be unique Asc c_city_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation