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: AC Rules
| Armored Compartments     |
|:-------------------------|
| Allowed                  |
| Allowed on Platinum only |
| Not allowed              |


Table: Achievements
| Special            |
|:-------------------|
| 10 WS              |
| Flawless           |
| Level 1            |
| Level 1 10 WS      |
| Level 1 Flawless   |
| Level 1 No Rockets |
| Modded             |
| Modded 10 WS       |
| Modded Flawless    |
| Modded Level 1     |


Table: AllKitWeapon
| Challenge                                                   | Kit                        | Weapon           | Class       | Base                                           |
|:------------------------------------------------------------|:---------------------------|:-----------------|:------------|:-----------------------------------------------|
| "I AM URDNOT WREX, AND THIS IS MY PLANET!"                  | Krogan Battlemaster        | M-300 Claymore   | Vanguard    | "I AM URDNOT WREX, AND THIS IS MY PLANET!"     |
| "My turn!"                                                  | Krogan Soldier             | M-11 Wraith      | Soldier     | "My turn!"                                     |
| "Only one way to settle this"                               | Krogan Soldier             | N7 Typhoon       | Soldier     | "Only one way to settle this"                  |
| "Shepard" - "Wrex"                                          | Krogan Battlemaster        | N7 Crusader      | Vanguard    | "Shepard" - "Wrex"                             |
| "So...which one of you wants to disappear?"                 | Volus Engineer             | M-4 Shuriken     | Engineer    | "So...which one of you wants to disappear?"    |
| (The Illusive) Man's Reach Exceeding His Grasp (Hardcore)   | Alliance Infiltration Unit | M-22 Eviscerator | Infiltrator | (The Illusive) Man's Reach Exceeding His Grasp |
| (The Illusive) Man's Reach Exceeding His Grasp (Insanity) A | Alliance Infiltration Unit | M-11 Wraith      | Infiltrator | (The Illusive) Man's Reach Exceeding His Grasp |
| (The Illusive) Man's Reach Exceeding His Grasp (Insanity) B | Alliance Infiltration Unit | M-11 Wraith      | Infiltrator | (The Illusive) Man's Reach Exceeding His Grasp |
| 183 Pull-ups                                                | Battlefield Soldier        | M-76 Revenant    | Soldier     | 183 Pull-ups                                   |
| 183 Pull-ups (Trio)                                         | Battlefield Soldier        | M-76 Revenant    | Soldier     | 183 Pull-ups (Trio)                            |


Table: AllRequirements
| Challenge                                                | Requirements       |
|:---------------------------------------------------------|:-------------------|
| "Only one way to settle this"                            | Mission Successful |
| "So...which one of you wants to disappear?"              | Mission Successful |
| 183 Pull-ups (Trio)                                      | Mission Successful |
| A Bug's Life                                             | Mission Successful |
| A House Divided                                          | Mission Successful |
| A Million Ways to Die (and the Bloodpack Knows Them All) | Mission Successful |
| A New Home                                               | Mission Successful |
| A Rite of Passage (Insanity) A                           | Mission Successful |
| A Rite of Passage (Insanity) B                           | Mission Successful |
| Accurate Intel                                           | Mission Successful |


Table: AllRestrictions
| Challenge                        | Other Restrictions   |
|:---------------------------------|:---------------------|
| Abort, Retry, Fail?              | Armor bonus          |
| Agema                            | Armor bonus          |
| Archangel, Immortal              | Armor bonus          |
| Arete (Excellence)               | Armor bonus          |
| Ashes to Ashes, We All Fall Down | Armor bonus          |
| Baltasar                         | Armor bonus          |
| Bleed Out                        | Armor bonus          |
| Blue Rose of Illium              | Armor bonus          |
| Brood                            | Armor bonus          |
| Corporate Espionage              | Armor bonus          |


Table: Ch Difficulty
| Challenge Difficulty   |
|:-----------------------|
| Bronze and up          |
| Bronze only            |
| Silver and up          |
| Silver only            |
| Gold and up            |
| Gold only              |
| Platinum only          |


Table: Ch Types
| Challenge Type   |
|:-----------------|
| Solo             |
| Duo              |
| Trio             |
| Team             |


