Table erp.COMPIERE.I_BPARTNER

Generated by SchemaSpy

Implied relationships 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 I_BPARTNER_ID number 10 AD_CLIENT_ID number 10  √  null AD_CLIENTINFO AD_CLIENT_ID Implied Constraint AD_ORG_ID number 10  √  null AD_ORGINFO AD_ORG_ID Implied Constraint ISACTIVE char 1  √  'Y' CREATED date 7  √  now CREATEDBY number 10  √  null UPDATED date 7  √  now UPDATEDBY number 10  √  null I_ISIMPORTED char 1 'N' I_ERRORMSG nvarchar2 4000  √  null C_BPARTNER_ID number 10  √  null C_BPARTNER C_BPARTNER_ID CBPARTNER_IBPARTNER VALUE nvarchar2 80  √  null NAME nvarchar2 120  √  null NAME2 nvarchar2 120  √  null DESCRIPTION nvarchar2 510  √  null DUNS char 11  √  null TAXID varchar2 20  √  null NAICS char 6  √  null GROUPVALUE nvarchar2 80  √  null C_BP_GROUP_ID number 10  √  null C_BP_GROUP C_BP_GROUP_ID CBPGROUP_IBPARTNER C_BPARTNER_LOCATION_ID number 10  √  null C_BPARTNER_LOCATION C_BPARTNER_LOCATION_ID CBPARTNERLOCATION_IBPARTNER ADDRESS1 nvarchar2 120  √  null ADDRESS2 nvarchar2 120  √  null POSTAL varchar2 10  √  null POSTAL_ADD varchar2 10  √  null CITY nvarchar2 120  √  null C_REGION_ID number 10  √  null C_REGION C_REGION_ID CREGION_IBPARTNER REGIONNAME nvarchar2 120  √  null C_COUNTRY_ID number 10  √  null C_COUNTRY C_COUNTRY_ID CCOUNTRY_IPARTNER COUNTRYCODE char 2  √  null TITLE nvarchar2 80  √  null CONTACTNAME nvarchar2 120  √  null CONTACTDESCRIPTION nvarchar2 510  √  null COMMENTS nvarchar2 4000  √  null PHONE nvarchar2 80  √  null PHONE2 nvarchar2 80  √  null FAX nvarchar2 80  √  null EMAIL nvarchar2 120  √  null PASSWORD nvarchar2 40  √  null BIRTHDAY date 7  √  null C_GREETING_ID number 10  √  null C_GREETING C_GREETING_ID CGREETING_IBPARTNER BPCONTACTGREETING nvarchar2 120  √  null PROCESSING char 1  √  null PROCESSED char 1  √  'N' AD_USER_ID number 10  √  null AD_USER AD_USER_ID ADUSER_IBPARTNER R_INTERESTAREA_ID number 10  √  null R_INTERESTAREA R_INTERESTAREA_ID Implied Constraint INTERESTAREANAME nvarchar2 80  √  null Table contained 0 rows at Wed Mar 15 18:14 SAST 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.