Table erp.COMPIERE.W_STORE

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 W_STORE_ID number 10 W_MAILMSG W_STORE_ID WSTORE_WMAILMSG W_STORE_TRL W_STORE_ID WSTORE_WSTORETRL AD_CLIENT_ID number 10 AD_CLIENT AD_CLIENT_ID ADCLIENT_WSTORE AD_ORG_ID number 10 AD_ORGINFO AD_ORG_ID Implied Constraint ISACTIVE char 1 'Y' CREATED date 7 now CREATEDBY number 10 UPDATED date 7 now UPDATEDBY number 10 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null HELP nvarchar2 4000  √  null WSTOREEMAIL nvarchar2 120  √  null WSTOREUSER nvarchar2 120  √  null WSTOREUSERPW nvarchar2 40  √  null WEBINFO nvarchar2 4000  √  null WEBPARAM1 nvarchar2 4000  √  null WEBPARAM2 nvarchar2 4000  √  null WEBPARAM3 nvarchar2 4000  √  null WEBPARAM4 nvarchar2 4000  √  null WEBPARAM5 nvarchar2 4000  √  null WEBPARAM6 nvarchar2 4000  √  null ISMENUASSETS char 1 'Y' ISMENUORDERS char 1 'Y' ISMENUINVOICES char 1 'Y' ISMENUSHIPMENTS char 1 'Y' ISMENUPAYMENTS char 1 'Y' ISMENURFQS char 1 'Y' ISMENUREQUESTS char 1 'Y' ISMENUINTERESTS char 1 'Y' ISMENUREGISTRATIONS char 1 'Y' ISMENUCONTACT char 1 'Y' EMAILHEADER nvarchar2 4000  √  null EMAILFOOTER nvarchar2 4000  √  null SALESREP_ID number 10 M_WAREHOUSE_ID number 10 M_WAREHOUSE M_WAREHOUSE_ID Implied Constraint M_PRICELIST_ID number 10 M_PRICELIST M_PRICELIST_ID Implied Constraint WEBCONTEXT nvarchar2 40 WEBORDEREMAIL nvarchar2 120  √  null C_PAYMENTTERM_ID number 10  √  null C_PAYMENTTERM C_PAYMENTTERM_ID Implied Constraint ISDEFAULT char 1 'N' URL nvarchar2 240 'http://localhost' Table contained 1 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.