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: ActiveContributors
| RepositoryName   | Date                    | AuthorLogins                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | author   | SiteName   | TenantName   |
|:-----------------|:------------------------|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:---------|:-----------|:-------------|
| azure-content    | 2016-02-26 00:00:00.000 | fenxu                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | fenxu    | Docs       | c+e          |
| azure-content    | 2016-04-28 00:00:00.000 | rnagpal,sidneyh,tysonn,curtand,spelluru,ggailey777,JoeDavies-MSFT,msmbaldwin,markgalioto,barbkess,v-cmans,cjgronlund,MattKotsenas,annemill,bradsev,cherylmc,TheBeardedLlama,ErikjeMS,dvana,Juliako,ahmetalpbalkan,MikeRayMSFT,edmacauley,MarkusVi,fenxu,,vlivech,MonicaRush,AndrewHoh,sonyam,Dmitry-Me,JiangChen79,genlin,alancameronwills,Blackmist,mikhailalmeida,AndKjell,rothja,Jim-Parker,squillace,tdykstra,v-anpasi,mimig1,nitinme,steved0x,msStevenPo,JennieHubbard,lizap                                                                                         | fenxu    | Docs       | c+e          |
| azure-content    | 2016-04-29 00:00:00.000 | JiangChen79,CamSoper,barbkess,,alancameronwills,Juliako,JPallavi,dominicbetts,brohrer-ms,PepijnGramberg,steved0x,mahesh-unnikrishnan,tysonn,cynthn,Jim-Parker,ellenfosborne,ggailey777,sidneyh,cjgronlund,alkohli,BryanLa,iainfoulds,tfitzmac,piyushjo,v-anpasi,ganesr,mattchenderson,ShawnJackson,sonyam,dlepow,ErikjeMS,YuriDio,kgremban,garyericson,mimig1,MikeRayMSFT,squillace,Blackmist,bradsev,stevestein,v-jacard,curtand,Thraka,MightyPen,v-cmans,vlivech,tdykstra,fenxu,MSFTMan,lizap                                                                           | fenxu    | Docs       | c+e          |
| azure-content    | 2016-05-02 00:00:00.000 | jeffgoll,sidneyh,SunBuild,arambarri,,billmath,nkolli1,annemill,stevestein,krisragh,NataliaL,Juliako,ggailey777,CamSoper,curtand,JimVance,barbkess,dominicbetts,spelluru,MarkusVi,alkohli,nitinme,v-anpasi,robinsh,sonyam,MSFTMan,piyushjo,BrucePerlerMS,chaosrealm,BryanLa,kgremban,cjgronlund,v-cmans,fenxu,vmuthukumaran,rmcmurray,jeffstokes72,CarlRabeler,tysonn,Jim-Parker,rothja,tdykstra,lizap                                                                                                                                                                     | fenxu    | Docs       | c+e          |
| azure-content    | 2016-05-03 00:00:00.000 | alexandair,Jim-Parker,fenxu,BryanLa,lizap                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | fenxu    | Docs       | c+e          |
| azure-content    | 2016-05-05 00:00:00.000 | tysonn,tdykstra,,jaymathe,v-anpasi,Jim-Parker,shchauh,sidneyh,SeanFeldman,fenxu,LuisCabrer,billmath,annemill,anzaman,BryanLa,RickSaling,ggailey777,stephbaron,MSFTMan,barbkess,Juliako,adrianhall,DavidBosland,rmcmurray,bandersmsft,MikeWasson,sonyam,bennage,kgremban,cjgronlund,nitinme,v-cmans,jeffhollan,lodipalm,MarkusVi,chaosrealm,jodoglevy,alexandair,Blackmist,MandiOhlinger,DuncanmaMSFT,lizap                                                                                                                                                                | fenxu    | Docs       | c+e          |
| azure-content    | 2016-05-06 00:00:00.000 | cjgronlund,rothja,Jim-Parker,NataliaL,wesmc7777,arramac,steelanddata,fenxu,nitinme,lodipalm,,cynthn,mahthi,Rajani-Janaki-Ram,dvana,LuisCabrer,iainfoulds,anosov1960,v-cmans,chaosrealm,CarlRabeler,ggailey777,tysonn,happynicolle,telmosampaio,barbkess,BryanLa,JiangChen79,sonyam,rnagpal,olprod,Juliako,Deland-Han,Blackmist,trinadhk,bradsev,DonHartman,onewth,haroldwongms,jomolnar,cabailey,dhanyahk,v-anpasi,tdykstra,ChackDan,micurd,alkohli,karolz-ms,singhkay,lizap,sethmanheim,sidneyh,YuriDio,anzaman                                                          | fenxu    | Docs       | c+e          |
| azure-content    | 2016-05-10 00:00:00.000 | cherylmc,jimdial,rothja,PRmerger,viv-liu,CamSoper,sethmanheim,CarlRabeler,RickSaling,mimig1,tdykstra,Jim-Parker,spelluru,v-cmans,cjgronlund,JasonGerend,dvana,fenxu,bwren,curtand,happynicolle,Juliako,mscurrell,cynthn,robinsh,aarondandy,dalechen,guperrot,JiangChen79,kgremban,ruturaj,MSFTMan,yijichen,ggailey777,rmcmurray,Blackmist,,YuriDio,steved0x,AndKjell,markgalioto,BryanLa,BYHAM,raymondlaghaeian,v-anpasi,tysonn,MikeRayMSFT,MGoedtel,sonyam,MandiOhlinger,neilpeterson,barbkess,stevestein,miaojiang,ChrisMissal,anandyadavMSFT,v-jacard,msStevenPo,lizap | fenxu    | Docs       | c+e          |
| azure-content    | 2016-05-11 00:00:00.000 | jurajsucik,spelluru,,billmath,markgalioto,Rajani-Janaki-Ram,iainfoulds,bwren,rayne-wiselman,alkohli,JasonGerend,Jim-Parker,MGoedtel,cherylmc,kgremban,CamSoper,curtand,happynicolle,nitinme,PRmerger,sethmanheim,bandersmsft,BryanLa,MikeWasson,lindydonna,tysonn,richrundmsft,barbkess,fenxu,sonyam,chaosrealm,Juliako,neilpeterson,v-jacard,trinadhk,alancameronwills,BYHAM,ggailey777,cjgronlund,v-anpasi,lizap                                                                                                                                                        | fenxu    | Docs       | c+e          |
| azure-content    | 2016-05-12 00:00:00.000 | curtand,Jim-Parker,MGoedtel,CarlRabeler,PRmerger,karolz-ms,YuriDio,bandersmsft,richrundmsft,trinadhk,stevestein,Juliako,AndrewHoh,annemill,rwike77,rmcmurray,barbkess,tfitzmac,ggailey777,rothja,AndKjell,v-cmans,anandyadavMSFT,BryanLa,alkohli,robinsh,cristhianu,harshakirank,guperrot,nitinme,garyericson,fenxu,MSFTMan,tdykstra,charwen,dbrust,animetauren,chaosrealm,vmuthukumaran,genlin,saurabhsensharma,cephalin,tysonn,cjgronlund,sonyam,v-anpasi,cherylmc,MightyPen,mmacy,billmath,sethmanheim,glittle,lizap                                                   | fenxu    | Docs       | c+e          |


Table: DateList
| Date                    |
|:------------------------|
| 2016-01-01 00:00:00.000 |
| 2016-01-02 00:00:00.000 |
| 2016-01-03 00:00:00.000 |
| 2016-01-04 00:00:00.000 |
| 2016-01-05 00:00:00.000 |
| 2016-01-06 00:00:00.000 |
| 2016-01-07 00:00:00.000 |
| 2016-01-08 00:00:00.000 |
| 2016-01-09 00:00:00.000 |
| 2016-01-10 00:00:00.000 |


Table: PerDayPublish
| RepositoryName   | PublishDate             |   Succeeded |   Failed | SiteName   | TenantName   |
|:-----------------|:------------------------|------------:|---------:|:-----------|:-------------|
| windows-apps     | 2016-03-01 00:00:00.000 |           1 |        0 | MSDN       | wdg          |
| windows-apps     | 2016-03-02 00:00:00.000 |           1 |        0 | MSDN       | wdg          |
| windows-apps     | 2016-03-03 00:00:00.000 |           1 |        0 | MSDN       | wdg          |
| windows-apps     | 2016-03-04 00:00:00.000 |           1 |        0 | MSDN       | wdg          |
| windows-apps     | 2016-03-05 00:00:00.000 |           1 |        0 | MSDN       | wdg          |
| windows-apps     | 2016-03-07 00:00:00.000 |           1 |        0 | MSDN       | wdg          |
| windows-apps     | 2016-03-08 00:00:00.000 |           1 |        0 | MSDN       | wdg          |
| windows-apps     | 2016-03-15 00:00:00.000 |           1 |        0 | MSDN       | wdg          |
| windows-apps     | 2016-03-16 00:00:00.000 |           1 |        0 | MSDN       | wdg          |
| windows-apps     | 2016-03-17 00:00:00.000 |           1 |        0 | MSDN       | wdg          |


Table: PerDayPullRequest
| RepositoryName   | Date                    |   Number of PullRequest | SiteName     | TenantName   |
|:-----------------|:------------------------|------------------------:|:-------------|:-------------|
| Content.VS       | 2015-05-15 00:00:00.000 |                       1 | VisualStudio | c+e          |
| Content.VS       | 2015-05-16 00:00:00.000 |                       1 | VisualStudio | c+e          |
| Content.VS       | 2015-05-19 00:00:00.000 |                       1 | VisualStudio | c+e          |
| Content.VS       | 2015-05-26 00:00:00.000 |                       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-02 00:00:00.000 |                       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-05 00:00:00.000 |                       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-06 00:00:00.000 |                       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-11 00:00:00.000 |                       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-13 00:00:00.000 |                       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-22 00:00:00.000 |                       1 | VisualStudio | c+e          |


Table: PerMonthContributors
| RepositoryName               | Month   |   Number of Contributors | SiteName   | TenantName   |
|:-----------------------------|:--------|-------------------------:|:-----------|:-------------|
| aad-graph-api-docs-for-em-pr | 2016/01 |                        0 | Docs       | c+e          |
| aad-graph-api-docs-for-em-pr | 2016/02 |                        0 | Docs       | c+e          |
| aad-graph-api-docs-for-em-pr | 2016/06 |                        0 | Docs       | c+e          |
| ADALRef-pr                   | 2016/01 |                        0 | Docs       | c+e          |
| ADALRef-pr                   | 2016/05 |                        0 | Docs       | c+e          |
| ADALRef-pr                   | 2016/06 |                        0 | Docs       | c+e          |
| ADALRef-pr                   | 2016/07 |                        0 | Docs       | c+e          |
| ADALRef-pr                   | 2016/08 |                        0 | Docs       | c+e          |
| ATADocs-pr                   | 2016/01 |                        0 | Docs       | c+e          |
| azure-content                | 2016/01 |                        0 | Docs       | c+e          |


Table: PublishByAction
| RepositoryName            | PublishDate             | SiteName   | TenantName   | Status   |   PublishCount |
|:--------------------------|:------------------------|:-----------|:-------------|:---------|---------------:|
| CommandLine-Documentation | 2016-05-25 00:00:00.000 | MSDN       | wdg          | Edit     |              1 |
| CommandLine-Documentation | 2016-06-01 00:00:00.000 | MSDN       | wdg          | Edit     |              1 |
| CommandLine-Documentation | 2016-06-09 00:00:00.000 | MSDN       | wdg          | Edit     |              1 |
| CommandLine-Documentation | 2016-06-14 00:00:00.000 | MSDN       | wdg          | Edit     |              1 |
| CommandLine-Documentation | 2016-06-17 00:00:00.000 | MSDN       | wdg          | Edit     |              1 |
| CommandLine-Documentation | 2016-06-29 00:00:00.000 | MSDN       | wdg          | Edit     |              1 |
| CommandLine-Documentation | 2016-07-01 00:00:00.000 | MSDN       | wdg          | Edit     |              1 |
| CommandLine-Documentation | 2016-07-08 00:00:00.000 | MSDN       | wdg          | Edit     |              1 |
| CommandLine-Documentation | 2016-07-14 00:00:00.000 | MSDN       | wdg          | Edit     |              1 |
| CommandLine-Documentation | 2016-08-03 00:00:00.000 | MSDN       | wdg          | Edit     |              1 |


