c_country

251 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_country_id numeric 10 null
c_city.c_country_id ccountry_ccity R
c_country.c_country_id ccountry_ccountry R
c_country_trl.c_country_id ccountry_ccountrytrl C
c_countrygroupcountry.c_country_id ccountry_ccountrygroupcountry R
c_location.c_country_id c_country_location R
c_nonbusinessday.c_country_id ccountry_cnonbusinessday R
c_region.c_country_id ccountry_cregion R
c_tax.c_country_id c_country_c_tax R
c_tax.to_country_id c_countryto_c_tax R
cof_controlemulta.c_country_id ccountry_cofcontrolemulta R
cof_rps.cof_destinatariocountry_id cofdestinatariocountry_cofrps R
cof_rps.dest_country_id destcountry_cofrps R
cte_cte.cte_dest_country_id ctedestcountry_ctecte R
cte_cte.cte_emit_country_id cteemitcountry_ctecte R
cte_cte.cte_exped_country_id cteexpedcountry_ctecte R
cte_cte.cte_receb_country_id cterecebcountry_ctecte R
cte_cte.cte_rem_country_id cteremcountry_ctecte R
cte_cte.cte_toma_country_id ctetomacountry_ctecte R
i_bpartner.c_country_id ccountry_ipartner N
i_invoice.c_country_id ccountry_iinvoice N
i_order.c_country_id ccountry_iorder N
lbr_docfiscal.entrega_country_id entregacountry_lbrdocfiscal R
lbr_docfiscal.retira_country_id retiracountry_lbrdocfiscal R
m_commodityshipment.countryofmanufacture_id countryofmanufacture_mcommodit R
m_freight.c_country_id ccountry_mfreight R
m_freight.to_country_id ccountryto_mfreight R
c_country.c_country_id ccountry_ccountry R
ad_client_id numeric 10 null
ad_client.ad_client_id c_countryclient R
ad_org_id numeric 10 null
ad_org.ad_org_id c_countryorg 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
countrycode bpchar 2 null
hasregion bpchar 1 'N'::bpchar
regionname varchar 60 √ null
expressionphone varchar 20 √ null
displaysequence varchar 20 null
expressionpostal varchar 20 √ null
haspostal_add bpchar 1 'N'::bpchar
expressionpostal_add varchar 20 √ null
ad_language varchar 6 √ null
ad_language.ad_language adlanguage_ccountry R
c_currency_id numeric 10 √ null
c_currency.c_currency_id ccurrency_ccountry R
displaysequencelocal varchar 20 √ null
isaddresslinesreverse bpchar 1 'N'::bpchar
isaddresslineslocalreverse bpchar 1 'N'::bpchar
expressionbankroutingno varchar 20 √ null
expressionbankaccountno varchar 20 √ null
mediasize varchar 40 √ null
ispostcodelookup bpchar 1 'N'::bpchar
lookupclassname varchar 255 √ null
lookupclientid varchar 50 √ null
lookuppassword varchar 50 √ null
lookupurl varchar 100 √ null
allowcitiesoutoflist bpchar 1 √ 'Y'::bpchar
capturesequence varchar 60 √ null
c_country_uu varchar 36 √ NULL::character varying
lbr_countrycode varchar 5 √ null
placeholderaddress1 varchar 255 √ NULL::character varying
placeholderaddress2 varchar 255 √ NULL::character varying
placeholderaddress3 varchar 255 √ NULL::character varying
placeholderaddress4 varchar 255 √ NULL::character varying
placeholderaddress5 varchar 255 √ NULL::character varying
placeholdercity varchar 255 √ NULL::character varying
placeholdercomments varchar 255 √ NULL::character varying
placeholderpostal varchar 255 √ NULL::character varying
placeholderpostal_add varchar 255 √ NULL::character varying
lbr_codigopaisbarueri varchar 5 √ NULL::character varying
m49code varchar 3 √ NULL::character varying
isocountrycodealpha3 varchar 3 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_country_pkey Primary key Asc c_country_id
c_country_uu_idx Must be unique Asc c_country_uu
c_countrycode Must be unique Asc countrycode

Check Constraints

Constraint Name Constraint
c_country_allowcitiesoutoflist_check ((allowcitiesoutoflist = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_country_hasregion_check ((hasregion = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_country_ispostcodelookup_check ((ispostcodelookup = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_country_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_country_haspostal_add_check ((haspostal_add = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation