Table almasdd.COMPIERE.X_POSTAL

Generated by SchemaSpy

Related columns Constraint names Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships Dashed lines show implied relationships < n > number of related tables Please support this project

Column Type Size Nulls Auto Default Children Parents X_POSTAL_ID number 10 AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID X_POSTALCLIENT AD_ORG_ID number 10 AD_ORG AD_ORG_ID X_POSTALORG ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 C_COUNTRY_ID number 10  √  null C_COUNTRY C_COUNTRY_ID XCOUNTRY_XPOSTAL C_REGION_ID number 10  √  null C_REGION C_REGION_ID XPREGION_XPOSTAL AREACODE varchar2 10  √  null OLDZIP varchar2 10 POSTAL varchar2 10 X_REGION_NAME_KANA varchar2 120  √  null X_CITY_NAME_KANA varchar2 120  √  null X_ADDRESS_KANA varchar2 255  √  null X_REGION_NAME varchar2 120  √  null X_CITY_NAME varchar2 120  √  null X_ADDRESS varchar2 255  √  null IS_DUPLICATE char 1 '0' IS_RECURSIVE char 1 '0' IS_INCLUDE_ADDRNO char 1 '0' IS_MULTI_ZIP char 1 '0' IS_UPDATED char 1 '0' UPDATE_REASON char 1 '0' POSTALLOOKUP char 1 '1' Table contained 121,525 rows at ‰Î 3 07 12:14 JST 2006

SchemaSpy was unable to generate a graphical representation of table relationships.
An appropriate version of dot must be in your path when generating these pages.
Requires dot version 2.2.1 or versions greater than 2.4 from www.graphviz.org.