Table: ChallengeDetails
| Challenge                                                   | Base                                                     | Alt               | Is Bonus   | Series                      | Type   | Difficulty    | Map              | Enemy      | Kit 1                      | Kit 1 P.W.          | Kit 1 S.W.   | Kit 2               | Kit 2 P.W.         | Kit 2 S.W.   | Kit 3   | Kit 3 P.W.   | Kit 3 S.W.   | Kit 4   | Kit 4 P.W.   | Kit 4 S.W.   | Armored Compartments     | Missiles Use                  | Medigel Use   | Geth Scanner   | Cyclonics    | Misc Restrictions 1   | Misc Restrictions 2   | Misc Restrictions 3   | Gameplay Restrictions           | Requirements 1                                   | Requirements 2   | Requirements 3   | Requirements 4   |   Special Rules or Requirements |
|:------------------------------------------------------------|:---------------------------------------------------------|:------------------|:-----------|:----------------------------|:-------|:--------------|:-----------------|:-----------|:---------------------------|:--------------------|:-------------|:--------------------|:-------------------|:-------------|:--------|:-------------|:-------------|:--------|:-------------|:-------------|:-------------------------|:------------------------------|:--------------|:---------------|:-------------|:----------------------|:----------------------|:----------------------|:--------------------------------|:-------------------------------------------------|:-----------------|:-----------------|:-----------------|--------------------------------:|
| "Only one way to settle this"                               | "Only one way to settle this"                            | Duo Challenge III |            | For Tuchanka                | Duo    | Gold and up   | Vancouver        | Reapers    | Krogan Soldier             | N7 Typhoon          |              | Krogan Battlemaster | N7 Typhoon         |              |         |              |              |         |              |              | Not allowed              | Unrestricted on Platinum only | Unrestricted  | Allowed        | Unrestricted |                       |                       |                       | No clever use of game mechanics | Mission Successful                               | Melee Kills      |                  |                  |                               0 |
| (The Illusive) Man's Reach Exceeding His Grasp (Insanity) B | (The Illusive) Man's Reach Exceeding His Grasp           | Week 6.1          |            | Tales from the Trenches     | Duo    | Platinum Only | Glacier (Hazard) | Cerberus   | Alliance Infiltration Unit | M-11 Wraith         |              | Phoenix Vanguard    | M-358 Talon        |              |         |              |              |         |              |              | Not allowed              | Unrestricted on Platinum only | Unrestricted  | Allowed        | Unrestricted |                       |                       |                       |                                 | Full Extraction                                  |                  |                  |                  |                               0 |
| A Million Ways to Die (and the Bloodpack Knows Them All)    | A Million Ways to Die (and the Bloodpack Knows Them All) | Week 4.2          |            | Tales from the Trenches     | Duo    | Gold and up   | Giant            | Reapers    | Krogan Sentinel            | Graal Spike Thrower |              | Vorcha Sentinel     | Executioner Pistol |              |         |              |              |         |              |              | Not allowed              | Unrestricted on Platinum only | Unrestricted  | Allowed        | Unrestricted |                       |                       |                       |                                 | Mission Successful                               | Bronze Medals    |                  |                  |                               1 |
| A New Home                                                  | A New Home                                               | Mission 2         |            | Mordus' Path of Destruction | Solo   | Gold only     | Ghost (Hazard)   | Reapers    | Salarian Engineer          | Venom Shotgun       |              |                     |                    |              |         |              |              |         |              |              | Allowed                  | Unrestricted                  | Unrestricted  | Allowed        | Unrestricted |                       |                       |                       |                                 | Mission Successful                               |                  |                  |                  |                               0 |
| A Rite of Passage (Hardcore) A                              | A Rite of Passage                                        | Week 5.1          |            | Tales from the Trenches     | Duo    | Gold only     | Giant (Hazard)   | Cerberus   | Krogan Shaman              | Graal Spike Thrower |              | Phoenix Adept       | M-25 Hornet        |              |         |              |              |         |              |              | Not allowed              | Unrestricted on Platinum only | Unrestricted  | Allowed        | Unrestricted |                       |                       |                       |                                 | Full Extraction                                  | Assists          |                  |                  |                               0 |
| A Rite of Passage (Hardcore) B                              | A Rite of Passage                                        | Week 5.1          |            | Tales from the Trenches     | Duo    | Gold only     | Giant (Hazard)   | Cerberus   | Krogan Shaman              | M-300 Claymore      |              | Phoenix Adept       | M-25 Hornet        |              |         |              |              |         |              |              | Not allowed              | Unrestricted on Platinum only | Unrestricted  | Allowed        | Unrestricted |                       |                       |                       |                                 | Full Extraction                                  | Assists          |                  |                  |                               0 |
| A Short-lived, Vorchan Destiny                              | A Short-lived, Vorchan Destiny                           | Week 4            |            | Weekly Themed Solos 2       | Solo   | Silver and up | Glacier (Hazard) | Collectors | Vorcha Hunter              | Kishock Harpoon Gun |              |                     |                    |              |         |              |              |         |              |              | Allowed on Platinum only | Unrestricted                  | Unrestricted  | Allowed        | Unrestricted |                       |                       |                       |                                 | Full Extraction (Mission Successful on Platinum) | Headshots        |                  |                  |                               0 |
| Acceptance                                                  | Acceptance                                               | Stage 5           |            | The Gordian Hour            | Solo   | Gold only     | Glacier          | Cerberus   | Turian Sentinel            | N7 Valkyrie         |              |                     |                    |              |         |              |              |         |              |              | Not allowed              | Unrestricted                  | Unrestricted  | Allowed        | Unrestricted |                       |                       |                       |                                 | Full Extraction                                  |                  |                  |                  |                               0 |
| Altahe                                                      | Altahe                                                   | Set 10.I          |            | Themed Duo Challenges 2     | Duo    | Silver and up | Condor           | Collectors | Krogan Sentinel            | Graal Spike Thrower |              | Krogan Soldier      | Executioner Pistol |              |         |              |              |         |              |              | Not allowed              | Unrestricted on Platinum only | Unrestricted  | Allowed        | Unrestricted |                       |                       |                       |                                 | Mission Successful                               | Waves Survived   |                  |                  |                               0 |
| Anger                                                       | Anger                                                    | Stage 2           |            | The Gordian Hour            | Solo   | Gold only     | Glacier (Hazard) | Collectors | N7 Destroyer               | N7 Typhoon          |              |                     |                    |              |         |              |              |         |              |              | Not allowed              | Unrestricted                  | Unrestricted  | Allowed        | Unrestricted |                       |                       |                       |                                 | Full Extraction                                  |                  |                  |                  |                               0 |