Table: PublishByCodeLinesNumber
| RepositoryName   | Date                    | Category         |   Deletions |   Insertions | SiteName   | TenantName   |
|:-----------------|:------------------------|:-----------------|------------:|-------------:|:-----------|:-------------|
| Azure-RMSDocs-pr | 2016-05-27 00:00:00.000 | 0                |           0 |            0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-05-27 00:00:00.000 | 001              |           0 |            0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-05-27 00:00:00.000 | 006~010          |           0 |            0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-05-27 00:00:00.000 | 011~020          |           0 |            0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-05-27 00:00:00.000 | 021~050          |           0 |            0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-05-27 00:00:00.000 | 051~100          |           0 |            0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-05-27 00:00:00.000 | 101~200          |           0 |            0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-05-27 00:00:00.000 | 201~500          |           0 |            0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-05-27 00:00:00.000 | greater than 500 |           0 |            0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-05-31 00:00:00.000 | 0                |           0 |            0 | Docs       | c+e          |


Table: PublishByTopicsNumber
| RepositoryName                       | Date                    | Number of Topics Per Publish   |   Total | SiteName   | TenantName   |
|:-------------------------------------|:------------------------|:-------------------------------|--------:|:-----------|:-------------|
| Virtualization-Documentation-Private | 2015-11-30 00:00:00.000 | 051~100                        |       0 | MSDN       | wdg          |
| Virtualization-Documentation-Private | 2015-12-01 00:00:00.000 | 051~100                        |       0 | MSDN       | wdg          |
| Virtualization-Documentation-Private | 2015-12-02 00:00:00.000 | 051~100                        |       0 | MSDN       | wdg          |
| Virtualization-Documentation-Private | 2015-12-03 00:00:00.000 | 051~100                        |       0 | MSDN       | wdg          |
| Virtualization-Documentation-Private | 2015-12-04 00:00:00.000 | 051~100                        |       0 | MSDN       | wdg          |
| Virtualization-Documentation-Private | 2015-12-07 00:00:00.000 | 051~100                        |       0 | MSDN       | wdg          |
| Virtualization-Documentation-Private | 2015-12-09 00:00:00.000 | 051~100                        |       0 | MSDN       | wdg          |
| Virtualization-Documentation-Private | 2015-12-10 00:00:00.000 | 051~100                        |       0 | MSDN       | wdg          |
| Virtualization-Documentation-Private | 2015-12-11 00:00:00.000 | 051~100                        |       0 | MSDN       | wdg          |
| Virtualization-Documentation-Private | 2015-12-16 00:00:00.000 | 051~100                        |       0 | MSDN       | wdg          |


Table: PullRequestByCommitNumber
| RepositoryName   | Date                    | Commits Number   |   Total | SiteName   | TenantName   |
|:-----------------|:------------------------|:-----------------|--------:|:-----------|:-------------|
| IntuneDocs-pr    | 2016-04-29 00:00:00.000 | 101~200          |       0 | Docs       | c+e          |
| IntuneDocs-pr    | 2016-05-03 00:00:00.000 | 101~200          |       0 | Docs       | c+e          |
| IntuneDocs-pr    | 2016-05-04 00:00:00.000 | 101~200          |       0 | Docs       | c+e          |
| IntuneDocs-pr    | 2016-05-05 00:00:00.000 | 101~200          |       0 | Docs       | c+e          |
| IntuneDocs-pr    | 2016-05-06 00:00:00.000 | 101~200          |       0 | Docs       | c+e          |
| IntuneDocs-pr    | 2016-05-07 00:00:00.000 | 101~200          |       0 | Docs       | c+e          |
| IntuneDocs-pr    | 2016-05-10 00:00:00.000 | 101~200          |       0 | Docs       | c+e          |
| IntuneDocs-pr    | 2016-05-11 00:00:00.000 | 101~200          |       0 | Docs       | c+e          |
| IntuneDocs-pr    | 2016-05-12 00:00:00.000 | 101~200          |       0 | Docs       | c+e          |
| IntuneDocs-pr    | 2016-05-13 00:00:00.000 | 101~200          |       0 | Docs       | c+e          |


