View almasdd.COMPIERE.RV_CLICK_MONTH

Generated by
SchemaSpy

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

AD_CLIENT_ID

number

AD_CLIENTINFO

AD_CLIENT_ID

Implied Constraint

AD_ORG_ID

number

AD_ORGINFO

AD_ORG_ID

Implied Constraint

NAME

nvarchar2

120

DESCRIPTION

nvarchar2

510

√

null

TARGETURL

nvarchar2

240

C_BPARTNER_ID

number

√

null

C_BPARTNER

C_BPARTNER_ID

Implied Constraint

CREATED

date

√

null

COUNTER

number

√

null

View SQL:

SELECT cc.AD_Client_ID, cc.AD_Org_ID, cc.Name, cc.Description, cc.TargetURL, cc.C_BPartner_ID, firstOf(c.Created,'MM') AS Created, COUNT() AS Counter FROM* W_ClickCount cc INNER JOIN W_Click c ON (cc.W_ClickCount_ID=c.W_ClickCount_ID) GROUP BY cc.AD_Client_ID, cc.AD_Org_ID, cc.Name, cc.Description, cc.TargetURL, cc.C_BPartner_ID, firstOf(c.Created,'MM')

SELECT cc.AD_Client_ID, cc.AD_Org_ID,
    cc.Name, cc.Description, cc.TargetURL, cc.C_BPartner_ID,
    firstOf(c.Created,'MM') AS Created,
    COUNT(*) AS Counter
FROM W_ClickCount cc
  INNER JOIN W_Click c ON (cc.W_ClickCount_ID=c.W_ClickCount_ID)
GROUP BY cc.AD_Client_ID, cc.AD_Org_ID,
    cc.Name, cc.Description, cc.TargetURL, cc.C_BPartner_ID,
    firstOf(c.Created,'MM')

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.