Table: Challenges
| Base                                           | Is Bonus   | Series                      | Type   | Alt                |
|:-----------------------------------------------|:-----------|:----------------------------|:-------|:-------------------|
| "I AM URDNOT WREX, AND THIS IS MY PLANET!"     |            | For Tuchanka                | Solo   | Solo Challenge II  |
| "My turn!"                                     |            | For Tuchanka                | Solo   | Solo Challenge III |
| "Only one way to settle this"                  |            | For Tuchanka                | Duo    | Duo Challenge III  |
| "Shepard" - "Wrex"                             |            | For Tuchanka                | Duo    | Duo Challenge II   |
| "So...which one of you wants to disappear?"    |            | For Tuchanka                | Trio   | Trio Challenge IV  |
| (The Illusive) Man's Reach Exceeding His Grasp |            | Tales from the Trenches     | Duo    | Week 6.1           |
| 183 Pull-ups                                   |            | N7 Challenge Series         | Solo   | N2.3               |
| 183 Pull-ups (Trio)                            |            | N7 Triune Trials            | Trio   | N2.3               |
| A Bug's Life                                   |            | Operation Alliance Troopers | Solo   | Mission 4          |
| A House Divided                                |            | Servant of the People       | Trio   | Trio 2             |


Table: Classes
| Class       |
|:------------|
| Adept       |
| Soldier     |
| Engineer    |
| Sentinel    |
| Infiltrator |
| Vanguard    |


Table: Cycl Rules
| Cyclonics                    |
|:-----------------------------|
| Unrestricted                 |
| Restricted                   |
| Restricted (Gold and Below)  |
| Not allowed                  |
| Not allowed (Gold and Below) |


Table: Difficulty
| Difficulty   |
|:-------------|
| Bronze       |
| Silver       |
| Gold         |
| Platinum     |


Table: Enemies
| Enemy      | DLC           |
|:-----------|:--------------|
| Cerberus   | Original Game |
| Geth       | Original Game |
| Reapers    | Original Game |
| Collectors | Retaliation   |
| Rejects    | Rejection     |


Table: GS Rules
| Geth Scanner                 |
|:-----------------------------|
| Allowed                      |
| Not allowed                  |
| Not allowed (Gold and below) |


Table: Kits
| Kit                        | Class       | Species   | Rarity     | DLC           |
|:---------------------------|:------------|:----------|:-----------|:--------------|
| Alliance Infiltration Unit | Infiltrator | Synthetic | Rare       | Reckoning     |
| Asari Adept                | Adept       | Asari     | Rare       | Original Game |
| Asari Huntress             | Infiltrator | Asari     | Rare       | Retaliation   |
| Asari Justicar             | Adept       | Asari     | Rare       | Resurgence    |
| Asari Valkyrie             | Sentinel    | Asari     | Rare       | Retaliation   |
| Asari Vanguard             | Vanguard    | Asari     | Uncommon   | Original Game |
| Awakened Collector Adept   | Adept       | Collector | Ultra Rare | Reckoning     |
| Batarian Brawler           | Vanguard    | Batarian  | Rare       | Retaliation   |
| Batarian Sentinel          | Sentinel    | Batarian  | Rare       | Resurgence    |
| Batarian Slasher           | Adept       | Batarian  | Rare       | Retaliation   |