Table: PullRequestByDuration
| RepositoryName   |   Total | Date                    | Duration Time / mins   | TenantName   | SiteName     |
|:-----------------|--------:|:------------------------|:-----------------------|:-------------|:-------------|
| Content.VS       |       0 | 2015-05-16 00:00:00.000 | 500~1000               | c+e          | VisualStudio |
| Content.VS       |       0 | 2015-05-20 00:00:00.000 | 500~1000               | c+e          | VisualStudio |
| Content.VS       |       0 | 2015-05-22 00:00:00.000 | 500~1000               | c+e          | VisualStudio |
| Content.VS       |       0 | 2015-05-23 00:00:00.000 | 500~1000               | c+e          | VisualStudio |
| Content.VS       |       0 | 2015-05-26 00:00:00.000 | 500~1000               | c+e          | VisualStudio |
| Content.VS       |       0 | 2015-06-02 00:00:00.000 | 500~1000               | c+e          | VisualStudio |
| Content.VS       |       0 | 2015-06-04 00:00:00.000 | 500~1000               | c+e          | VisualStudio |
| Content.VS       |       0 | 2015-06-06 00:00:00.000 | 500~1000               | c+e          | VisualStudio |
| Content.VS       |       0 | 2015-06-09 00:00:00.000 | 500~1000               | c+e          | VisualStudio |
| Content.VS       |       0 | 2015-06-11 00:00:00.000 | 500~1000               | c+e          | VisualStudio |


Table: PullRequestByStatus
| RepositoryName   | Date                    | Status   |   Total | SiteName     | TenantName   |
|:-----------------|:------------------------|:---------|--------:|:-------------|:-------------|
| Content.VS       | 2015-05-16 00:00:00.000 | Accepted |       1 | VisualStudio | c+e          |
| Content.VS       | 2015-05-26 00:00:00.000 | Accepted |       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-02 00:00:00.000 | Accepted |       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-06 00:00:00.000 | Accepted |       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-09 00:00:00.000 | Accepted |       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-11 00:00:00.000 | Accepted |       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-16 00:00:00.000 | Accepted |       1 | VisualStudio | c+e          |
| Content.VS       | 2015-06-22 00:00:00.000 | Accepted |       1 | VisualStudio | c+e          |
| Content.VS       | 2015-07-03 00:00:00.000 | Accepted |       1 | VisualStudio | c+e          |
| Content.VS       | 2015-07-09 00:00:00.000 | Accepted |       1 | VisualStudio | c+e          |


Table: PullRequestByWordsNumber
| RepositoryName   | Date                    | Category          |   DeletionsOfWord |   InsertionsOfWord | SiteName   | TenantName   |
|:-----------------|:------------------------|:------------------|------------------:|-------------------:|:-----------|:-------------|
| Azure-RMSDocs-pr | 2016-04-29 00:00:00.000 | 0                 |                 0 |                  0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-04-29 00:00:00.000 | 002~005           |                 0 |                  0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-04-29 00:00:00.000 | 011~020           |                 0 |                  0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-04-29 00:00:00.000 | 021~050           |                 0 |                  0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-04-29 00:00:00.000 | 051~100           |                 0 |                  0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-04-29 00:00:00.000 | 101~200           |                 0 |                  0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-04-29 00:00:00.000 | 201~500           |                 0 |                  0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-04-29 00:00:00.000 | 501~1000          |                 0 |                  0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-04-29 00:00:00.000 | greater than 1000 |                 0 |                  0 | Docs       | c+e          |
| Azure-RMSDocs-pr | 2016-05-03 00:00:00.000 | 001               |                 0 |                  0 | Docs       | c+e          |


Table: RepositoryList
| RepositoryName               |
|:-----------------------------|
| aad-graph-api-docs-for-em-pr |
| aad-graph-api-docs-pr        |
| ADALRef-pr                   |
| ATADocs-pr                   |
| azure-content                |
| Azure-RMSDocs-pr             |
| CommandLine-Documentation    |
| commercialization            |
| Content.VS                   |
| Content.VS.Articles          |


Table: SiteList
| SiteName         |
|:-----------------|
| Docs             |
| MSDN             |
| TechNet          |
| TrustCenterChina |
| VisualStudio     |


Table: TenantList
| TenantName   |
|:-------------|
| asg          |
| c+e          |
| wdg          |


