Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Account
| Account    | Portfolio   | Tax   | Currency   | Active   | Account Group 1   | Account Group 2   | Account Group 3   | Calc WHT   | DRIP   |
|:-----------|:------------|:------|:-----------|:---------|:------------------|:------------------|:------------------|:-----------|:-------|
| HisUSD     | Family      | N/A   | USD        | Yes      | Bank1             | US Dollars        | N/A               | No         | No     |
| HisCDN     | Family      | N/A   | CAD        | Yes      | Bank1             | CA Dollars        | N/A               | No         | No     |
| HersUSD    | Family      | N/A   | USD        | Yes      | Bank2             | US Dollars        | N/A               | No         | No     |
| HisTaxUSD  | Tax         | 401k  | USD        | Yes      | Bank1             | US Dollars        | N/A               | No         | No     |
| HersTaxUSD | Tax         | 401k  | USD        | Yes      | Bank2             | US Dollars        | N/A               | No         | No     |


Table: Allocation
| Allocation   |   TargetPercent |
|:-------------|----------------:|
| Cash         |               0 |
| CDN Broad    |              20 |
| US Broad     |              80 |


Table: Config
| GenDivUsed   | MinDate                 | TrackCash   | MarketIndex1   | MarketIndex2   | DripFlag   |
|:-------------|:------------------------|:------------|:---------------|:---------------|:-----------|
| Y            | 2012-12-31 00:00:00.000 | Yes         | ^GSPTSE        | ^GSPC          | N          |


Table: CurrencyConv
| CurrencyFrom   | CurrencyTo   |   ExchRate | Date                    | PrevDate                |   ExchRateDelta | PrevQuoteDate           |   ExchRateDeltaSum |
|:---------------|:-------------|-----------:|:------------------------|:------------------------|----------------:|:------------------------|-------------------:|
| CAD            | USD          |     0.792  | 2016-04-20 00:00:00.000 | 2016-04-19 00:00:00.000 |          0.0019 | 2016-04-19 00:00:00.000 |             0.0019 |
| CAD            | USD          |     0.7901 | 2016-04-19 00:00:00.000 | 2016-04-18 00:00:00.000 |          0.0098 | 2016-04-18 00:00:00.000 |             0.0098 |
| CAD            | USD          |     0.7803 | 2016-04-18 00:00:00.000 | 2016-04-15 00:00:00.000 |          0.0026 | 2016-04-15 00:00:00.000 |             0.0026 |
| CAD            | USD          |     0.7777 | 2016-04-15 00:00:00.000 | 2016-04-14 00:00:00.000 |         -0.0014 | 2016-04-14 00:00:00.000 |            -0.0014 |
| CAD            | USD          |     0.7791 | 2016-04-14 00:00:00.000 | 2016-04-13 00:00:00.000 |         -0.0026 | 2016-04-13 00:00:00.000 |            -0.0026 |
| CAD            | USD          |     0.7817 | 2016-04-13 00:00:00.000 | 2016-04-12 00:00:00.000 |          0.0004 | 2016-04-12 00:00:00.000 |             0.0004 |
| CAD            | USD          |     0.7813 | 2016-04-12 00:00:00.000 | 2016-04-11 00:00:00.000 |          0.0069 | 2016-04-11 00:00:00.000 |             0.0069 |
| CAD            | USD          |     0.7744 | 2016-04-11 00:00:00.000 | 2016-04-08 00:00:00.000 |          0.0049 | 2016-04-08 00:00:00.000 |             0.0049 |
| CAD            | USD          |     0.7695 | 2016-04-08 00:00:00.000 | 2016-04-07 00:00:00.000 |          0.0098 | 2016-04-07 00:00:00.000 |             0.0098 |
| CAD            | USD          |     0.7597 | 2016-04-07 00:00:00.000 | 2016-04-06 00:00:00.000 |         -0.005  | 2016-04-06 00:00:00.000 |            -0.005  |