Table: Maps
| Map     | DLC           |
|:--------|:--------------|
| Dagger  | Original Game |
| Ghost   | Original Game |
| Giant   | Original Game |
| White   | Original Game |
| Glacier | Original Game |
| Reactor | Original Game |
| Condor  | Resurgence    |
| Hydra   | Resurgence    |
| Jade    | Rebellion     |
| Goddess | Rebellion     |


Table: MG Rules
| Medigel Use                  |
|:-----------------------------|
| Unrestricted                 |
| Restricted                   |
| Restricted (Gold and below)  |
| Not allowed                  |
| Not allowed (Gold and below) |


Table: Missiles Rules
| Missiles Use                  |
|:------------------------------|
| Unrestricted                  |
| Unrestricted on Platinum only |
| Restricted                    |
| Not allowed                   |


Table: Platforms
| Platforms   |
|:------------|
| PC          |
| PS3         |
| Xbox 360    |


Table: PlayerRuns
| Player         | Team                         |   Duration | Difficulty   | Base          | Series             | Alt   |   Bonus | Type   | Special   | D.Time                  |   D.Hour |   D.Min |   D.Sec |   D.Time.Min |   Duration H |   TypeDivisor |
|:---------------|:-----------------------------|-----------:|:-------------|:--------------|:-------------------|:------|--------:|:-------|:----------|:------------------------|---------:|--------:|--------:|-------------:|-------------:|--------------:|
| Aetika         | Aetika | SABRERACER          |  0.025162  | Gold         | Marksman Raid | Project Blackwatch |       |       0 | Duo    |           | 1899-12-30 00:36:14.000 |        0 |      36 |      14 |      36.2333 |     0.301944 |             2 |
| Alfonsedode    | Alfonsedode | ex-Clusum      |  0.0125231 | Gold         | Marksman Raid | Project Blackwatch |       |       0 | Duo    |           | 1899-12-30 00:18:02.000 |        0 |      18 |       2 |      18.0333 |     0.150278 |             2 |
| frank_is_crank | Alfonsedode | frank_is_crank |  0.0137037 | Gold         | Marksman Raid | Project Blackwatch |       |       0 | Duo    |           | 1899-12-30 00:19:44.000 |        0 |      19 |      44 |      19.7333 |     0.164444 |             2 |
| SICKLECYDE     | Argent Xero | SICKLECYDE     |  0.0136574 | Gold         | Marksman Raid | Project Blackwatch |       |       0 | Duo    |           | 1899-12-30 00:19:40.000 |        0 |      19 |      40 |      19.6667 |     0.163889 |             2 |
| Argent Xero    | Argent Xero | Velanna Frost  |  0.015     | Gold         | Marksman Raid | Project Blackwatch |       |       0 | Duo    |           | 1899-12-30 00:21:36.000 |        0 |      21 |      36 |      21.6    |     0.18     |             2 |
| ark_ryv_       | ark_ryv_ | mexximal          |  0.0155903 | Gold         | Marksman Raid | Project Blackwatch |       |       0 | Duo    |           | 1899-12-30 00:22:27.000 |        0 |      22 |      27 |      22.45   |     0.187083 |             2 |
| ark_ryv_       | ark_ryv_ | XAN1_95           |  0.0144213 | Gold         | Marksman Raid | Project Blackwatch |       |       0 | Duo    |           | 1899-12-30 00:20:46.000 |        0 |      20 |      46 |      20.7667 |     0.173056 |             2 |
| AW_FC_1986     | AW_FC_1986 | ex-Clusum       |  0.0122106 | Gold         | Marksman Raid | Project Blackwatch |       |       0 | Duo    |           | 1899-12-30 00:17:35.000 |        0 |      17 |      35 |      17.5833 |     0.146528 |             2 |
| ex-Clusum      | AW_FC_1986 | ex-Clusum       |  0.0184722 | Gold         | Marksman Raid | Project Blackwatch |       |       0 | Duo    |           | 1899-12-30 00:26:36.000 |        0 |      26 |      36 |      26.6    |     0.221667 |             2 |
| AW_FC_1986     | AW_FC_1986 | Smehur          |  0.0136574 | Gold         | Marksman Raid | Project Blackwatch |       |       0 | Duo    |           | 1899-12-30 00:19:40.000 |        0 |      19 |      40 |      19.6667 |     0.163889 |             2 |