Table: TotalContributionsAndContributors
| RepositoryName                       | TableLastUpdatedAt      |   Contributors |   Contributions | SiteName   | TenantName   |
|:-------------------------------------|:------------------------|---------------:|----------------:|:-----------|:-------------|
| ATADocs-pr                           | 2016-09-08 00:00:00.000 |             24 |             499 | Docs       | c+e          |
| ADALRef-pr                           | 2016-09-08 00:00:00.000 |              1 |              14 | Docs       | c+e          |
| cortana-docs                         | 2016-09-08 00:00:00.000 |              7 |             384 | MSDN       | wdg          |
| core-docs                            | 2016-09-08 00:00:00.000 |             27 |            1023 | Docs       | c+e          |
| visualfsharpdocs                     | 2016-09-08 00:00:00.000 |             26 |             158 | MSDN       | c+e          |
| Azure-RMSDocs-pr                     | 2016-09-08 00:00:00.000 |              3 |            1187 | Docs       | c+e          |
| datatest                             | 2016-09-08 00:00:00.000 |              1 |               1 | Docs       | c+e          |
| EMDocs-pr                            | 2016-09-08 00:00:00.000 |             11 |             371 | Docs       | c+e          |
| skype-docs                           | 2016-09-08 00:00:00.000 |             10 |             537 | MSDN       | asg          |
| Virtualization-Documentation-Private | 2016-09-08 00:00:00.000 |             25 |            3772 | MSDN       | wdg          |

 