Table: Dates
| Date                    | Days - Current   | Month   |   Year | Short Date   | Mth-Day   | Quarter In Year   | Quarter   |   Month In Year | QuotesExists   | Days-Last 12   | Days-Last 20   | Days-Last 30   | Mths-Last 12   | Mths-Last 13   | Years-Current   | Years-Last 2   | Years-Last 4   | Years-Last 5   | Years-Last 7   | Years-Last 9   | Last YTD   | Mths-Last  2   | Mths-Current   | Days-Last  5   | Years-Last 3   | Days-Last 10   |   Day In Year |
|:------------------------|:-----------------|:--------|-------:|:-------------|:----------|:------------------|:----------|----------------:|:---------------|:---------------|:---------------|:---------------|:---------------|:---------------|:----------------|:---------------|:---------------|:---------------|:---------------|:---------------|:-----------|:---------------|:---------------|:---------------|:---------------|:---------------|--------------:|
| 2012-12-31 00:00:00.000 | No               | 2012-12 |   2012 | 12-12-31     | 12-31     | Q4                | 2012-Q4   |              12 | Yes            | No             | No             | No             | No             | No             | No              | No             | No             | Yes            | Yes            | Yes            | No         | No             | No             | No             | No             | No             |             1 |
| 2013-01-01 00:00:00.000 | No               | 2013-01 |   2013 | 13-01-01     | 01-01     | Q1                | 2013-Q1   |               1 | No             | No             | No             | No             | No             | No             | No              | No             | Yes            | Yes            | Yes            | Yes            | No         | No             | No             | No             | No             | No             |             1 |
| 2013-01-02 00:00:00.000 | No               | 2013-01 |   2013 | 13-01-02     | 01-02     | Q1                | 2013-Q1   |               1 | No             | No             | No             | No             | No             | No             | No              | No             | Yes            | Yes            | Yes            | Yes            | No         | No             | No             | No             | No             | No             |             2 |
| 2013-01-03 00:00:00.000 | No               | 2013-01 |   2013 | 13-01-03     | 01-03     | Q1                | 2013-Q1   |               1 | No             | No             | No             | No             | No             | No             | No              | No             | Yes            | Yes            | Yes            | Yes            | No         | No             | No             | No             | No             | No             |             3 |
| 2013-01-04 00:00:00.000 | No               | 2013-01 |   2013 | 13-01-04     | 01-04     | Q1                | 2013-Q1   |               1 | No             | No             | No             | No             | No             | No             | No              | No             | Yes            | Yes            | Yes            | Yes            | No         | No             | No             | No             | No             | No             |             4 |
| 2013-01-05 00:00:00.000 | No               | 2013-01 |   2013 | 13-01-05     | 01-05     | Q1                | 2013-Q1   |               1 | No             | No             | No             | No             | No             | No             | No              | No             | Yes            | Yes            | Yes            | Yes            | No         | No             | No             | No             | No             | No             |             5 |
| 2013-01-06 00:00:00.000 | No               | 2013-01 |   2013 | 13-01-06     | 01-06     | Q1                | 2013-Q1   |               1 | No             | No             | No             | No             | No             | No             | No              | No             | Yes            | Yes            | Yes            | Yes            | No         | No             | No             | No             | No             | No             |             6 |
| 2013-01-07 00:00:00.000 | No               | 2013-01 |   2013 | 13-01-07     | 01-07     | Q1                | 2013-Q1   |               1 | No             | No             | No             | No             | No             | No             | No              | No             | Yes            | Yes            | Yes            | Yes            | No         | No             | No             | No             | No             | No             |             7 |
| 2013-01-08 00:00:00.000 | No               | 2013-01 |   2013 | 13-01-08     | 01-08     | Q1                | 2013-Q1   |               1 | No             | No             | No             | No             | No             | No             | No              | No             | Yes            | Yes            | Yes            | Yes            | No         | No             | No             | No             | No             | No             |             8 |
| 2013-01-09 00:00:00.000 | No               | 2013-01 |   2013 | 13-01-09     | 01-09     | Q1                | 2013-Q1   |               1 | No             | No             | No             | No             | No             | No             | No              | No             | Yes            | Yes            | Yes            | Yes            | No         | No             | No             | No             | No             | No             |             9 |


