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: ABSAgeGroup
|        id |   Income year |   Postcode | AgeGroup           |   PopulationAgeGroup |
|----------:|--------------:|-----------:|:-------------------|---------------------:|
| 201100800 |          2011 |        800 | 100 years and over |                    0 |
| 201100812 |          2011 |        812 | 100 years and over |                    0 |
| 201100820 |          2011 |        820 | 100 years and over |                    0 |
| 201100828 |          2011 |        828 | 100 years and over |                    0 |
| 201100829 |          2011 |        829 | 100 years and over |                    0 |
| 201100830 |          2011 |        830 | 100 years and over |                    0 |
| 201100832 |          2011 |        832 | 100 years and over |                    0 |
| 201100835 |          2011 |        835 | 100 years and over |                    0 |
| 201100836 |          2011 |        836 | 100 years and over |                    0 |
| 201100837 |          2011 |        837 | 100 years and over |                    0 |


Table: ATOTaxDetails
|          id |   Income year |   Postcode |   TaxedIndividuals |   Taxable income or loss1  |   Net tax |   Gross interest |   Net rent |   Net capital gain |   Total income or loss |   Total deductions |   Salary or wages |   Medicare levy |   Medicare levy surcharge |   Total work related expenses |   Gifts or donations |   HELP assessment debt2 |
|------------:|--------------:|-----------:|-------------------:|---------------------------:|----------:|-----------------:|-----------:|-------------------:|-----------------------:|-------------------:|------------------:|----------------:|--------------------------:|------------------------------:|---------------------:|------------------------:|
| 2.00603e+08 |          2006 |       2585 |                110 |                4.21998e+06 |    920234 |           160425 |     -45441 |             216600 |            4.45183e+06 |             231844 |       2.39597e+06 |           53461 |                         0 |                         92528 |                10358 |                       0 |
| 2.00603e+08 |          2006 |       2726 |                 95 |                3.334e+06   |    635462 |           611442 |      46517 |             753441 |            5.48297e+06 |             371142 |       4.49756e+06 |           44738 |                         0 |                        104153 |                89974 |                       0 |
| 2.00603e+08 |          2006 |       2734 |                 60 |                1.90911e+06 |    336609 |            42034 |      17562 |              47314 |            2.01582e+06 |              95359 |       1.25201e+06 |           23992 |                         0 |                         61907 |                 2031 |                       0 |
| 2.00603e+08 |          2006 |       3491 |                 70 |                2.08209e+06 |    306819 |            82768 |        339 |             132345 |            2.19956e+06 |             117469 |  842743           |           22933 |                         0 |                         49996 |                 1505 |                       0 |
| 2.00604e+08 |          2006 |       3531 |                 90 |                3.05775e+06 |    576388 |           183443 |       3156 |              84406 |            3.25616e+06 |              93279 |       1.15634e+06 |           38683 |                         0 |                         37932 |                 6370 |                       0 |
| 2.00604e+08 |          2006 |       3738 |                 65 |                2.1144e+06  |    389670 |            10405 |     -26013 |              70376 |            2.2239e+06  |             104872 |       1.81175e+06 |           27336 |                         0 |                         85669 |                 2025 |                       0 |
| 2.00604e+08 |          2006 |       4498 |                 90 |                3.30831e+06 |    674187 |            63778 |     -20611 |             102895 |            3.63307e+06 |             301160 |       2.12856e+06 |           43640 |                         0 |                         96826 |                 3109 |                       0 |
| 2.00605e+08 |          2006 |       5269 |                 90 |                2.65192e+06 |    484391 |            37502 |      71466 |             118866 |            2.89024e+06 |             238319 |       1.49492e+06 |           35435 |                         0 |                         32848 |                   25 |                       0 |
| 2.00606e+08 |          2006 |       5521 |                 70 |                2.69705e+06 |    621284 |           155956 |      -3884 |             402431 |            3.04111e+06 |             334413 |       1.18715e+06 |           36194 |                         0 |                         30798 |                   13 |                       0 |
| 2.00606e+08 |          2006 |       6358 |                 75 |                2.30645e+06 |    345869 |           108783 |      58021 |             155760 |            2.43025e+06 |             123796 |  990722           |           26117 |                         0 |                         36525 |                   11 |                       0 |


