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: Brokers_Tbl
|   BrokerID | BrokerCode   | BrokerFullName     | DistributionNetwork   | DistributionChannel   | CommissionScheme   |
|-----------:|:-------------|:-------------------|:----------------------|:----------------------|:-------------------|
|         49 | Brk-000049   | Willie Oliver      | Direct                | Tele sales            | Comm-2             |
|        116 | Brk-000116   | Jose Mccoy         | Direct                | Tele sales            | Bonus Based        |
|        138 | Brk-000138   | Randy Alexander    | Direct                | Tele sales            | No Commission      |
|        194 | Brk-000194   | Kevin Johnson      | Direct                | Tele sales            | Comm-2             |
|        235 | Brk-000235   | Todd Gomez         | Direct                | Tele sales            | Comm-2             |
|        269 | Brk-000269   | Howard Wright      | Direct                | Tele sales            | Comm-7             |
|        347 | Brk-000347   | Harold Weaver      | Direct                | Tele sales            | Comm-2             |
|        356 | Brk-000356   | Matthew Scott      | Direct                | Tele sales            | No Commission      |
|        486 | Brk-000486   | Victor Robertson   | Direct                | Tele sales            | No Commission      |
|        597 | Brk-000597   | Jeffrey Williamson | Direct                | Tele sales            | Comm-6             |


Table: Categories_Tbl
|   ID | Categories                                                        |   Active |
|-----:|:------------------------------------------------------------------|---------:|
|    1 | REVIVAL REQUEST                                                   |        1 |
|    2 | CONTRACT NOTICE (USE OR FAITH)                                    |        1 |
|    3 | ACCOMMODATION RECONSTRUCTION                                      |        1 |
|    4 | DISCLAIMER OF A SERVICE                                           |        1 |
|    5 | AUTOMATIC REPRESENTATIVE CARD RENEW WITHOUT THE CUSTOMER'S RENEW  |        0 |
|    6 | CONCLUSION HELLIPIS SERVICE FROM EXECUTIVE / EXTERNAL COOPERATIVE |        1 |
|    7 | MODIFICATION REQUEST                                              |        1 |
|    8 | CONTRACT-MAINTENANCE DEVELOPMENT                                  |        1 |
|    9 | DIFFERENCES IN PRICE POLITICS                                     |        1 |
|   10 | POOR SERVICE                                                      |        1 |


Table: ComplainsData_Tbl
|   ID | ComplainDate            | CompletionDate          |   CustomerID |   BrokerID |   ProductID |   ComplainPriorityID |   ComplainTypeID |   ComplainSourceID |   ComplainCategoryID |   ComplainStatusID |   AdministratorID | ClientSatisfaction   |   ExpectedReimbursement | ComplaintCat                   | ComplainType   |
|-----:|:------------------------|:------------------------|-------------:|-----------:|------------:|---------------------:|-----------------:|-------------------:|---------------------:|-------------------:|------------------:|:---------------------|------------------------:|:-------------------------------|:---------------|
| 8888 | 2018-01-05 00:00:00.000 | 2018-01-24 00:00:00.000 |      1814075 |      12256 |          15 |                    2 |                5 |                  5 |                   59 |                  9 |                16 | SAT                  |                       0 | YOU HAVE ALWAYS BEEN REQUESTED | Email          |
| 8947 | 2018-01-22 00:00:00.000 | 2018-01-26 00:00:00.000 |      1845086 |      11127 |           3 |                    2 |                5 |                  5 |                   59 |                  9 |                16 | SAT                  |                       0 | YOU HAVE ALWAYS BEEN REQUESTED | Email          |
| 8949 | 2018-01-22 00:00:00.000 | 2018-01-24 00:00:00.000 |      2463182 |      11204 |          32 |                    2 |                5 |                  5 |                   59 |                  9 |                16 | SAT                  |                       0 | YOU HAVE ALWAYS BEEN REQUESTED | Email          |
| 8952 | 2018-01-22 00:00:00.000 | 2018-01-25 00:00:00.000 |      2348805 |       2613 |          73 |                    2 |                5 |                  5 |                   59 |                  9 |                16 | SAT                  |                       0 | YOU HAVE ALWAYS BEEN REQUESTED | Email          |
| 8955 | 2018-01-22 00:00:00.000 | 2018-01-25 00:00:00.000 |       756561 |      11099 |           7 |                    2 |                5 |                  5 |                   59 |                  9 |                16 | SAT                  |                       0 | YOU HAVE ALWAYS BEEN REQUESTED | Email          |
| 8958 | 2018-01-22 00:00:00.000 | 2018-01-25 00:00:00.000 |       575572 |       8932 |          40 |                    2 |                5 |                  5 |                   59 |                  9 |                16 | SAT                  |                       0 | YOU HAVE ALWAYS BEEN REQUESTED | Email          |
| 8972 | 2018-01-23 00:00:00.000 | 2018-01-25 00:00:00.000 |      1799479 |       2178 |          66 |                    2 |                5 |                  5 |                   59 |                  9 |                16 | SAT                  |                       0 | YOU HAVE ALWAYS BEEN REQUESTED | Email          |
| 8986 | 2018-01-25 00:00:00.000 | 2018-01-26 00:00:00.000 |      2084052 |      11217 |          40 |                    2 |                5 |                  5 |                   59 |                  9 |                16 | SAT                  |                       0 | YOU HAVE ALWAYS BEEN REQUESTED | Email          |
| 9004 | 2018-01-29 00:00:00.000 | 2018-01-31 00:00:00.000 |       101467 |      11849 |          17 |                    2 |                5 |                  5 |                   59 |                  9 |                16 | SAT                  |                       0 | YOU HAVE ALWAYS BEEN REQUESTED | Email          |
| 9009 | 2018-01-29 00:00:00.000 | 2018-01-31 00:00:00.000 |      1899906 |       2158 |          35 |                    2 |                5 |                  5 |                   59 |                  9 |                16 | SAT                  |                       0 | YOU HAVE ALWAYS BEEN REQUESTED | Email          |