Table: Dividends
| Symbol   | PayDate                 |   DividendPerShare | DivPerShare1   | DivPerShare2   | DivPerShare3   | DivPerShare4   | DivPerShare5   |
|:---------|:------------------------|-------------------:|:---------------|:---------------|:---------------|:---------------|:---------------|
| * Cash   | 2016-04-20 00:00:00.000 |              1e-10 |                |                |                |                |                |
| DVY      | 2016-03-23 00:00:00.000 |              0.63  | 0.63           | 0.831789       |                |                |                |
| DVY      | 2015-12-24 00:00:00.000 |              0.693 | 0.693          | 0.9594585      |                |                |                |
| DVY      | 2015-09-25 00:00:00.000 |              0.652 | 0.652          | 0.86879        |                |                |                |
| DVY      | 2015-06-24 00:00:00.000 |              0.646 | 0.646          | 0.802009       |                |                |                |
| DVY      | 2015-03-25 00:00:00.000 |              0.598 | 0.598          | 0.7482774      |                |                |                |
| DVY      | 2014-12-24 00:00:00.000 |              0.62  | 0.62           | 0.720626       |                |                |                |
| DVY      | 2014-09-24 00:00:00.000 |              0.587 | 0.587          | 0.650983       |                |                |                |
| DVY      | 2014-06-24 00:00:00.000 |              0.595 | 0.595          | 0.63903        |                |                |                |
| DVY      | 2014-03-25 00:00:00.000 |              0.604 | 0.604          | 0.6750304      |                |                |                |


Table: Quotes
| Symbol   | Date                    |   Price1 |   Price2 | Price3   |   Close | Price4   | Price5   |
|:---------|:------------------------|---------:|---------:|:---------|--------:|:---------|:---------|
| AAPL     | 2012-12-31 00:00:00.000 |   532.17 |  529.456 |          |  532.17 |          |          |
| AAPL     | 2013-01-31 00:00:00.000 |   455.49 |  455.126 |          |  455.49 |          |          |
| AAPL     | 2013-02-28 00:00:00.000 |   441.4  |  453.98  |          |  441.4  |          |          |
| AAPL     | 2013-03-28 00:00:00.000 |   442.66 |  449.566 |          |  442.66 |          |          |
| AAPL     | 2013-04-30 00:00:00.000 |   442.78 |  445.968 |          |  442.78 |          |          |
| AAPL     | 2013-05-31 00:00:00.000 |   449.73 |  464.976 |          |  449.73 |          |          |
| AAPL     | 2013-06-28 00:00:00.000 |   396.53 |  416.832 |          |  396.53 |          |          |
| AAPL     | 2013-07-31 00:00:00.000 |   452.53 |  465.518 |          |  452.53 |          |          |
| AAPL     | 2013-08-30 00:00:00.000 |   487.22 |  514.163 |          |  487.22 |          |          |
| AAPL     | 2013-09-30 00:00:00.000 |   476.75 |  490.337 |          |  476.75 |          |          |


Table: Report
| Report   |
|:---------|
| Report   |


Table: ReportCurrency
| ReportCurrency   |   CurrencyID |
|:-----------------|-------------:|
| *Original*       |            0 |
| USD              |            1 |
| CAD              |            2 |


Table: Symbol
| Symbol   | SymbolName              | Currency   | MER   | Allocation   | SymbolGroup1   | SymbolGroup2   | SymbolGroup3   | Region   |   WHTPercent |
|:---------|:------------------------|:-----------|:------|:-------------|:---------------|:---------------|:---------------|:---------|-------------:|
| * Cash   | Cash Value              | Cash       | 1E-09 | Cash         | Cash           | Cash           | Cash           | N/A      |        1e-07 |
| ^GSPC    | S&P 500                 | USD        | 0     | US Broad     | Index          | Index          | Index          | US       |        0     |
| ^GSPTSE  | S&P/TSX Composite index | CAD        | 0     | CDN Broad    | Index          | Index          | Index          | Canada   |        0     |
| WMT      | Wal-Mart Stores Inc.    | USD        |       | US Broad     | Stock          |                |                |          |        0     |
| AAPL     | Apple Inc.              | USD        |       | US Broad     | Stock          |                |                |          |        0     |
| MSFT     | Microsoft Corporation   | USD        |       | US Broad     | Stock          |                |                |          |        0     |
| DVY      | iShares Select Dividend | USD        | 0.004 | US Broad     | ETF            |                |                |          |        0     |
| GOOG     | Google Inc.             | USD        |       | US Broad     | Stock          |                |                |          |        0     |
| MCD      | McDonalds Corporation   | USD        |       | US Broad     | Stock          |                |                |          |        0     |
| VNQ      | Vanguard REIT Index ETF | USD        | 0.001 | US Broad     | ETF            | Real Estate    |                |          |        0     |