Table: Requirements
| Requirements                                     |
|:-------------------------------------------------|
| Mission Successful                               |
| Full Extraction                                  |
| Full Extraction (Mission Successful on Platinum) |
| Waves Survived                                   |
| Waves Survived (Gold and below)                  |
| Weapon Kills                                     |
| Weapon Kills (Gold and below)                    |
| Biotic Kills                                     |
| Biotic Kills (Gold and below)                    |
| Tech Kills                                       |


Table: Restrictions
| Gameplay restrictions               |
|:------------------------------------|
| No pizza running                    |
| No hack glitching                   |
| No incendiary glitch                |
| No pizza running and hack glitching |
| No clever use of game mechanics     |
| No bleedouts                        |


Table: Runs
|   Is in HoF | Points   | Player 1        | Player 2       | Player 3   | Player 4   | Link 1                                                       | Link 2                                                       | Link 3   | Link 4   | Team                             |   Duration | Time                    | Difficulty   | Base                          | Series                        | Alt      |   Bonus | Type   | Special   | Platform   | Link                                        |   Video |   Is Multi-Link | Entry (Single Link)   | Entry (Multi-Link) Part 1   | Entry (Multi-Link) Part 2   | Entry (Multi-Link) Part 3   | Entry (Multi-Link) Part 4   | D.Time                  |   Duration Bin |   D.Min |   D.Hour |   D.Sec |   D.Time.Min | Enemy      |
|------------:|:---------|:----------------|:---------------|:-----------|:-----------|:-------------------------------------------------------------|:-------------------------------------------------------------|:---------|:---------|:---------------------------------|-----------:|:------------------------|:-------------|:------------------------------|:------------------------------|:---------|--------:|:-------|:----------|:-----------|:--------------------------------------------|--------:|----------------:|:----------------------|:----------------------------|:----------------------------|:----------------------------|:----------------------------|:------------------------|---------------:|--------:|---------:|--------:|-------------:|:-----------|
|           1 |          | Sonashii        | frank_is_crank |            |            | https://www.youtube.com/watch?v=enc8a5ICe0E&feature=youtu.be | https://www.youtube.com/watch?v=KboG1Su4TW8&feature=youtu.be |          |          | frank_is_crank | Sonashii        |  0.0207407 | 1899-12-31 00:29:52.000 | Gold         | While They Reach the Normandy | Tales from the Trenches       | Week 1.1 |       0 | Duo    |           | PC         |                                             |       1 |               2 |                       | 29:52 - Sonashii [v]        | | frank_is_crank [v]        |                             |                             | 1899-12-30 00:29:52.000 |        26.3317 |      29 |        0 |      52 |      29.8667 | Reapers    |
|           1 |          | burningcherry97 | frank_is_crank |            |            | https://www.youtube.com/watch?v=2nHD9SPk6QE&feature=youtu.be | https://www.youtube.com/watch?v=SLrWfppE7mQ&feature=youtu.be |          |          | burningcherry97 | frank_is_crank |  0.0100231 | 1899-12-31 00:14:26.000 | Gold         | Tier 1 (Duo)                  | The Seven Tiers of Neufchatel |          |       0 | Duo    |           | PC         |                                             |       1 |               2 |                       | 14:26 - burningcherry97 [v] | | frank_is_crank [v]        |                             |                             | 1899-12-30 00:14:26.000 |        11.0883 |      14 |        0 |      26 |      14.4333 | Geth       |
|           1 |          | SenorZanahoria  | frank_is_crank |            |            | https://www.youtube.com/watch?v=jHpb4HbVwgY&feature=youtu.be | https://www.youtube.com/watch?v=3s4NHqkZ95M&feature=youtu.be |          |          | frank_is_crank | SenorZanahoria  |  0.0131944 | 1899-12-31 00:19:00.000 | Gold         | Tier 1 (Duo)                  | The Seven Tiers of Neufchatel |          |       0 | Duo    |           | PC         |                                             |       1 |               2 |                       | 19:00 - SenorZanahoria [v]  | | frank_is_crank [v]        |                             |                             | 1899-12-30 00:19:00.000 |        18.71   |      19 |        0 |       0 |      19      | Geth       |
|           1 |          | burningcherry97 | frank_is_crank |            |            | https://www.youtube.com/watch?v=G6Q_fEhFrDE&feature=youtu.be | https://www.youtube.com/watch?v=yp3XKkdSOgo&feature=youtu.be |          |          | burningcherry97 | frank_is_crank |  0.0122454 | 1899-12-31 00:17:38.000 | Gold         | Tier 2 (Duo)                  | The Seven Tiers of Neufchatel |          |       0 | Duo    |           | PC         |                                             |       1 |               2 |                       | 17:38 - burningcherry97 [v] | | frank_is_crank [v]        |                             |                             | 1899-12-30 00:17:38.000 |        11.0883 |      17 |        0 |      38 |      17.6333 | Collectors |
|           1 |          | SenorZanahoria  | frank_is_crank |            |            | https://www.youtube.com/watch?v=MvhJ5g3PgjQ&feature=youtu.be | https://www.youtube.com/watch?v=ImK-U0Cwr_w&feature=youtu.be |          |          | frank_is_crank | SenorZanahoria  |  0.0130324 | 1899-12-31 00:18:46.000 | Gold         | Tier 2 (Duo)                  | The Seven Tiers of Neufchatel |          |       0 | Duo    |           | PC         |                                             |       1 |               2 |                       | 18:46 - SenorZanahoria [v]  | | frank_is_crank [v]        |                             |                             | 1899-12-30 00:18:46.000 |        18.71   |      18 |        0 |      46 |      18.7667 | Collectors |
|           1 |          | Sonashii        | frank_is_crank |            |            | https://www.youtube.com/watch?v=ZguYyp-70jc                  | https://www.youtube.com/watch?v=HPddeAp29wM&feature=youtu.be |          |          | frank_is_crank | Sonashii        |  0.0117477 | 1899-12-31 00:16:55.000 | Gold         | Tier 2 (Duo)                  | The Seven Tiers of Neufchatel |          |       0 | Duo    |           | PC         | https://www.youtube.com/watch?v=ZguYyp-70jc |       1 |               2 |                       | 16:55 - Sonashii [v]        | | frank_is_crank [v]        |                             |                             | 1899-12-30 00:16:55.000 |        11.0883 |      16 |        0 |      55 |      16.9167 | Collectors |
|           1 |          | burningcherry97 | frank_is_crank |            |            | https://www.youtube.com/watch?v=YfonGS9JK3I&feature=youtu.be | https://www.youtube.com/watch?v=NEep-rRlD3E&feature=youtu.be |          |          | burningcherry97 | frank_is_crank |  0.0131944 | 1899-12-31 00:19:00.000 | Gold         | Tier 3 (Duo)                  | The Seven Tiers of Neufchatel |          |       0 | Duo    |           | PC         |                                             |       1 |               2 |                       | 19:00 - burningcherry97 [v] | | frank_is_crank [v]        |                             |                             | 1899-12-30 00:19:00.000 |        18.71   |      19 |        0 |       0 |      19      | Reapers    |
|           1 |          | SenorZanahoria  | frank_is_crank |            |            | https://www.youtube.com/watch?v=GpQNSCWw_yU&feature=youtu.be | https://www.youtube.com/watch?v=TGluw_yaxbY&feature=youtu.be |          |          | frank_is_crank | SenorZanahoria  |  0.0137616 | 1899-12-31 00:19:49.000 | Gold         | Tier 3 (Duo)                  | The Seven Tiers of Neufchatel |          |       0 | Duo    |           | PC         |                                             |       1 |               2 |                       | 19:49 - SenorZanahoria [v]  | | frank_is_crank [v]        |                             |                             | 1899-12-30 00:19:49.000 |        18.71   |      19 |        0 |      49 |      19.8167 | Reapers    |
|           1 |          | Sonashii        | frank_is_crank |            |            | https://www.youtube.com/watch?v=F8iOzGKR-MQ                  | https://www.youtube.com/watch?v=lr1I-zmFGW0&feature=youtu.be |          |          | frank_is_crank | Sonashii        |  0.0125463 | 1899-12-31 00:18:04.000 | Gold         | Tier 3 (Duo)                  | The Seven Tiers of Neufchatel |          |       0 | Duo    |           | PC         | https://www.youtube.com/watch?v=F8iOzGKR-MQ |       1 |               2 |                       | 18:04 - Sonashii [v]        | | frank_is_crank [v]        |                             |                             | 1899-12-30 00:18:04.000 |        11.0883 |      18 |        0 |       4 |      18.0667 | Reapers    |
|           1 |          | burningcherry97 | frank_is_crank |            |            | https://www.youtube.com/watch?v=EmqqBxZA-cM&feature=youtu.be | https://www.youtube.com/watch?v=WBsSUyMT0HE&feature=youtu.be |          |          | burningcherry97 | frank_is_crank |  0.0124074 | 1899-12-31 00:17:52.000 | Gold         | Tier 4 (Duo)                  | The Seven Tiers of Neufchatel |          |       0 | Duo    |           | PC         |                                             |       1 |               2 |                       | 17:52 - burningcherry97 [v] | | frank_is_crank [v]        |                             |                             | 1899-12-30 00:17:52.000 |        11.0883 |      17 |        0 |      52 |      17.8667 | Cerberus   |