tables: name: ActiveContributors
data: ActiveContributors.csv
name: DateList
data: DateList.csv
name: PerDayPublish
data: PerDayPublish.csv
name: PerDayPullRequest
data: PerDayPullRequest.csv
name: PerMonthContributors
data: PerMonthContributors.csv
name: PublishByAction
data: PublishByAction.csv
name: PublishByCodeLinesNumber
data: PublishByCodeLinesNumber.csv
name: PublishByTopicsNumber
data: PublishByTopicsNumber.csv
name: PullRequestByCommitNumber
data: PullRequestByCommitNumber.csv
name: PullRequestByDuration
data: PullRequestByDuration.csv
name: PullRequestByStatus
data: PullRequestByStatus.csv
name: PullRequestByWordsNumber
data: PullRequestByWordsNumber.csv
name: RepositoryList
data: RepositoryList.csv
name: SiteList
data: SiteList.csv
name: TenantList
data: TenantList.csv
name: TotalContributionsAndContributors
data: TotalContributionsAndContributors.csv
label: PerDayPublish
RepositoryName
RepositoryList
RepositoryName
PerDayPublish
TenantName
TenantList
TenantName
PerDayPublish
SiteName
SiteList
SiteName
PerDayPullRequest
RepositoryName
RepositoryList
RepositoryName
PerDayPullRequest
TenantName
TenantList
TenantName
PerDayPullRequest
SiteName
SiteList
SiteName
PullRequestByCommitNumber
RepositoryName
RepositoryList
RepositoryName
PerDayPublish
PublishDate
DateList
Date
PerDayPullRequest
Date
DateList
Date
PullRequestByCommitNumber
Date
DateList
Date
PublishByAction
RepositoryName
RepositoryList
RepositoryName
PublishByAction
TenantName
TenantList
TenantName
PublishByAction
SiteName
SiteList
SiteName
PublishByCodeLinesNumber
RepositoryName
RepositoryList
RepositoryName
PublishByCodeLinesNumber
TenantName
TenantList
TenantName
PublishByCodeLinesNumber
SiteName
SiteList
SiteName
PublishByAction
PublishDate
DateList
Date
PublishByCodeLinesNumber
Date
DateList
Date
PublishByTopicsNumber
RepositoryName
RepositoryList
RepositoryName
PublishByTopicsNumber
Date
DateList
Date
PullRequestByDuration
RepositoryName
RepositoryList
RepositoryName
PullRequestByDuration
Date
DateList
Date
PullRequestByStatus
RepositoryName
RepositoryList
RepositoryName
PullRequestByStatus
TenantName
TenantList
TenantName
PullRequestByStatus
SiteName
SiteList
SiteName
PullRequestByStatus
Date
DateList
Date
ActiveContributors
RepositoryName
RepositoryList
RepositoryName
ActiveContributors
TenantName
TenantList
TenantName
ActiveContributors
SiteName
SiteList
SiteName
ActiveContributors
Date
DateList
Date
TotalContributionsAndContributors
RepositoryName
RepositoryList
RepositoryName
TotalContributionsAndContributors
TenantName
TenantList
TenantName
TotalContributionsAndContributors
SiteName
SiteList
SiteName
PerMonthContributors
RepositoryName
RepositoryList
RepositoryName
PerMonthContributors
TenantName
TenantList
TenantName
PerMonthContributors
SiteName
SiteList
SiteName
PullRequestByWordsNumber
RepositoryName
RepositoryList
RepositoryName
PullRequestByWordsNumber
TenantName
TenantList
TenantName
PullRequestByWordsNumber
SiteName
SiteList
SiteName
PullRequestByWordsNumber
Date
DateList
Date
PullRequestByCommitNumber
TenantName
TenantList
TenantName
PublishByTopicsNumber
TenantName
TenantList
TenantName
PullRequestByDuration
TenantName
TenantList
TenantName
PullRequestByCommitNumber
SiteName
SiteList
SiteName
PublishByTopicsNumber
SiteName
SiteList
SiteName
PullRequestByDuration
SiteName
SiteList
SiteName
output: {
    "joins": [
        {
            "from_table": "PerDayPublish",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "PerDayPublish",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "PerDayPublish",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        },
        {
            "from_table": "PerDayPullRequest",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "PerDayPullRequest",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "PerDayPullRequest",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        },
        {
            "from_table": "PullRequestByCommitNumber",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "PerDayPublish",
            "from_column": "PublishDate",
            "to_table": "DateList",
            "to_column": "Date"
        },
        {
            "from_table": "PerDayPullRequest",
            "from_column": "Date",
            "to_table": "DateList",
            "to_column": "Date"
        },
        {
            "from_table": "PullRequestByCommitNumber",
            "from_column": "Date",
            "to_table": "DateList",
            "to_column": "Date"
        },
        {
            "from_table": "PublishByAction",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "PublishByAction",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "PublishByAction",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        },
        {
            "from_table": "PublishByCodeLinesNumber",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "PublishByCodeLinesNumber",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "PublishByCodeLinesNumber",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        },
        {
            "from_table": "PublishByAction",
            "from_column": "PublishDate",
            "to_table": "DateList",
            "to_column": "Date"
        },
        {
            "from_table": "PublishByCodeLinesNumber",
            "from_column": "Date",
            "to_table": "DateList",
            "to_column": "Date"
        },
        {
            "from_table": "PublishByTopicsNumber",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "PublishByTopicsNumber",
            "from_column": "Date",
            "to_table": "DateList",
            "to_column": "Date"
        },
        {
            "from_table": "PullRequestByDuration",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "PullRequestByDuration",
            "from_column": "Date",
            "to_table": "DateList",
            "to_column": "Date"
        },
        {
            "from_table": "PullRequestByStatus",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "PullRequestByStatus",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "PullRequestByStatus",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        },
        {
            "from_table": "PullRequestByStatus",
            "from_column": "Date",
            "to_table": "DateList",
            "to_column": "Date"
        },
        {
            "from_table": "ActiveContributors",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "ActiveContributors",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "ActiveContributors",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        },
        {
            "from_table": "ActiveContributors",
            "from_column": "Date",
            "to_table": "DateList",
            "to_column": "Date"
        },
        {
            "from_table": "TotalContributionsAndContributors",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "TotalContributionsAndContributors",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "TotalContributionsAndContributors",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        },
        {
            "from_table": "PerMonthContributors",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "PerMonthContributors",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "PerMonthContributors",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        },
        {
            "from_table": "PullRequestByWordsNumber",
            "from_column": "RepositoryName",
            "to_table": "RepositoryList",
            "to_column": "RepositoryName"
        },
        {
            "from_table": "PullRequestByWordsNumber",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "PullRequestByWordsNumber",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        },
        {
            "from_table": "PullRequestByWordsNumber",
            "from_column": "Date",
            "to_table": "DateList",
            "to_column": "Date"
        },
        {
            "from_table": "PullRequestByCommitNumber",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "PublishByTopicsNumber",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "PullRequestByDuration",
            "from_column": "TenantName",
            "to_table": "TenantList",
            "to_column": "TenantName"
        },
        {
            "from_table": "PullRequestByCommitNumber",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        },
        {
            "from_table": "PublishByTopicsNumber",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        },
        {
            "from_table": "PullRequestByDuration",
            "from_column": "SiteName",
            "to_table": "SiteList",
            "to_column": "SiteName"
        }
    ]
}