Table: SymbolSector
| Symbol   | Sector       |   Percent | Sensitivity   |
|:---------|:-------------|----------:|:--------------|
| ^GSPC    | Other        |    1      | Other         |
| ^GSPTSE  | Other        |    1      | Other         |
| AAPL     | Technology   |    1      | Sensitive     |
| DVY      | Communic.    |    0.0235 | Sensitive     |
| DVY      | Cons.Cycl.   |    0.094  | Cyclical      |
| DVY      | Cons.Defens. |    0.1371 | Defensive     |
| DVY      | Energy       |    0.0877 | Sensitive     |
| DVY      | Financial    |    0.0961 | Cyclical      |
| DVY      | Healthcare   |    0.0412 | Defensive     |
| DVY      | Industrials  |    0.1403 | Sensitive     |


Table: Trans
|   QtyHeldBeforeSale |   QtyHeldEoDFlag |   CBCycleNo |   SellNo |   CBBuyToDate |   CostBasisImpact |   ExchRate1 |   TotalAmntRpt1 |   ExchRate2 | ExchRate3   |   TotalAmntRpt2 |   TotalAmntRpt3 |   CBBuyToDateRpt1 |   CBBuyToDateRpt2 |   CBBuyToDateRpt3 |   CostBasisImpactRpt1 |   CostBasisImpactRpt2 |   CostBasisImpactRpt3 | Account    | Date                    | TransType   | TransSubType   | SymbolName   |     Qty |     Price | Fee   | ExchRate   | Comment                                  | CostBasisOverride   | AccruedInterest   | ExchRateRpt1Override   | ExchRateRpt2Override   | ExchRateRpt3Override   |   TTR |   TotalAmnt |   CashImpact |   CashBalance |   QtyChange |   QtyHeld | Symbol   |   TransID |    QHBS |       CBI | ExchRate4   | ExchRate5   |   TotalAmntRpt4 |   TotalAmntRpt5 |   CBBuyToDateRpt4 |   CBBuyToDateRpt5 |   CostBasisImpactRpt4 |   CostBasisImpactRpt5 |
|--------------------:|-----------------:|------------:|---------:|--------------:|------------------:|------------:|----------------:|------------:|:------------|----------------:|----------------:|------------------:|------------------:|------------------:|----------------------:|----------------------:|----------------------:|:-----------|:------------------------|:------------|:---------------|:-------------|--------:|----------:|:------|:-----------|:-----------------------------------------|:--------------------|:------------------|:-----------------------|:-----------------------|:-----------------------|------:|------------:|-------------:|--------------:|------------:|----------:|:---------|----------:|--------:|----------:|:------------|:------------|----------------:|----------------:|------------------:|------------------:|----------------------:|----------------------:|
|                   0 |                1 |           0 |        0 |             0 |              0    |     1.00001 |      0.00100001 |     1.00001 | 1.00001     |      0.00100001 |               0 |                 0 |                 0 |                 0 |                  0    |                  0    |                     0 | HisUSD     | 2012-12-31 00:00:00.000 | Deposit     | System         | * Cash       |   0.001 |     0.001 | 1E-05 | 1.0000001  | DO NOT DELETE. Adjust Date and Portfolio | 0.001               | 1E-05             | 1.00001                | 1.00001                | 1.00001                |     4 |       0.001 |        0.001 |         0.001 |       0.001 |    0.0001 | * Cash   |         2 |   1e-05 |     1e-05 |             |             |               0 |               0 |                 0 |                 0 |                     0 |                     0 |
|                   0 |                0 |           0 |        0 |             0 |              0    |     0.9917  |   7437.75       |     1       |             |   7500          |               0 |                 0 |                 0 |                 0 |                  0    |                  0    |                     0 | HisCDN     | 2013-05-01 00:00:00.000 | Deposit     |                | * Cash       |   1     |  7500     |       |            |                                          |                     |                   |                        |                        |                        |     4 |    7500     |     7500     |      7500     |       0     |    0      | * Cash   |         3 |   0     |     0     |             |             |               0 |               0 |                 0 |                 0 |                     0 |                     0 |
|                   0 |                1 |           1 |        0 |             0 |           7065.99 |     0.9917  |   7007.34       |     1       |             |   7065.99       |               0 |                 0 |                 0 |                 0 |               7007.34 |               7065.99 |                     0 | HisCDN     | 2013-05-01 00:00:00.000 | Buy         |                | XEI.TO       | 350     |    20.16  | 9.99  |            |                                          |                     |                   |                        |                        |                        |     2 |    7065.99  |    -7065.99  |       434.01  |     350     |  350      | XEI.TO   |         4 | 350     |  7065.99  |             |             |               0 |               0 |                 0 |                 0 |                     0 |                     0 |
|                   0 |                0 |           0 |        0 |             0 |              0    |     1       |   6000          |     1.0027  |             |   6016.2        |               0 |                 0 |                 0 |                 0 |                  0    |                  0    |                     0 | HersTaxUSD | 2013-05-09 00:00:00.000 | Deposit     |                | * Cash       |   1     |  6000     |       |            |                                          |                     |                   |                        |                        |                        |     4 |    6000     |     6000     |      6000     |       0     |    0      | * Cash   |         5 |   0     |     0     |             |             |               0 |               0 |                 0 |                 0 |                     0 |                     0 |
|                   0 |                1 |           1 |        0 |             0 |           5067.99 |     1       |   5067.99       |     1.0124  |             |   5130.83       |               0 |                 0 |                 0 |                 0 |               5067.99 |               5130.83 |                     0 | HersTaxUSD | 2013-05-10 00:00:00.000 | Buy         |                | VTI          |  60     |    84.3   | 9.99  |            |                                          |                     |                   |                        |                        |                        |     2 |    5067.99  |    -5067.99  |       932.01  |      60     |   60      | VTI      |         6 |  60     |  5067.99  |             |             |               0 |               0 |                 0 |                 0 |                     0 |                     0 |
|                   0 |                1 |           0 |        0 |             0 |              0    |     1       |   8100          |     1.037   |             |   8399.7        |               0 |                 0 |                 0 |                 0 |                  0    |                  0    |                     0 | HisUSD     | 2013-05-29 00:00:00.000 | Deposit     |                | * Cash       |   1     |  8100     |       |            |                                          |                     |                   |                        |                        |                        |     4 |    8100     |     8100     |      8100     |       0     |    0      | * Cash   |         7 |   0     |     0     |             |             |               0 |               0 |                 0 |                 0 |                     0 |                     0 |
|                   0 |                0 |           0 |        0 |             0 |              0    |     1       |  14500          |     1.021   |             |  14804.5        |               0 |                 0 |                 0 |                 0 |                  0    |                  0    |                     0 | HersUSD    | 2013-06-07 00:00:00.000 | Deposit     |                | * Cash       |   1     | 14500     |       |            |                                          |                     |                   |                        |                        |                        |     4 |   14500     |    14500     |     14500     |       0     |    0      | * Cash   |         8 |   0     |     0     |             |             |               0 |               0 |                 0 |                 0 |                     0 |                     0 |
|                   0 |                1 |           1 |        0 |             0 |          14010    |     1       |  14010          |     1.0202  |             |  14293          |               0 |                 0 |                 0 |                 0 |              14010    |              14293    |                     0 | HersUSD    | 2013-06-12 00:00:00.000 | Buy         |                | MSFT         | 400     |    35     | 9.99  |            |                                          |                     |                   |                        |                        |                        |     2 |   14010     |   -14010     |       490.01  |     400     |  400      | MSFT     |         9 | 400     | 14010     |             |             |               0 |               0 |                 0 |                 0 |                     0 |                     0 |
|                   0 |                1 |           1 |        0 |             0 |           8059.99 |     1       |   8059.99       |     1.0202  |             |   8222.8        |               0 |                 0 |                 0 |                 0 |               8059.99 |               8222.8  |                     0 | HisUSD     | 2013-06-12 00:00:00.000 | Buy         |                | MSFT         | 230     |    35     | 9.99  |            |                                          |                     |                   |                        |                        |                        |     2 |    8059.99  |    -8059.99  |        40.01  |     230     |  230      | MSFT     |        10 | 230     |  8059.99  |             |             |               0 |               0 |                 0 |                 0 |                     0 |                     0 |
|                   0 |                0 |           0 |        0 |             0 |              0    |     1       |  10000          |     1.0176  |             |  10176          |               0 |                 0 |                 0 |                 0 |                  0    |                  0    |                     0 | HisTaxUSD  | 2013-06-17 00:00:00.000 | Deposit     |                | * Cash       |   1     | 10000     |       |            |                                          |                     |                   |                        |                        |                        |     4 |   10000     |    10000     |     10000     |       0     |    0      | * Cash   |        11 |   0     |     0     |             |             |               0 |               0 |                 0 |                 0 |                     0 |                     0 |