Table: Series By Type
| Series             | Type   |   Challenges |
|:-------------------|:-------|-------------:|
| Delta Squad        | Team   |            6 |
| Elysium Olympics   | Duo    |            1 |
| Elysium Olympics   | Solo   |            1 |
| Elysium Olympics   | Team   |            1 |
| Elysium Olympics   | Trio   |            1 |
| Fight for the Lost | Duo    |           12 |
| Fight for the Lost | Trio   |           12 |
| Fight for the Lost | Solo   |           12 |
| For Tuchanka       | Solo   |            4 |
| For Tuchanka       | Duo    |            4 |


Table: Series
| Series                      |   Challenges |
|:----------------------------|-------------:|
| For Tuchanka                |           16 |
| Tales from the Trenches     |           30 |
| N7 Challenge Series         |           21 |
| N7 Triune Trials            |           42 |
| Operation Alliance Troopers |           12 |
| Servant of the People       |           16 |
| Mordus' Path of Destruction |            4 |
| Weekly Themed Solos 2       |           21 |
| Fight for the Lost          |           36 |
| The Gordian Hour            |            8 |


Table: Spec Restrictions
| Special Restrictions   |
|:-----------------------|
| Build                  |
| Consumables            |
| Gear bonus             |
| Armor bonus            |
| Ammo bonus             |