Table: Customers_Tbl
|   CustomerID | LastName   | FirstName   | BirthDate               | Gender   | ParticipantType   |   RegionID | MaritalStatus   |
|-------------:|:-----------|:------------|:------------------------|:---------|:------------------|-----------:|:----------------|
|          110 | Thomas     | Burke       | 1971-09-04 00:00:00.000 | MALE     | INDIVIDUAL        |        388 | Married         |
|         1240 | Scott      | Roberts     | 1978-01-31 00:00:00.000 | MALE     | INDIVIDUAL        |        863 | Married         |
|         1475 | Gerald     | Rogers      | 2012-06-25 00:00:00.000 | MALE     | INDIVIDUAL        |        627 | Married         |
|         1517 | Anthony    | Knight      | 1969-03-19 00:00:00.000 | MALE     | INDIVIDUAL        |        840 | Married         |
|         1582 | Scott      | Miller      | 1967-07-12 00:00:00.000 | MALE     | INDIVIDUAL        |        142 | Married         |
|         2395 | Charles    | Riley       | 1969-10-25 00:00:00.000 | MALE     | INDIVIDUAL        |        983 | Married         |
|         2932 | Jesse      | Lane        | 1991-07-17 00:00:00.000 | MALE     | INDIVIDUAL        |        837 | Married         |
|         4109 | Jack       | Simmons     | 1960-12-10 00:00:00.000 | MALE     | INDIVIDUAL        |         59 | Married         |
|         4437 | Larry      | Garza       | 1973-07-21 00:00:00.000 | MALE     | INDIVIDUAL        |         16 | Married         |
|         5464 | Russell    | Harper      | 1963-03-17 00:00:00.000 | MALE     | INDIVIDUAL        |        385 | Married         |


