Table erp.COMPIERE.M_PRODUCT_CATEGORY

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 M_PRODUCT_CATEGORY_ID number 10 C_COMMISSIONLINE M_PRODUCT_CATEGORY_ID MPRODUCTCAT_CCOMMISSIONLINE C_PROJECTLINE M_PRODUCT_CATEGORY_ID MPRODUCTCAT_CPROJECTLINE C_PROJECT_DETAILS_V M_PRODUCT_CATEGORY_ID Implied Constraint C_PROJECT_DETAILS_VT M_PRODUCT_CATEGORY_ID Implied Constraint C_RFQ_TOPICSUBSCRIBERONLY M_PRODUCT_CATEGORY_ID MPRODCATEGORY_CRFQTSUBONLY I_PRODUCT M_PRODUCT_CATEGORY_ID MPRODUCTCATEGORY_IPRODUCT M_DISCOUNTSCHEMABREAK M_PRODUCT_CATEGORY_ID MPRODCATEGORY_MDISCOUNTSBREAK M_DISCOUNTSCHEMALINE M_PRODUCT_CATEGORY_ID MPRODCATEGORY_MDISCOUNTSLINE M_PERPETUALINV M_PRODUCT_CATEGORY_ID MPRODCATEGORY_MPERPETUALINV M_PRODUCT M_PRODUCT_CATEGORY_ID MPRODUCT_MPRODUCTCATEGORY M_PRODUCT_CATEGORY_ACCT M_PRODUCT_CATEGORY_ID MPRODCAT_MPRODCATACCT PA_GOALRESTRICTION M_PRODUCT_CATEGORY_ID MPRODUCTCAT_PAGOALRESTRICTION RV_COST M_PRODUCT_CATEGORY_ID Implied Constraint RV_COSTDETAIL M_PRODUCT_CATEGORY_ID Implied Constraint RV_COSTSUMMARY M_PRODUCT_CATEGORY_ID Implied Constraint RV_FACT_ACCT M_PRODUCT_CATEGORY_ID Implied Constraint RV_M_TRANSACTION M_PRODUCT_CATEGORY_ID Implied Constraint RV_PRODUCT_COSTING M_PRODUCT_CATEGORY_ID Implied Constraint RV_TRANSACTION M_PRODUCT_CATEGORY_ID Implied Constraint S_EXPENSETYPE M_PRODUCT_CATEGORY_ID MPRODUCTCATEGORY_SEXPENSETYPE S_RESOURCETYPE M_PRODUCT_CATEGORY_ID MPRODCATEGORY_SRESOURCETYPE S_TRAINING M_PRODUCT_CATEGORY_ID MPRODUCTCATEGORY_STRAINING AD_CLIENT_ID number 10 AD_CLIENTINFO AD_CLIENT_ID Implied Constraint 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 VALUE nvarchar2 80 NAME nvarchar2 120 DESCRIPTION nvarchar2 510  √  null ISDEFAULT char 1 'N' PLANNEDMARGIN number 22 A_ASSET_GROUP_ID number 10  √  null A_ASSET_GROUP A_ASSET_GROUP_ID AASSETGROUP_MPRODUCTCATEGORY ISSELFSERVICE char 1 'Y' AD_PRINTCOLOR_ID number 10  √  null AD_PRINTCOLOR AD_PRINTCOLOR_ID Implied Constraint MMPOLICY char 1 'F' Table contained 8 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.