Table: Species
| Species   |
|:----------|
| Human     |
| Asari     |
| Krogan    |
| Drell     |
| Turian    |
| Salarian  |
| Vorcha    |
| Volus     |
| Collector |
| Batarian  |


Table: Weapon Rarity
| Rarity     |
|:-----------|
| Common     |
| Uncommon   |
| Rare       |
| Ultra Rare |


Table: Weapon Types
| Weapon Type   |
|:--------------|
| Assault Rifle |
| Heavy Pistol  |
| Shotgun       |
| SMG           |
| Sniper Rifle  |


Table: Weapons
| Weapon                    | Type          | Rarity     | DLC           |
|:--------------------------|:--------------|:-----------|:--------------|
| Acolyte                   | Heavy Pistol  | Rare       | Earth         |
| Adas Anti-Synthetic Rifle | Assault Rifle | Rare       | Reckoning     |
| Any Assault Rifle         | Assault Rifle |            |               |
| Any Heavy Pistol          | Heavy Pistol  |            |               |
| Any Shotgun               | Shotgun       |            |               |
| Any SMG                   | SMG           |            |               |
| Any Sniper Rifle          | Sniper Rifle  |            |               |
| Arc Pistol                | Heavy Pistol  | Rare       | Original Game |
| AT-12 Raider              | Shotgun       | Rare       | Original Game |
| Black Widow               | Sniper Rifle  | Ultra Rare | Original Game |

 