Table: Dates
| Date                    |   Year |   QuarterOfYear |   MonthOfYear |   DayOfMonth |   DateInt | Month Name   | Month & Year   | Quarter & Year   |   DayOfWeek | DayOfWeekName   | WeekEnding              | MonthEnding             |   ISO Weeknumber |   ISO Year |   ISO Day of Year | Week & Year   |   WeeknYear |   MonthnYear |   QuarternYear | Fiscal Year   | Fiscal Quarter   |   Fiscal Period | IsAfterToday   | IsWorkingDay   | IsHoliday   | IsBusinessDay   | Day Type   |   WeekOffset |   MonthOffset |   QuarterOffset |   YearOffset |   FiscalYearOffset | WeekCompleted   | MonthCompleted   | QuarterCompleted   |   Werkdagen |
|:------------------------|-------:|----------------:|--------------:|-------------:|----------:|:-------------|:---------------|:-----------------|------------:|:----------------|:------------------------|:------------------------|-----------------:|-----------:|------------------:|:--------------|------------:|-------------:|---------------:|:--------------|:-----------------|----------------:|:---------------|:---------------|:------------|:----------------|:-----------|-------------:|--------------:|----------------:|-------------:|-------------------:|:----------------|:-----------------|:-------------------|------------:|
| 2017-01-02 00:00:00.000 |   2017 |               1 |             1 |            2 |  20170102 | januari      | jan 2017       | Q1 2017          |           0 | maandag         | 2017-01-08 00:00:00.000 | 2017-01-31 00:00:00.000 |                1 |       2017 |                 1 | 2017-01       |    20170100 |     20170100 |       20170100 | FY18          | FQ1              |               1 | False          | True           | Unknown     | True            | Weekday    |         -190 |           -43 |             -14 |           -3 |                 -3 | True            | True             | True               |           1 |
| 2017-01-03 00:00:00.000 |   2017 |               1 |             1 |            3 |  20170103 | januari      | jan 2017       | Q1 2017          |           1 | dinsdag         | 2017-01-08 00:00:00.000 | 2017-01-31 00:00:00.000 |                1 |       2017 |                 2 | 2017-01       |    20170100 |     20170100 |       20170100 | FY18          | FQ1              |               1 | False          | True           | Unknown     | True            | Weekday    |         -190 |           -43 |             -14 |           -3 |                 -3 | True            | True             | True               |           1 |
| 2017-01-04 00:00:00.000 |   2017 |               1 |             1 |            4 |  20170104 | januari      | jan 2017       | Q1 2017          |           2 | woensdag        | 2017-01-08 00:00:00.000 | 2017-01-31 00:00:00.000 |                1 |       2017 |                 3 | 2017-01       |    20170100 |     20170100 |       20170100 | FY18          | FQ1              |               1 | False          | True           | Unknown     | True            | Weekday    |         -190 |           -43 |             -14 |           -3 |                 -3 | True            | True             | True               |           1 |
| 2017-01-05 00:00:00.000 |   2017 |               1 |             1 |            5 |  20170105 | januari      | jan 2017       | Q1 2017          |           3 | donderdag       | 2017-01-08 00:00:00.000 | 2017-01-31 00:00:00.000 |                1 |       2017 |                 4 | 2017-01       |    20170100 |     20170100 |       20170100 | FY18          | FQ1              |               1 | False          | True           | Unknown     | True            | Weekday    |         -190 |           -43 |             -14 |           -3 |                 -3 | True            | True             | True               |           1 |
| 2017-01-06 00:00:00.000 |   2017 |               1 |             1 |            6 |  20170106 | januari      | jan 2017       | Q1 2017          |           4 | vrijdag         | 2017-01-08 00:00:00.000 | 2017-01-31 00:00:00.000 |                1 |       2017 |                 5 | 2017-01       |    20170100 |     20170100 |       20170100 | FY18          | FQ1              |               1 | False          | True           | Unknown     | True            | Weekday    |         -190 |           -43 |             -14 |           -3 |                 -3 | True            | True             | True               |           1 |
| 2017-01-09 00:00:00.000 |   2017 |               1 |             1 |            9 |  20170109 | januari      | jan 2017       | Q1 2017          |           0 | maandag         | 2017-01-15 00:00:00.000 | 2017-01-31 00:00:00.000 |                2 |       2017 |                 8 | 2017-02       |    20170200 |     20170100 |       20170100 | FY18          | FQ1              |               1 | False          | True           | Unknown     | True            | Weekday    |         -189 |           -43 |             -14 |           -3 |                 -3 | True            | True             | True               |           1 |
| 2017-01-10 00:00:00.000 |   2017 |               1 |             1 |           10 |  20170110 | januari      | jan 2017       | Q1 2017          |           1 | dinsdag         | 2017-01-15 00:00:00.000 | 2017-01-31 00:00:00.000 |                2 |       2017 |                 9 | 2017-02       |    20170200 |     20170100 |       20170100 | FY18          | FQ1              |               1 | False          | True           | Unknown     | True            | Weekday    |         -189 |           -43 |             -14 |           -3 |                 -3 | True            | True             | True               |           1 |
| 2017-01-11 00:00:00.000 |   2017 |               1 |             1 |           11 |  20170111 | januari      | jan 2017       | Q1 2017          |           2 | woensdag        | 2017-01-15 00:00:00.000 | 2017-01-31 00:00:00.000 |                2 |       2017 |                10 | 2017-02       |    20170200 |     20170100 |       20170100 | FY18          | FQ1              |               1 | False          | True           | Unknown     | True            | Weekday    |         -189 |           -43 |             -14 |           -3 |                 -3 | True            | True             | True               |           1 |
| 2017-01-12 00:00:00.000 |   2017 |               1 |             1 |           12 |  20170112 | januari      | jan 2017       | Q1 2017          |           3 | donderdag       | 2017-01-15 00:00:00.000 | 2017-01-31 00:00:00.000 |                2 |       2017 |                11 | 2017-02       |    20170200 |     20170100 |       20170100 | FY18          | FQ1              |               1 | False          | True           | Unknown     | True            | Weekday    |         -189 |           -43 |             -14 |           -3 |                 -3 | True            | True             | True               |           1 |
| 2017-01-13 00:00:00.000 |   2017 |               1 |             1 |           13 |  20170113 | januari      | jan 2017       | Q1 2017          |           4 | vrijdag         | 2017-01-15 00:00:00.000 | 2017-01-31 00:00:00.000 |                2 |       2017 |                12 | 2017-02       |    20170200 |     20170100 |       20170100 | FY18          | FQ1              |               1 | False          | True           | Unknown     | True            | Weekday    |         -189 |           -43 |             -14 |           -3 |                 -3 | True            | True             | True               |           1 |