Table: AustralianLocations
|   PostCode | suburb                  | State   | dc                   | type          |      lat |     lon |
|-----------:|:------------------------|:--------|:---------------------|:--------------|---------:|--------:|
|       3000 | MELBOURNE               | VIC     | CITY DELIVERY CENTRE | Delivery Area | -37.8146 | 144.97  |
|       3002 | EAST MELBOURNE          | VIC     | CITY DELIVERY CENTRE | Delivery Area | -37.8166 | 144.988 |
|       3003 | WEST MELBOURNE          | VIC     | CITY DELIVERY CENTRE | Delivery Area | -37.8063 | 144.941 |
|       3004 | MELBOURNE               | VIC     | CITY DELIVERY CENTRE | Delivery Area | -37.8373 | 144.976 |
|       3005 | WORLD TRADE CENTRE      | VIC     | CITY DELIVERY CENTRE | Delivery Area | -37.8223 | 144.955 |
|       3006 | SOUTHBANK               | VIC     | SOUTH MELBOURNE DC   | Delivery Area | -37.8233 | 144.966 |
|       3008 | DOCKLANDS               | VIC     | CITY DELIVERY CENTRE | Delivery Area | -37.8147 | 144.948 |
|       3010 | UNIVERSITY OF MELBOURNE | VIC     | CARLTON DC           | Delivery Area | -37.7962 | 144.961 |
|       3011 | FOOTSCRAY               | VIC     | WEST FOOTSCRAY DC    | Delivery Area | -37.7998 | 144.9   |
|       3012 | BROOKLYN                | VIC     | WEST FOOTSCRAY DC    | Delivery Area | -37.8146 | 144.847 |