tables: name: AC Rules
data: AC Rules.csv
name: Achievements
data: Achievements.csv
name: AllKitWeapon
data: AllKitWeapon.csv
name: AllRequirements
data: AllRequirements.csv
name: AllRestrictions
data: AllRestrictions.csv
name: Ch Difficulty
data: Ch Difficulty.csv
name: Ch Types
data: Ch Types.csv
name: ChallengeDetails
data: ChallengeDetails.csv
name: Challenges
data: Challenges.csv
name: Classes
data: Classes.csv
name: Cycl Rules
data: Cycl Rules.csv
name: Difficulty
data: Difficulty.csv
name: Enemies
data: Enemies.csv
name: GS Rules
data: GS Rules.csv
name: Kits
data: Kits.csv
name: Maps
data: Maps.csv
name: MG Rules
data: MG Rules.csv
name: Missiles Rules
data: Missiles Rules.csv
name: Platforms
data: Platforms.csv
name: PlayerRuns
data: PlayerRuns.csv
name: Requirements
data: Requirements.csv
name: Restrictions
data: Restrictions.csv
name: Runs
data: Runs.csv
name: Series By Type
data: Series By Type.csv
name: Series
data: Series.csv
name: Spec Restrictions
data: Spec Restrictions.csv
name: Species
data: Species.csv
name: Weapon Rarity
data: Weapon Rarity.csv
name: Weapon Types
data: Weapon Types.csv
name: Weapons
data: Weapons.csv
label: Runs
Base
Challenges
Base
PlayerRuns
Base
Challenges
Base
Challenges
Series
Series
Series
Series By Type
Series
Series
Series
Runs
Difficulty
Difficulty
Difficulty
PlayerRuns
Difficulty
Difficulty
Difficulty
Kits
Species
Species
Species
Kits
Class
Classes
Class
ChallengeDetails
Base
Challenges
Base
AllKitWeapon
Weapon
Weapons
Weapon
ChallengeDetails
Gameplay Restrictions
Restrictions
Gameplay restrictions
AllRequirements
Requirements
Requirements
Requirements
ChallengeDetails
Missiles Use
Missiles Rules
Missiles Use
ChallengeDetails
Medigel Use
MG Rules
Medigel Use
ChallengeDetails
Map
Maps
Map
ChallengeDetails
Geth Scanner
GS Rules
Geth Scanner
AllKitWeapon
Kit
Kits
Kit
ChallengeDetails
Enemy
Enemies
Enemy
ChallengeDetails
Cyclonics
Cycl Rules
Cyclonics
ChallengeDetails
Armored Compartments
AC Rules
Armored Compartments
AllKitWeapon
Challenge
ChallengeDetails
Challenge
AllRequirements
Challenge
ChallengeDetails
Challenge
AllRestrictions
Challenge
ChallengeDetails
Challenge
Weapons
Rarity
Weapon Rarity
Rarity
output: {
    "joins": [
        {
            "from_table": "Runs",
            "from_column": "Base",
            "to_table": "Challenges",
            "to_column": "Base"
        },
        {
            "from_table": "PlayerRuns",
            "from_column": "Base",
            "to_table": "Challenges",
            "to_column": "Base"
        },
        {
            "from_table": "Challenges",
            "from_column": "Series",
            "to_table": "Series",
            "to_column": "Series"
        },
        {
            "from_table": "Series By Type",
            "from_column": "Series",
            "to_table": "Series",
            "to_column": "Series"
        },
        {
            "from_table": "Runs",
            "from_column": "Difficulty",
            "to_table": "Difficulty",
            "to_column": "Difficulty"
        },
        {
            "from_table": "PlayerRuns",
            "from_column": "Difficulty",
            "to_table": "Difficulty",
            "to_column": "Difficulty"
        },
        {
            "from_table": "Kits",
            "from_column": "Species",
            "to_table": "Species",
            "to_column": "Species"
        },
        {
            "from_table": "Kits",
            "from_column": "Class",
            "to_table": "Classes",
            "to_column": "Class"
        },
        {
            "from_table": "ChallengeDetails",
            "from_column": "Base",
            "to_table": "Challenges",
            "to_column": "Base"
        },
        {
            "from_table": "AllKitWeapon",
            "from_column": "Weapon",
            "to_table": "Weapons",
            "to_column": "Weapon"
        },
        {
            "from_table": "ChallengeDetails",
            "from_column": "Gameplay Restrictions",
            "to_table": "Restrictions",
            "to_column": "Gameplay restrictions"
        },
        {
            "from_table": "AllRequirements",
            "from_column": "Requirements",
            "to_table": "Requirements",
            "to_column": "Requirements"
        },
        {
            "from_table": "ChallengeDetails",
            "from_column": "Missiles Use",
            "to_table": "Missiles Rules",
            "to_column": "Missiles Use"
        },
        {
            "from_table": "ChallengeDetails",
            "from_column": "Medigel Use",
            "to_table": "MG Rules",
            "to_column": "Medigel Use"
        },
        {
            "from_table": "ChallengeDetails",
            "from_column": "Map",
            "to_table": "Maps",
            "to_column": "Map"
        },
        {
            "from_table": "ChallengeDetails",
            "from_column": "Geth Scanner",
            "to_table": "GS Rules",
            "to_column": "Geth Scanner"
        },
        {
            "from_table": "AllKitWeapon",
            "from_column": "Kit",
            "to_table": "Kits",
            "to_column": "Kit"
        },
        {
            "from_table": "ChallengeDetails",
            "from_column": "Enemy",
            "to_table": "Enemies",
            "to_column": "Enemy"
        },
        {
            "from_table": "ChallengeDetails",
            "from_column": "Cyclonics",
            "to_table": "Cycl Rules",
            "to_column": "Cyclonics"
        },
        {
            "from_table": "ChallengeDetails",
            "from_column": "Armored Compartments",
            "to_table": "AC Rules",
            "to_column": "Armored Compartments"
        },
        {
            "from_table": "AllKitWeapon",
            "from_column": "Challenge",
            "to_table": "ChallengeDetails",
            "to_column": "Challenge"
        },
        {
            "from_table": "AllRequirements",
            "from_column": "Challenge",
            "to_table": "ChallengeDetails",
            "to_column": "Challenge"
        },
        {
            "from_table": "AllRestrictions",
            "from_column": "Challenge",
            "to_table": "ChallengeDetails",
            "to_column": "Challenge"
        },
        {
            "from_table": "Weapons",
            "from_column": "Rarity",
            "to_table": "Weapon Rarity",
            "to_column": "Rarity"
        }
    ]
}