Table: Priorities_Tbl
|   ID | Description   |
|-----:|:--------------|
|    1 | Urgent        |
|    2 | Non Urgent    |


Table: Products_Tbl
|   ProductID | ProductCategory   | ProductSubCategory   | Product   | Hproduct   | HproductCategory   | HSubCategory       |
|------------:|:------------------|:---------------------|:----------|:-----------|:-------------------|:-------------------|
|           1 | Property          | Non Mortgaged        | PNM-001   | PNM-001    | Property           | Non Mortgaged      |
|           2 | Property          | Non Mortgaged        | PNM-002   | PNM-002    | Property           | Non Mortgaged      |
|           3 | Property          | Non Mortgaged        | PNM-003   | PNM-003    | Property           | Non Mortgaged      |
|           4 | Mortgaged         | Mortgaged Property   | MMP-004   | MMP-004    | Mortgaged          | Mortgaged Property |
|           5 | Mortgaged         | Mortgaged Property   | MMP-005   | MMP-005    | Mortgaged          | Mortgaged Property |
|           6 | Mortgaged         | Mortgaged Property   | MMP-006   | MMP-006    | Mortgaged          | Mortgaged Property |
|           7 | Motor             | Motor Standard       | MOT-007   | MOT-007    | Motor              | Motor Standard     |
|           8 | Motor             | Motor Plus           | MOT-008   | MOT-008    | Motor              | Motor Plus         |
|           9 | Motor             | Motor Standard       | MOT-009   | MOT-009    | Motor              | Motor Standard     |
|          10 | Motor             | Motor Plus           | MOT-010   | MOT-010    | Motor              | Motor Plus         |