Table: Data
|          id |   Income year |   Postcode |   Individuals1 |   Taxable income or loss1  |          Net tax |   Gross interest |   Net rent |   Net capital gain |   Total income or loss |   Total deductions |   Salary or wages |   Medicare levy |   Medicare levy surcharge |   Total work related expenses |   Gifts or donations |   HELP assessment debt2 |   0-4 years |   5-9 years |   10-14 years |   15-19 years |   20-24 years |   25-29 years |   30-34 years |   35-39 years |   40-44 years |   45-49 years |   50-54 years |   55-59 years |   60-64 years |   65-69 years |   70-74 years |   75-79 years |   80-84 years |   85-89 years |   90-94 years |   95-99 years |   100 years and over |   Oceanian |   North-West European |   Southern and Eastern European |   North African and Middle Eastern |   South-East Asian |   North-East Asian |   Southern and Central Asian |   People of the Americas |   Sub-Saharan African |   Male |   Female |   under or 0 |   $1 to 1000 |   1000-1999 |   2000 |   Married in a registered marriage |   Married in a de facto marriage |   Not married |
|------------:|--------------:|-----------:|---------------:|---------------------------:|-----------------:|-----------------:|-----------:|-------------------:|-----------------------:|-------------------:|------------------:|----------------:|--------------------------:|------------------------------:|---------------------:|------------------------:|------------:|------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|--------------:|---------------------:|-----------:|----------------------:|--------------------------------:|-----------------------------------:|-------------------:|-------------------:|-----------------------------:|-------------------------:|----------------------:|-------:|---------:|-------------:|-------------:|------------:|-------:|-----------------------------------:|---------------------------------:|--------------:|
| 2.00601e+08 |          2006 |        840 |             50 |                2.27724e+06 | 489026           |             6374 |     -14165 |               2110 |            2.31592e+06 |    38680           |       1.61779e+06 |           30382 |                      2012 |                         28816 |                 1753 |                       0 |           3 |           5 |             4 |             3 |             7 |             3 |            10 |             8 |            21 |            19 |            42 |            43 |            39 |            19 |             9 |             3 |             0 |             0 |             0 |             0 |                    0 |         64 |                   120 |                               9 |                                  0 |                  0 |                  0 |                            0 |                        0 |                     0 |    147 |       95 |           12 |          143 |          13 |      4 |                                 70 |                               20 |            64 |
| 2.00601e+08 |          2006 |        854 |            175 |                7.49479e+06 |      1.46352e+06 |            53163 |    -107677 |               8085 |            7.73273e+06 |   237940           |       6.37572e+06 |          109929 |                      8831 |                        193698 |                 8260 |                   14702 |          80 |          90 |            66 |            86 |            58 |            65 |            66 |            52 |            43 |            43 |            40 |            22 |            17 |            21 |             9 |             3 |             5 |             0 |             0 |             0 |                    0 |        617 |                    74 |                               4 |                                  0 |                  0 |                  0 |                            0 |                        0 |                     0 |    415 |      360 |           40 |          382 |          34 |      5 |                                 75 |                               97 |           230 |
| 2.00602e+08 |          2006 |       2174 |            240 |                1.09471e+07 |      2.54796e+06 |           151492 |     -18177 |             100106 |            1.17708e+07 |   818699           |       9.48007e+06 |          104277 |                      6347 |                        589636 |                28658 |                   15720 |           5 |          11 |             7 |            10 |             8 |             4 |             3 |            11 |             8 |             5 |             3 |             3 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |             0 |                    0 |         29 |                    46 |                               0 |                                  0 |                  0 |                  0 |                            0 |                        0 |                     0 |     46 |       37 |            3 |           41 |           3 |      0 |                                 12 |                                7 |            29 |
| 2.00602e+08 |          2006 |       2379 |            150 |                5.65609e+06 |      1.22389e+06 |           250519 |     105039 |             425132 |            6.32177e+06 |   645366           |       2.63848e+06 |           75520 |                       573 |                         97524 |                15794 |                    2289 |          38 |          45 |            48 |            19 |            14 |            20 |            29 |            26 |            34 |            65 |            50 |            34 |            22 |            16 |            14 |            13 |             8 |             0 |             0 |             0 |                    0 |        265 |                   207 |                               0 |                                  0 |                  0 |                  0 |                            0 |                        0 |                     0 |    258 |      241 |           52 |          237 |          40 |      7 |                                222 |                               25 |           102 |
| 2.00602e+08 |          2006 |       2381 |            465 |                1.88637e+07 |      4.15805e+06 |           684881 |      45622 |             393921 |            1.99003e+07 |        1.02343e+06 |       1.16427e+07 |          247209 |                      9342 |                        396805 |                25857 |                   17431 |           5 |          13 |            15 |             4 |            11 |             3 |             4 |            13 |             3 |             7 |            17 |            11 |             9 |             3 |             4 |             4 |             4 |             0 |             0 |             0 |                    0 |         60 |                    71 |                               3 |                                  0 |                  0 |                  0 |                            0 |                        0 |                     0 |     72 |       58 |            9 |           88 |           7 |      0 |                                 64 |                                9 |            28 |
| 2.00602e+08 |          2006 |       2386 |            170 |                5.74304e+06 |      1.07237e+06 |           193648 |       1939 |             196163 |            6.27912e+06 |   367164           |       3.15158e+06 |           77117 |                      3873 |                        134321 |                 1849 |                    2734 |           7 |          10 |             6 |             4 |             3 |             9 |             6 |            12 |            13 |             5 |             8 |             5 |            12 |             5 |             5 |             0 |             3 |             0 |             0 |             0 |                    0 |         57 |                    60 |                               0 |                                  0 |                  0 |                  0 |                            0 |                        0 |                     0 |     69 |       60 |            3 |           81 |          13 |      0 |                                 48 |                               10 |            39 |
| 2.00602e+08 |          2006 |       2397 |            195 |                7.94701e+06 |      1.7162e+06  |           301683 |      71677 |             503459 |            8.54787e+06 |   529497           |       4.30249e+06 |          110469 |                      3273 |                        142863 |                11367 |                   10484 |          41 |          41 |            30 |            16 |            16 |            21 |            34 |            30 |            24 |            40 |            38 |            34 |            23 |            16 |            11 |             3 |             0 |             0 |             0 |             0 |                    0 |        184 |                   215 |                               3 |                                  0 |                  0 |                  0 |                            0 |                        0 |                     0 |    205 |      225 |           25 |          217 |          43 |     10 |                                187 |                               24 |            95 |
| 2.00602e+08 |          2006 |       2408 |            145 |                6.5639e+06  |      1.58739e+06 |           206758 |     100458 |             699181 |            7.17841e+06 |   611204           |       3.28522e+06 |           90692 |                         0 |                        165501 |                 3714 |                    2923 |          60 |          78 |            49 |            30 |            37 |            29 |            49 |            56 |            50 |            42 |            42 |            46 |            25 |            21 |            14 |             3 |             6 |             0 |             0 |             0 |                    0 |        252 |                   324 |                               5 |                                  0 |                  0 |                  0 |                            0 |                        0 |                     0 |    348 |      287 |           50 |          299 |          58 |     21 |                                263 |                               52 |            97 |
| 2.00602e+08 |          2006 |       2410 |             75 |                2.58348e+06 | 521874           |            40400 |     -24280 |              94774 |            2.71523e+06 |   131747           |       1.63516e+06 |           32915 |                       570 |                         87598 |                 4787 |                     986 |           4 |           0 |             3 |             4 |             0 |             0 |             3 |             8 |             4 |             5 |            10 |            13 |            10 |             3 |             3 |             6 |             0 |             0 |             0 |             0 |                    0 |         55 |                    27 |                               0 |                                  0 |                  0 |                  0 |                            0 |                        0 |                     0 |     45 |       42 |            8 |           59 |           6 |      0 |                                 37 |                               11 |            26 |
| 2.00602e+08 |          2006 |       2415 |            115 |                4.24697e+06 | 862135           |           104945 |       1683 |             114027 |            4.54806e+06 |   287156           |       3.47535e+06 |           57040 |                      2859 |                         93270 |                 5361 |                   10153 |          12 |          20 |            22 |            16 |             8 |             3 |            12 |            16 |            28 |            16 |            16 |            17 |            22 |            22 |             4 |             9 |             9 |             0 |             0 |             0 |                    0 |        118 |                   108 |                               4 |                                  0 |                  0 |                  0 |                            0 |                        0 |                     0 |    121 |      129 |           19 |          142 |          19 |      0 |                                 84 |                               24 |            65 |