Table: TransType
|   ExternalImpactPortfolioSignCalc | TransType       |   IgnoreQtyFlag |   TransFeeSign |   CashAmntSign |   BookValueSign |   QtySign |   DistribReturnOfCapitalFlag |   DistribCapGainReinvstdFlag |   DividendFlag |   DepositTransSign |   CashImpactSign |   SellFlag |   WithholdingTaxFlag |   FeeFlag |   ExternalImpactSymbolSign |   ExternalImpactPortfolioSign |   ExternalImpactPortfolioSign2 | ShowForSalesReport   | TransTypeGroup   | TransDescription                                                                                                   |   CashFlag |   ExchRateFlag |
|----------------------------------:|:----------------|----------------:|---------------:|---------------:|----------------:|----------:|-----------------------------:|-----------------------------:|---------------:|-------------------:|-----------------:|-----------:|---------------------:|----------:|---------------------------:|------------------------------:|-------------------------------:|:---------------------|:-----------------|:-------------------------------------------------------------------------------------------------------------------|-----------:|---------------:|
|                                -1 | BankFee         |               1 |             -1 |             -1 |               0 |         0 |                            0 |                            0 |              0 |                  0 |               -1 |          0 |                    0 |         1 |                          0 |                            -1 |                             -1 | Yes                  | Fee              | Bank fee - account administration/transfer etc fees                                                                |          1 |              0 |
|                                 0 | Buy             |               0 |              1 |             -1 |               1 |         1 |                            0 |                            0 |              0 |                  0 |               -1 |          0 |                    0 |         0 |                          1 |                             0 |                              1 | Yes                  | Buy              | Buying shares by specifying number of shares and price per share                                                   |          0 |              1 |
|                                 0 | BuyTA           |               1 |              1 |             -1 |               1 |         1 |                            0 |                            0 |              0 |                  0 |               -1 |          0 |                    0 |         0 |                          1 |                             0 |                              1 | Yes                  | Buy              | Buying shares by specifying quantity and total amount (not price per share)                                        |          0 |              1 |
|                                 1 | Deposit         |               1 |             -1 |              1 |               0 |         0 |                            0 |                            0 |              0 |                  1 |                1 |          0 |                    0 |         0 |                          0 |                             1 |                              1 | Yes                  | Deposit          | Deposit cash into portfolio                                                                                        |          1 |              0 |
|                                 0 | DIV             |               0 |             -1 |              1 |               0 |         0 |                            0 |                            0 |              1 |                  0 |                1 |          0 |                    0 |         0 |                          0 |                             0 |                             -1 | No                   | Dividend         | Dividends received by specifying number of shares and dividend per share. Money are added to portfolio cash amount |          0 |              0 |
|                                 0 | DivTA           |               1 |             -1 |              1 |               0 |         0 |                            0 |                            0 |              1 |                  0 |                1 |          0 |                    0 |         0 |                          0 |                             0 |                             -1 | No                   | Dividend         | Dividends received by specifying number of shares and total dividend amount. TransQty is ignored                   |          0 |              0 |
|                                 0 | DRIP            |               0 |             -1 |              0 |               1 |         1 |                            0 |                            0 |              1 |                  0 |                1 |          0 |                    0 |         0 |                          1 |                             0 |                              0 | Yes                  | Dividend         | Dividends received and invested back into the same equity                                                          |          0 |              0 |
|                                 0 | INT             |               1 |             -1 |              1 |               0 |         0 |                            0 |                            0 |              1 |                  0 |                1 |          0 |                    0 |         0 |                          0 |                             0 |                             -1 | No                   | Interest         | Interest received. Amount is added to portfolio cash value                                                         |          1 |              0 |
|                                 0 | NotionalDistrib |               1 |              0 |              0 |               1 |         0 |                            0 |                            1 |              0 |                  0 |                0 |          0 |                    0 |         0 |                          0 |                             0 |                              0 | Yes                  | Div Reinv        | Dividends - Notional Distribution - Capital Gains Increases Book value!                                            |          0 |              0 |
|                                 0 | ReturnOfCapital |               1 |             -1 |              1 |              -1 |         0 |                            1 |                            0 |              1 |                  0 |                1 |          0 |                    0 |         0 |                          0 |                             0 |                             -1 | Yes                  | Dividend         | Dividends - Return of Capital - Decreases book value!                                                              |          0 |              0 |

 


