Table idempiere9.adempiere.c_city City

Generated by Quality Systems & Solutions

Related columns Constraints Comments Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships < n > number of related tables

Column Type Size Nulls Auto Default Children Parents Comments c_city_id numeric 10 c_location.c_city_id ccity_clocation R i_fixedasset.c_city_id ccity_ifixedasset R City ad_client_id numeric 10 ad_client.ad_client_id c_cityclient R Client/Tenant for this installation. ad_org_id numeric 10 ad_org.ad_org_id c_cityorg R 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 locode varchar 10  √  null Location code - UN/LOCODE coordinates varchar 15  √  null Location coordinate postal varchar 10  √  null Postal code areacode varchar 10  √  null Phone Area Code c_country_id numeric 10  √  null c_country.c_country_id ccountry_ccity R Country c_region_id numeric 10  √  null c_region.c_region_id cregion_ccity R Identifies a geographical Region c_city_uu varchar 36  √  NULL::character varying C_City_UU Table contained 1 rows at 2021-12-25 14:43 +0100

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.