Table: Ethnicity
|        id |   Income year |   Postcode | Ethnicity                        |   EthnicPopulation |
|----------:|--------------:|-----------:|:---------------------------------|-------------------:|
| 200600837 |          2006 |        837 | North African and Middle Eastern |                  0 |
| 200600838 |          2006 |        838 | North African and Middle Eastern |                  0 |
| 200600840 |          2006 |        840 | North African and Middle Eastern |                  0 |
| 200600841 |          2006 |        841 | North African and Middle Eastern |                  0 |
| 200600845 |          2006 |        845 | North African and Middle Eastern |                  0 |
| 200600847 |          2006 |        847 | North African and Middle Eastern |                  0 |
| 200600852 |          2006 |        852 | North African and Middle Eastern |                  0 |
| 200600854 |          2006 |        854 | North African and Middle Eastern |                  0 |
| 200600862 |          2006 |        862 | North African and Middle Eastern |                  0 |
| 200600885 |          2006 |        885 | North African and Middle Eastern |                  0 |


Table: Gender
|        id |   Income year |   Postcode | Gender   |   GenderPopulation |
|----------:|--------------:|-----------:|:---------|-------------------:|
| 201100800 |          2011 |        800 | Male     |               3629 |
| 201100810 |          2011 |        810 | Male     |              16776 |
| 201100812 |          2011 |        812 | Male     |               9442 |
| 201100820 |          2011 |        820 | Male     |              10205 |
| 201100828 |          2011 |        828 | Male     |                627 |
| 201100829 |          2011 |        829 | Male     |               1578 |
| 201100830 |          2011 |        830 | Male     |               9229 |
| 201100832 |          2011 |        832 | Male     |               7811 |
| 201100835 |          2011 |        835 | Male     |               3574 |
| 201100836 |          2011 |        836 | Male     |               4076 |


Table: IncomeGroup
|        id |   Income year |   Postcode | IncomeGroup   |   No. of Individuals |
|----------:|--------------:|-----------:|:--------------|---------------------:|
| 201100800 |          2011 |        800 | under or 0    |                  181 |
| 201100810 |          2011 |        810 | under or 0    |                 1647 |
| 201100812 |          2011 |        812 | under or 0    |                 1055 |
| 201100820 |          2011 |        820 | under or 0    |                  843 |
| 201100828 |          2011 |        828 | under or 0    |                   97 |
| 201100829 |          2011 |        829 | under or 0    |                   24 |
| 201100830 |          2011 |        830 | under or 0    |                  881 |
| 201100832 |          2011 |        832 | under or 0    |                  447 |
| 201100835 |          2011 |        835 | under or 0    |                  297 |
| 201100836 |          2011 |        836 | under or 0    |                  381 |