Table: Regions_Tbl
|   id | name         | county              | state_code   | state      | type   |   latitude |   longitude |   area_code |   population |   households |   median_income |   land_area |   water_area | time_zone           |
|-----:|:-------------|:--------------------|:-------------|:-----------|:-------|-----------:|------------:|------------:|-------------:|-------------:|----------------:|------------:|-------------:|:--------------------|
|   38 | Alameda      | Alameda County      | CA           | California | City   |    37.7652 |    -122.242 |         510 |        78630 |        30708 |           79312 |    27045458 |     32778370 | America/Los Angeles |
|   39 | Alhambra     | Los Angeles County  | CA           | California | City   |    34.0953 |    -118.127 |         626 |        85551 |        29174 |           53582 |    19764230 |         1730 | America/Los Angeles |
|   40 | Aliso Viejo  | Orange County       | CA           | California | City   |    33.565  |    -117.727 |         949 |        50195 |        18425 |          102367 |    17921214 |            0 | America/Los Angeles |
|   41 | Anaheim      | Orange County       | CA           | California | City   |    33.8353 |    -117.915 |         657 |       350742 |        99670 |           60752 |   129438076 |      2457142 | America/Los Angeles |
|   42 | Antioch      | Contra Costa County | CA           | California | City   |    38.0049 |    -121.806 |         925 |       110542 |        33718 |           64329 |    76173197 |      1842711 | America/Los Angeles |
|   44 | Arcadia      | Los Angeles County  | CA           | California | City   |    34.1397 |    -118.035 |         626 |        58408 |        19559 |           79934 |    28295893 |       540014 | America/Los Angeles |
|   46 | Bakersfield  | Kern County         | CA           | California | City   |    35.3733 |    -119.019 |         661 |       373640 |       112439 |           57095 |   385366784 |      3809676 | America/Los Angeles |
|   47 | Baldwin Park | Los Angeles County  | CA           | California | City   |    34.0853 |    -117.961 |         626 |        77071 |        17674 |           51742 |    17174857 |       399817 | America/Los Angeles |
|   48 | Bellflower   | Los Angeles County  | CA           | California | City   |    33.8817 |    -118.117 |         562 |        78441 |        23176 |           48823 |    15845460 |       138188 | America/Los Angeles |
|   49 | Berkeley     | Alameda County      | CA           | California | City   |    37.8716 |    -122.273 |         510 |       120972 |        45917 |           66237 |    27106077 |     18715614 | America/Los Angeles |


Table: Sources_Tbl
|   ID | Description         |
|-----:|:--------------------|
|    1 | Bank Branch         |
|    2 | Tele                |
|    3 | Bank HQ             |
|    4 | Partner             |
|    5 | Company HQ          |
|    6 | Intermediary        |
|    7 | CRO                 |
|    8 | Call Center         |
|    9 | Bank Small Business |


Table: StateRegions_Tbl
| State Code   | State                | Region    |
|:-------------|:---------------------|:----------|
| AL           | Alabama              | South     |
| AR           | Arkansas             | South     |
| AZ           | Arizona              | West      |
| CA           | California           | West      |
| CO           | Colorado             | West      |
| CT           | Connecticut          | Northeast |
| DC           | District of Columbia | South     |
| DE           | Delaware             | South     |
| FL           | Florida              | South     |
| GA           | Georgia              | South     |


Table: Statuses_Tbl
|   ID | Description   |
|-----:|:--------------|
|    1 | OUTSTANDING   |
|    2 | NEW           |
|    3 | IN PROGRESS   |
|    4 | ASSIGNED TO   |
|    5 | RESOLVED      |
|    6 | PENDING       |
|    9 | CLOSED        |


Table: StatusHistoryData_Tbl
|   ID |   ComplaintID |   ComplaintStatusID | StatusDate              |   Rank Complaints StatusDate |   Diff. Current v Prev.s Dates X | Status   |
|-----:|--------------:|--------------------:|:------------------------|-----------------------------:|---------------------------------:|:---------|
| 3750 |         10943 |                   9 | 2019-03-28 00:00:00.000 |                            6 |                                1 | CLOSED   |
| 3748 |         11174 |                   9 | 2019-03-28 00:00:00.000 |                            5 |                                2 | CLOSED   |
| 3814 |         11439 |                   9 | 2019-03-28 00:00:00.000 |                            2 |                                8 | CLOSED   |
| 3809 |         11440 |                   9 | 2019-03-28 00:00:00.000 |                            2 |                                8 | CLOSED   |
| 3805 |         11441 |                   9 | 2019-03-28 00:00:00.000 |                            2 |                                8 | CLOSED   |
| 3802 |         11442 |                   9 | 2019-03-28 00:00:00.000 |                            2 |                                8 | CLOSED   |
| 3796 |         11443 |                   9 | 2019-03-28 00:00:00.000 |                            2 |                                8 | CLOSED   |
| 3794 |         11444 |                   9 | 2019-03-28 00:00:00.000 |                            2 |                                8 | CLOSED   |
| 3781 |         11445 |                   9 | 2019-03-28 00:00:00.000 |                            2 |                                8 | CLOSED   |
| 3745 |         11447 |                   9 | 2019-03-28 00:00:00.000 |                            2 |                                8 | CLOSED   |


