Table idempiere9.adempiere.c_country
Country

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_country_id numeric 10
c_city
c_country
c_country_trl
c_countrygroupcountry
c_location
c_nonbusinessday
c_region
c_tax
c_tax
i_bpartner
i_invoice
i_order
m_commodityshipment
m_freight
m_freight
c_country
Country
ad_client_id numeric 10
ad_client
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org
Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
countrycode bpchar 2 Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
hasregion bpchar 1 'N'::bpchar Country contains Regions
regionname varchar 60  √  null Name of the Region
expressionphone varchar 20  √  null Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
displaysequence varchar 20 Format for printing this Address
expressionpostal varchar 20  √  null Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
haspostal_add bpchar 1 'N'::bpchar Has Additional Postal Code
expressionpostal_add varchar 20  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_language varchar 6  √  null
ad_language
Language for this entity
c_currency_id numeric 10  √  null
c_currency
The Currency for this record
displaysequencelocal varchar 20  √  null Format for printing this Address locally
isaddresslinesreverse bpchar 1 'N'::bpchar Print Address in reverse Order
isaddresslineslocalreverse bpchar 1 'N'::bpchar Print Local Address in reverse Order
expressionbankroutingno varchar 20  √  null Format of the Bank Routing Number
expressionbankaccountno varchar 20  √  null Format of the Bank Account
mediasize varchar 40  √  null Java Media Size
ispostcodelookup bpchar 1 'N'::bpchar Does this country have a post code web service
lookupclassname varchar 255  √  null The class name of the postcode lookup plugin
lookupclientid varchar 50  √  null The ClientID or Login submitted to the Lookup URL
lookuppassword varchar 50  √  null The password submitted to the Lookup URL
lookupurl varchar 100  √  null The URL of the web service that the plugin connects to in order to retrieve postcode data
allowcitiesoutoflist bpchar 1  √  'Y'::bpchar A flag to allow cities, currently not in the list, to be entered
capturesequence varchar 60  √  null Capture Sequence
c_country_uu varchar 36  √  NULL::character varying C_Country_UU
placeholderaddress1 varchar 255  √  NULL::character varying Placeholder for Address 1
placeholderaddress2 varchar 255  √  NULL::character varying Placeholder for Address 2
placeholderaddress3 varchar 255  √  NULL::character varying Placeholder for Address 3
placeholderaddress4 varchar 255  √  NULL::character varying Placeholder for Address 4
placeholderaddress5 varchar 255  √  NULL::character varying Placeholder for Address 5
placeholdercity varchar 255  √  NULL::character varying Placeholder for city
placeholdercomments varchar 255  √  NULL::character varying Placeholder for comments
placeholderpostal varchar 255  √  NULL::character varying Placeholder for postal
placeholderpostal_add varchar 255  √  NULL::character varying Placeholder for additional zip

Table contained 251 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort
c_country_id Primary key Asc
c_country_uu Must be unique Asc
countrycode Must be unique Asc


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.