Table: MaritalStatus
|        id |   Income year |   Postcode | MaritalStatus                    |   No. of Individuals | Marriage Status   |
|----------:|--------------:|-----------:|:---------------------------------|---------------------:|:------------------|
| 201100800 |          2011 |        800 | Married in a registered marriage |                  847 | Married           |
| 201100810 |          2011 |        810 | Married in a registered marriage |                 8714 | Married           |
| 201100812 |          2011 |        812 | Married in a registered marriage |                 5633 | Married           |
| 201100820 |          2011 |        820 | Married in a registered marriage |                 4844 | Married           |
| 201100828 |          2011 |        828 | Married in a registered marriage |                  261 | Married           |
| 201100829 |          2011 |        829 | Married in a registered marriage |                   75 | Married           |
| 201100830 |          2011 |        830 | Married in a registered marriage |                 4664 | Married           |
| 201100832 |          2011 |        832 | Married in a registered marriage |                 2730 | Married           |
| 201100835 |          2011 |        835 | Married in a registered marriage |                 1598 | Married           |
| 201100836 |          2011 |        836 | Married in a registered marriage |                 2082 | Married           |


Table: Year
|   Year  |
|--------:|
|    2006 |
|    2011 |
|    2015 |

 


tables: name: ABSAgeGroup
data: ABSAgeGroup.csv
name: ATOTaxDetails
data: ATOTaxDetails.csv
name: AustralianLocations
data: AustralianLocations.csv
name: Data
data: Data.csv
name: Ethnicity
data: Ethnicity.csv
name: Gender
data: Gender.csv
name: IncomeGroup
data: IncomeGroup.csv
name: MaritalStatus
data: MaritalStatus.csv
name: Year
data: Year.csv
label: IncomeGroup
Postcode
AustralianLocations
PostCode
Ethnicity
Postcode
AustralianLocations
PostCode
ABSAgeGroup
Postcode
AustralianLocations
PostCode
ATOTaxDetails
Postcode
AustralianLocations
PostCode
Gender
Postcode
AustralianLocations
PostCode
MaritalStatus
Postcode
AustralianLocations
PostCode
IncomeGroup
Income year
Year
Year 
Ethnicity
Income year
Year
Year 
ABSAgeGroup
Income year
Year
Year 
MaritalStatus
Income year
Year
Year 
Gender
Income year
Year
Year 
ATOTaxDetails
Income year
Year
Year 
ABSAgeGroup
id
Data
id
IncomeGroup
id
Data
id
output: {
    "joins": [
        {
            "from_table": "IncomeGroup",
            "from_column": "Postcode",
            "to_table": "AustralianLocations",
            "to_column": "PostCode"
        },
        {
            "from_table": "Ethnicity",
            "from_column": "Postcode",
            "to_table": "AustralianLocations",
            "to_column": "PostCode"
        },
        {
            "from_table": "ABSAgeGroup",
            "from_column": "Postcode",
            "to_table": "AustralianLocations",
            "to_column": "PostCode"
        },
        {
            "from_table": "ATOTaxDetails",
            "from_column": "Postcode",
            "to_table": "AustralianLocations",
            "to_column": "PostCode"
        },
        {
            "from_table": "Gender",
            "from_column": "Postcode",
            "to_table": "AustralianLocations",
            "to_column": "PostCode"
        },
        {
            "from_table": "MaritalStatus",
            "from_column": "Postcode",
            "to_table": "AustralianLocations",
            "to_column": "PostCode"
        },
        {
            "from_table": "IncomeGroup",
            "from_column": "Income year",
            "to_table": "Year",
            "to_column": "Year "
        },
        {
            "from_table": "Ethnicity",
            "from_column": "Income year",
            "to_table": "Year",
            "to_column": "Year "
        },
        {
            "from_table": "ABSAgeGroup",
            "from_column": "Income year",
            "to_table": "Year",
            "to_column": "Year "
        },
        {
            "from_table": "MaritalStatus",
            "from_column": "Income year",
            "to_table": "Year",
            "to_column": "Year "
        },
        {
            "from_table": "Gender",
            "from_column": "Income year",
            "to_table": "Year",
            "to_column": "Year "
        },
        {
            "from_table": "ATOTaxDetails",
            "from_column": "Income year",
            "to_table": "Year",
            "to_column": "Year "
        },
        {
            "from_table": "ABSAgeGroup",
            "from_column": "id",
            "to_table": "Data",
            "to_column": "id"
        },
        {
            "from_table": "IncomeGroup",
            "from_column": "id",
            "to_table": "Data",
            "to_column": "id"
        }
    ]
}