Table: Types_Tbl
|   ID | Description    |
|-----:|:---------------|
|    1 | Court          |
|    2 | In person      |
|    3 | Written        |
|    4 | Court Order    |
|    5 | Email          |
|    6 | Fax            |
|    7 | Phone          |
|    8 | Call center    |
|    9 | Partner / Bank |
|   99 | Other          |

 


tables: name: Brokers_Tbl
data: Brokers_Tbl.csv
name: Categories_Tbl
data: Categories_Tbl.csv
name: ComplainsData_Tbl
data: ComplainsData_Tbl.csv
name: Customers_Tbl
data: Customers_Tbl.csv
name: Dates
data: Dates.csv
name: Priorities_Tbl
data: Priorities_Tbl.csv
name: Products_Tbl
data: Products_Tbl.csv
name: Regions_Tbl
data: Regions_Tbl.csv
name: Sources_Tbl
data: Sources_Tbl.csv
name: StateRegions_Tbl
data: StateRegions_Tbl.csv
name: Statuses_Tbl
data: Statuses_Tbl.csv
name: StatusHistoryData_Tbl
data: StatusHistoryData_Tbl.csv
name: Types_Tbl
data: Types_Tbl.csv
label: Regions_Tbl
state_code
StateRegions_Tbl
State Code
ComplainsData_Tbl
BrokerID
Brokers_Tbl
BrokerID
ComplainsData_Tbl
CustomerID
Customers_Tbl
CustomerID
ComplainsData_Tbl
ProductID
Products_Tbl
ProductID
ComplainsData_Tbl
ComplainCategoryID
Categories_Tbl
ID
ComplainsData_Tbl
ComplainDate
Dates
Date
ComplainsData_Tbl
ComplainPriorityID
Priorities_Tbl
ID
Customers_Tbl
RegionID
Regions_Tbl
id
StatusHistoryData_Tbl
ComplaintID
ComplainsData_Tbl
ID
ComplainsData_Tbl
ComplainSourceID
Sources_Tbl
ID
ComplainsData_Tbl
ComplainTypeID
Types_Tbl
ID
ComplainsData_Tbl
ComplainStatusID
Statuses_Tbl
ID
output: {
    "joins": [
        {
            "from_table": "Regions_Tbl",
            "from_column": "state_code",
            "to_table": "StateRegions_Tbl",
            "to_column": "State Code"
        },
        {
            "from_table": "ComplainsData_Tbl",
            "from_column": "BrokerID",
            "to_table": "Brokers_Tbl",
            "to_column": "BrokerID"
        },
        {
            "from_table": "ComplainsData_Tbl",
            "from_column": "CustomerID",
            "to_table": "Customers_Tbl",
            "to_column": "CustomerID"
        },
        {
            "from_table": "ComplainsData_Tbl",
            "from_column": "ProductID",
            "to_table": "Products_Tbl",
            "to_column": "ProductID"
        },
        {
            "from_table": "ComplainsData_Tbl",
            "from_column": "ComplainCategoryID",
            "to_table": "Categories_Tbl",
            "to_column": "ID"
        },
        {
            "from_table": "ComplainsData_Tbl",
            "from_column": "ComplainDate",
            "to_table": "Dates",
            "to_column": "Date"
        },
        {
            "from_table": "ComplainsData_Tbl",
            "from_column": "ComplainPriorityID",
            "to_table": "Priorities_Tbl",
            "to_column": "ID"
        },
        {
            "from_table": "Customers_Tbl",
            "from_column": "RegionID",
            "to_table": "Regions_Tbl",
            "to_column": "id"
        },
        {
            "from_table": "StatusHistoryData_Tbl",
            "from_column": "ComplaintID",
            "to_table": "ComplainsData_Tbl",
            "to_column": "ID"
        },
        {
            "from_table": "ComplainsData_Tbl",
            "from_column": "ComplainSourceID",
            "to_table": "Sources_Tbl",
            "to_column": "ID"
        },
        {
            "from_table": "ComplainsData_Tbl",
            "from_column": "ComplainTypeID",
            "to_table": "Types_Tbl",
            "to_column": "ID"
        },
        {
            "from_table": "ComplainsData_Tbl",
            "from_column": "ComplainStatusID",
            "to_table": "Statuses_Tbl",
            "to_column": "ID"
        }
    ]
}