tables: name: Account
data: Account.csv
name: Allocation
data: Allocation.csv
name: Config
data: Config.csv
name: CurrencyConv
data: CurrencyConv.csv
name: Dates
data: Dates.csv
name: Dividends
data: Dividends.csv
name: Quotes
data: Quotes.csv
name: Report
data: Report.csv
name: ReportCurrency
data: ReportCurrency.csv
name: Symbol
data: Symbol.csv
name: SymbolSector
data: SymbolSector.csv
name: Trans
data: Trans.csv
name: TransType
data: TransType.csv
label: CurrencyConv
Date
Dates
Date
Quotes
Date
Dates
Date
Dividends
PayDate
Dates
Date
Trans
Account
Account
Account
Trans
TransType
TransType
TransType
Trans
Symbol
Symbol
Symbol
SymbolSector
Symbol
Symbol
Symbol
Quotes
Symbol
Symbol
Symbol
Dividends
Symbol
Symbol
Symbol
Symbol
Allocation
Allocation
Allocation
Trans
Date
Dates
Date
output: {
    "joins": [
        {
            "from_table": "CurrencyConv",
            "from_column": "Date",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "Quotes",
            "from_column": "Date",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "Dividends",
            "from_column": "PayDate",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "Trans",
            "from_column": "Account",
            "to_table": "Account",
            "to_column": "Account"
        },
        {
            "from_table": "Trans",
            "from_column": "TransType",
            "to_table": "TransType",
            "to_column": "TransType"
        },
        {
            "from_table": "Trans",
            "from_column": "Symbol",
            "to_table": "Symbol",
            "to_column": "Symbol"
        },
        {
            "from_table": "SymbolSector",
            "from_column": "Symbol",
            "to_table": "Symbol",
            "to_column": "Symbol"
        },
        {
            "from_table": "Quotes",
            "from_column": "Symbol",
            "to_table": "Symbol",
            "to_column": "Symbol"
        },
        {
            "from_table": "Dividends",
            "from_column": "Symbol",
            "to_table": "Symbol",
            "to_column": "Symbol"
        },
        {
            "from_table": "Symbol",
            "from_column": "Allocation",
            "to_table": "Allocation",
            "to_column": "Allocation"
        },
        {
            "from_table": "Trans",
            "from_column": "Date",
            "to_table": "Dates",
            "to_column": "Date"
        }
    ]
}