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: cim_dim_battery
|   Row_Number | Battery           |   BatteryId |   ObjectID_CombinedID |          CombinedId |
|-------------:|:------------------|------------:|----------------------:|--------------------:|
|           33 | 101_Battery       |           1 | 1_6282583166545062256 | 6282583166545062256 |
|           34 | 119_Battery       |           2 | 2_6282583166545062256 | 6282583166545062256 |
|           35 | 215_Battery       |           3 | 3_6282583166545062256 | 6282583166545062256 |
|           36 | 303_Battery       |           4 | 4_6282583166545062256 | 6282583166545062256 |
|           37 | 317_Battery       |           5 | 5_6282583166545062256 | 6282583166545062256 |
|           38 | 325_Battery       |           6 | 6_6282583166545062256 | 6282583166545062256 |
|           39 | capEx_Battery_206 |           7 | 7_6282583166545062256 | 6282583166545062256 |
|           40 | capEx_Battery_312 |           8 | 8_6282583166545062256 | 6282583166545062256 |
|          101 | 101_Battery       |           1 | 1_1163433827361148046 | 1163433827361148046 |
|          102 | 119_Battery       |           2 | 2_1163433827361148046 | 1163433827361148046 |


Table: cim_dim_combined_id_table
|   Row_Number | tenantId                             | studyId                              | executionId                          | simulationId                         | studyName                       | modelName                 |   re_run_count | last_execution_date     | pipeline_started_at     | pipeline_completed_at   | pipeline_status   |          CombinedId |
|-------------:|:-------------------------------------|:-------------------------------------|:-------------------------------------|:-------------------------------------|:--------------------------------|:--------------------------|---------------:|:------------------------|:------------------------|:------------------------|:------------------|--------------------:|
|           19 | 9340e69c-3c33-4801-b747-c04f6bf6fcef | 35e9bcce-6139-4805-a5a4-b706b2ddf98e | 37321430-e49b-4597-b4a7-1dadfba603b5 | d4d20aee-a483-42ec-8307-ee71e8fd915c | 15YearExpansion                 | 15 Year Expansion Plan HG |              2 | 2020-12-01 11:21:17.043 | 2020-12-01 11:21:17.043 |                         | Running           | 6282583166545062256 |
|           20 | 9340e69c-3c33-4801-b747-c04f6bf6fcef | a2955987-95f2-440a-88ac-d60e76f08d43 | d3c8e12f-5ad2-44fd-bc7f-3e1fb10531bf | d313bffa-d564-454f-8982-f242a47f3365 | Jinendra_Carlos_15YearsExp_Demo | 15 Year Expansion Plan LW |              2 | 2020-12-01 11:52:12.556 | 2020-12-01 11:52:12.556 |                         | Running           | 1163433827361148046 |
|            6 | 9340e69c-3c33-4801-b747-c04f6bf6fcef | a2955987-95f2-440a-88ac-d60e76f08d43 | 1a50b7e3-1c1d-4469-a422-bd7fe23942db | 249f5ba4-1898-46aa-ac05-ce10142e4dbe | Jinendra_Carlos_15YearsExp_Demo | 15 Year Expansion Plan LG |              2 | 2020-11-25 06:31:16.490 | 2020-11-25 06:31:16.490 |                         | Running           | 3584578854011152015 |


Table: cim_dim_date
| DeliveryDateTime        | PeriodType   |   DateId |
|:------------------------|:-------------|---------:|
| 2020-03-26 11:00:00.000 | H            |    18273 |
| 2020-03-26 12:00:00.000 | H            |    18274 |
| 2020-03-26 13:00:00.000 | H            |    18275 |
| 2020-03-26 14:00:00.000 | H            |    18276 |
| 2020-03-26 15:00:00.000 | H            |    18277 |
| 2020-03-26 16:00:00.000 | H            |    18278 |
| 2020-03-26 17:00:00.000 | H            |    18279 |
| 2020-03-26 18:00:00.000 | H            |    18280 |
| 2020-03-26 19:00:00.000 | H            |    18281 |
| 2020-03-26 20:00:00.000 | H            |    18282 |


Table: cim_dim_emission
|   Row_Number |   Band | Emission   |   EmissionId |   Max_Production |   ObjectID_CombinedID |   Price_Scalar |   Production_Rate |   Shadow_Price |          CombinedId |
|-------------:|-------:|:-----------|-------------:|-----------------:|----------------------:|---------------:|------------------:|---------------:|--------------------:|
|           15 |      0 | CO2        |            1 |                0 | 1_1163433827361148046 |              0 |                 0 |           0.02 | 1163433827361148046 |
|            6 |      0 | CO2        |            1 |                0 | 1_3584578854011152015 |              0 |                 0 |           0.02 | 3584578854011152015 |
|           14 |      0 | CO2        |            1 |                0 | 1_6282583166545062256 |              0 |                 0 |           0.02 | 6282583166545062256 |


Table: cim_dim_fuel
|   Row_Number | Abatement   | Emission   | Fuel       |   FuelId |    ObjectID_CombinedID |          CombinedId |
|-------------:|:------------|:-----------|:-----------|---------:|-----------------------:|--------------------:|
|          153 |             |            | Coal/Steam |        1 |  1_1163433827361148046 | 1163433827361148046 |
|          154 |             |            | Wind       |       11 | 11_1163433827361148046 | 1163433827361148046 |
|          155 |             |            | Nuclear    |        5 |  5_1163433827361148046 | 1163433827361148046 |
|          156 |             |            | PV         |        8 |  8_1163433827361148046 | 1163433827361148046 |
|          157 |             |            | NG/CT      |        4 |  4_1163433827361148046 | 1163433827361148046 |
|          158 |             |            | Hydro      |        2 |  2_1163433827361148046 | 1163433827361148046 |
|          159 |             |            | Oil/Steam  |        7 |  7_1163433827361148046 | 1163433827361148046 |
|          160 |             |            | SynchCond  |       10 | 10_1163433827361148046 | 1163433827361148046 |
|          161 |             |            | RTPV       |        9 |  9_1163433827361148046 | 1163433827361148046 |
|          162 |             |            | NG/CC      |        3 |  3_1163433827361148046 | 1163433827361148046 |


Table: cim_dim_generator
|   Row_Number | Abatement   | Emission   | Forced_Outage_Rate   | Fuel   | Generator   |   GeneratorId | Heat_Rate   |   Latitude |   Longitude |   Max_Capacity | Max_Ramp_Down   | Max_Ramp_Up   | Mean_Time_to_Repair   | Min_Down_Time   | Min_Up_Time   |   Node |     ObjectID_CombinedID |   Reserve_Share | Start_Cost   |   Start_Cost_Time |          CombinedId |
|-------------:|:------------|:-----------|:---------------------|:-------|:------------|--------------:|:------------|-----------:|------------:|---------------:|:----------------|:--------------|:----------------------|:----------------|:--------------|-------:|------------------------:|----------------:|:-------------|------------------:|--------------------:|
|          953 |             |            |                      | RTPV   | 313_rtpv_12 |           116 |             |          0 |           0 |           27.8 |                 |               |                       |                 |               |    313 | 116_3584578854011152015 |               0 |              |                 0 | 3584578854011152015 |
|          956 |             |            |                      | RTPV   | 118_rtpv_7  |            39 |             |          0 |           0 |           11.8 |                 |               |                       |                 |               |    118 |  39_3584578854011152015 |               0 |              |                 0 | 3584578854011152015 |
|          967 |             |            |                      | RTPV   | 213_rtpv    |            69 |             |          0 |           0 |           13.2 |                 |               |                       |                 |               |    213 |  69_3584578854011152015 |               0 |              |                 0 | 3584578854011152015 |
|          975 |             |            |                      | RTPV   | 308_rtpv    |           105 |             |          0 |           0 |          100.9 |                 |               |                       |                 |               |    308 | 105_3584578854011152015 |               0 |              |                 0 | 3584578854011152015 |
|          978 |             |            |                      | RTPV   | 313_rtpv_6  |           122 |             |          0 |           0 |           63.8 |                 |               |                       |                 |               |    313 | 122_3584578854011152015 |               0 |              |                 0 | 3584578854011152015 |
|          987 |             |            |                      | RTPV   | 118_rtpv_10 |            33 |             |          0 |           0 |            4.5 |                 |               |                       |                 |               |    118 |  33_3584578854011152015 |               0 |              |                 0 | 3584578854011152015 |
|          994 |             |            |                      | RTPV   | 320_rtpv_2  |           149 |             |          0 |           0 |           27   |                 |               |                       |                 |               |    320 | 149_3584578854011152015 |               0 |              |                 0 | 3584578854011152015 |
|          996 |             |            |                      | RTPV   | 313_rtpv    |           113 |             |          0 |           0 |          101.7 |                 |               |                       |                 |               |    313 | 113_3584578854011152015 |               0 |              |                 0 | 3584578854011152015 |
|          998 |             |            |                      | RTPV   | 320_rtpv_4  |           151 |             |          0 |           0 |           27   |                 |               |                       |                 |               |    320 | 151_3584578854011152015 |               0 |              |                 0 | 3584578854011152015 |
|         1001 |             |            |                      | RTPV   | 118_rtpv_5  |            37 |             |          0 |           0 |            9.1 |                 |               |                       |                 |               |    118 |  37_3584578854011152015 |               0 |              |                 0 | 3584578854011152015 |


Table: cim_dim_line
|   Row_Number |   Forced_Outage_Rate |   Latitude |      Line |   LineId |   Longitude |   Max_Flow |   Mean_Time_to_Repair |   Node_From |   Node_To |     ObjectID_CombinedID |   Reactance |   Resistance |   Voltage |          CombinedId |
|-------------:|---------------------:|-----------:|----------:|---------:|------------:|-----------:|----------------------:|------------:|----------:|------------------------:|------------:|-------------:|----------:|--------------------:|
|          516 |                    0 |          0 | 320_323_2 |      125 |           0 |        550 |                     0 |         320 |       323 | 125_3584578854011152015 |       0.022 |        0.003 |         0 | 3584578854011152015 |
|          518 |                    0 |          0 | 111_114_1 |       21 |           0 |        550 |                     0 |         111 |       114 |  21_3584578854011152015 |       0.042 |        0.005 |         0 | 3584578854011152015 |
|          519 |                    0 |          0 | 120_123_1 |       42 |           0 |        550 |                     0 |         120 |       123 |  42_3584578854011152015 |       0.022 |        0.003 |         0 | 3584578854011152015 |
|          520 |                    0 |          0 | 317_318_1 |      117 |           0 |        550 |                     0 |         317 |       318 | 117_3584578854011152015 |       0.014 |        0.002 |         0 | 3584578854011152015 |
|          523 |                    0 |          0 | 316_319_1 |      116 |           0 |        550 |                     0 |         316 |       319 | 116_3584578854011152015 |       0.023 |        0.003 |         0 | 3584578854011152015 |
|          526 |                    0 |          0 | 114_116_1 |       29 |           0 |        550 |                     0 |         114 |       116 |  29_3584578854011152015 |       0.059 |        0.005 |         0 | 3584578854011152015 |
|          527 |                    0 |          0 | 119_120_2 |       41 |           0 |        550 |                     0 |         119 |       120 |  41_3584578854011152015 |       0.04  |        0.005 |         0 | 3584578854011152015 |
|          531 |                    0 |          0 | 315_321_2 |      112 |           0 |        550 |                     0 |         315 |       321 | 112_3584578854011152015 |       0.049 |        0.006 |         0 | 3584578854011152015 |
|          532 |                    0 |          0 | 309_311_1 |       99 |           0 |        550 |                     0 |         309 |       311 |  99_3584578854011152015 |       0.084 |        0.002 |         0 | 3584578854011152015 |
|          533 |                    0 |          0 | 312_323_1 |      106 |           0 |        550 |                     0 |         312 |       323 | 106_3584578854011152015 |       0.097 |        0.012 |         0 | 3584578854011152015 |


Table: cim_dim_node
|   Row_Number | Hub   |   Latitude |   Load_Participation_Factor |   Longitude |   Node |   NodeId |    ObjectID_CombinedID | Region   |   Voltage |   Zone |          CombinedId |
|-------------:|:------|-----------:|----------------------------:|------------:|-------:|---------:|-----------------------:|:---------|----------:|-------:|--------------------:|
|         1058 |       |    45.1115 |                           0 |    -96.1127 |    221 |       45 | 45_1163433827361148046 | R2       |       230 |     22 | 1163433827361148046 |
|         1063 |       |    41.8256 |                           0 |   -103.388  |    122 |       22 | 22_1163433827361148046 | R1       |       230 |     12 | 1163433827361148046 |
|         1065 |       |    44.9172 |                           0 |    -98.3187 |    217 |       41 | 41_1163433827361148046 | R2       |       230 |     22 | 1163433827361148046 |
|         1068 |       |    36.787  |                           0 |    -98.3271 |    321 |       69 | 69_1163433827361148046 | R3       |       230 |     32 | 1163433827361148046 |
|         1073 |       |    41.8274 |                           0 |    -95.7276 |    117 |       17 | 17_1163433827361148046 | R1       |       230 |     12 | 1163433827361148046 |
|         1074 |       |    36.7314 |                           0 |   -101.196  |    323 |       71 | 71_1163433827361148046 | R3       |       230 |     32 | 1163433827361148046 |
|         1077 |       |    38.7841 |                           0 |    -97.4872 |    124 |       24 | 24_1163433827361148046 | R1       |       230 |     12 | 1163433827361148046 |
|         1079 |       |    35.7112 |                           0 |   -101.241  |    317 |       65 | 65_1163433827361148046 | R3       |       230 |     32 | 1163433827361148046 |
|         1080 |       |    34.7076 |                           0 |    -98.8676 |    311 |       59 | 59_1163433827361148046 | R3       |       230 |     31 | 1163433827361148046 |
|         1085 |       |    42.0056 |                           0 |    -93.7149 |    112 |       12 | 12_1163433827361148046 | R1       |       230 |     11 | 1163433827361148046 |


Table: cim_dim_region
|   Row_Number |   ObjectID_CombinedID | Region   |   RegionId |          CombinedId |
|-------------:|----------------------:|:---------|-----------:|--------------------:|
|           51 | 1_1163433827361148046 | R1       |          1 | 1163433827361148046 |
|           52 | 2_1163433827361148046 | R2       |          2 | 1163433827361148046 |
|           53 | 3_1163433827361148046 | R3       |          3 | 1163433827361148046 |
|           16 | 1_3584578854011152015 | R1       |          1 | 3584578854011152015 |
|           17 | 2_3584578854011152015 | R2       |          2 | 3584578854011152015 |
|           18 | 3_3584578854011152015 | R3       |          3 | 3584578854011152015 |
|           48 | 1_6282583166545062256 | R1       |          1 | 6282583166545062256 |
|           49 | 2_6282583166545062256 | R2       |          2 | 6282583166545062256 |
|           50 | 3_6282583166545062256 | R3       |          3 | 6282583166545062256 |


Table: cim_fact_battery
|   Row_Number |   BatteryId |   Build_Cost |   Capacity |   Charge_Efficiency |   DateId |   Discharge_Efficiency |   Generation |   Generation_Built |   Generation_Cost |   Generation_Retired |   Installed_Capacity |     Load |   Load_Cost |   Max_Power |   Max_Units_Built |   Max_Units_Retired |   Max_Units_Retired_in_Year |   Net_Generation |   Net_Generation_Built |   Net_New_Capacity |   Net_Profit |   ObjectID_CombinedID |   PhaseId |   Retirement_Cost | SampleName   |   Total_Cost |   Units |   Units_Built |   Units_Retired |          CombinedId |
|-------------:|------------:|-------------:|-----------:|--------------------:|---------:|-----------------------:|-------------:|-------------------:|------------------:|---------------------:|---------------------:|---------:|------------:|------------:|------------------:|--------------------:|----------------------------:|-----------------:|-----------------------:|-------------------:|-------------:|----------------------:|----------:|------------------:|:-------------|-------------:|--------:|--------------:|----------------:|--------------------:|
|          481 |           3 |            0 |          0 |                   0 |     4763 |                      0 |      88.5288 |                  0 |                 0 |                    0 |                   50 | 140.79   |           0 |           0 |                 0 |                   0 |                           0 |         -52.261  |                      0 |                  0 |     10668.6  | 3_3584578854011152015 |         1 |                 0 | Mean         |            0 |       0 |             0 |               0 | 3584578854011152015 |
|          482 |           3 |            0 |          0 |                   0 |     1100 |                      0 |      64.051  |                  0 |                 0 |                    0 |                   50 | 101.668  |           0 |           0 |                 0 |                   0 |                           0 |         -37.6173 |                      0 |                  0 |      8104.11 | 3_3584578854011152015 |         1 |                 0 | Mean         |            0 |       0 |             0 |               0 | 3584578854011152015 |
|          483 |           2 |            0 |          0 |                   0 |     4763 |                      0 |      67.5378 |                  0 |                 0 |                    0 |                   50 | 107.471  |           0 |           0 |                 0 |                   0 |                           0 |         -39.9329 |                      0 |                  0 |      5978.83 | 2_3584578854011152015 |         1 |                 0 | Mean         |            0 |       0 |             0 |               0 | 3584578854011152015 |
|          484 |           2 |            0 |          0 |                   0 |      734 |                      0 |      54.1237 |                  0 |                 0 |                    0 |                   50 |  85.9107 |           0 |           0 |                 0 |                   0 |                           0 |         -31.7869 |                      0 |                  0 |      1192.11 | 2_3584578854011152015 |         1 |                 0 | Mean         |            0 |       0 |             0 |               0 | 3584578854011152015 |
|          488 |           5 |            0 |          0 |                   0 |     3664 |                      0 |      37.5763 |                  0 |                 0 |                    0 |                   50 |  59.645  |           0 |           0 |                 0 |                   0 |                           0 |         -22.0686 |                      0 |                  0 |     10909    | 5_3584578854011152015 |         1 |                 0 | Mean         |            0 |       0 |             0 |               0 | 3584578854011152015 |
|          490 |           1 |            0 |          0 |                   0 |     4030 |                      0 |      66.9452 |                  0 |                 0 |                    0 |                   50 | 106.262  |           0 |           0 |                 0 |                   0 |                           0 |         -39.317  |                      0 |                  0 |     13334.5  | 1_3584578854011152015 |         1 |                 0 | Mean         |            0 |       0 |             0 |               0 | 3584578854011152015 |
|          493 |           1 |            0 |          0 |                   0 |     2932 |                      0 |      44.0984 |                  0 |                 0 |                    0 |                   50 |  69.9975 |           0 |           0 |                 0 |                   0 |                           0 |         -25.8991 |                      0 |                  0 |     11233.4  | 1_3584578854011152015 |         1 |                 0 | Mean         |            0 |       0 |             0 |               0 | 3584578854011152015 |
|          494 |           5 |            0 |          0 |                   0 |        2 |                      0 |      64.3472 |                  0 |                 0 |                    0 |                   50 | 102.067  |           0 |           0 |                 0 |                   0 |                           0 |         -37.7198 |                      0 |                  0 |      1176.41 | 5_3584578854011152015 |         1 |                 0 | Mean         |            0 |       0 |             0 |               0 | 3584578854011152015 |
|          495 |           3 |            0 |          0 |                   0 |     4030 |                      0 |      66.2123 |                  0 |                 0 |                    0 |                   50 | 105.099  |           0 |           0 |                 0 |                   0 |                           0 |         -38.8866 |                      0 |                  0 |     13909.2  | 3_3584578854011152015 |         1 |                 0 | Mean         |            0 |       0 |             0 |               0 | 3584578854011152015 |
|          497 |           1 |            0 |          0 |                   0 |     1467 |                      0 |      51.6217 |                  0 |                 0 |                    0 |                   50 |  81.9392 |           0 |           0 |                 0 |                   0 |                           0 |         -30.3175 |                      0 |                  0 |      6637.64 | 1_3584578854011152015 |         1 |                 0 | Mean         |            0 |       0 |             0 |               0 | 3584578854011152015 |


Table: cim_fact_emission
|   Row_Number |   Abatement |   Abatement_Cost |   Cost |   DateId |   EmissionId |   Gross_Production |   ObjectID_CombinedID |   PhaseId |   Price |   Production |   Removal |   Removal_Cost | SampleName   |          CombinedId |
|-------------:|------------:|-----------------:|-------:|---------:|-------------:|-------------------:|----------------------:|----------:|--------:|-------------:|----------:|---------------:|:-------------|--------------------:|
|           76 |           0 |                0 | 360000 |     5129 |            1 |                  0 | 1_3584578854011152015 |         1 |       0 |  9e+06       |         0 |              0 | Mean         | 3584578854011152015 |
|           77 |           0 |                0 | 395764 |     3298 |            1 |                  0 | 1_3584578854011152015 |         1 |       0 |  9.8941e+06  |         0 |              0 | Mean         | 3584578854011152015 |
|           78 |           0 |                0 | 400000 |     3664 |            1 |                  0 | 1_3584578854011152015 |         1 |       0 |  1e+07       |         0 |              0 | Mean         | 3584578854011152015 |
|           79 |           0 |                0 | 360000 |     4763 |            1 |                  0 | 1_3584578854011152015 |         1 |       0 |  9e+06       |         0 |              0 | Mean         | 3584578854011152015 |
|           80 |           0 |                0 | 345898 |     1100 |            1 |                  0 | 1_3584578854011152015 |         1 |       0 |  8.64744e+06 |         0 |              0 | Mean         | 3584578854011152015 |
|           81 |           0 |                0 | 328905 |      734 |            1 |                  0 | 1_3584578854011152015 |         1 |       0 |  8.22262e+06 |         0 |              0 | Mean         | 3584578854011152015 |
|           82 |           0 |                0 | 314951 |      368 |            1 |                  0 | 1_3584578854011152015 |         1 |       0 |  7.87378e+06 |         0 |              0 | Mean         | 3584578854011152015 |
|           83 |           0 |                0 | 362509 |     2932 |            1 |                  0 | 1_3584578854011152015 |         1 |       0 |  9.06272e+06 |         0 |              0 | Mean         | 3584578854011152015 |
|           84 |           0 |                0 | 361049 |     2565 |            1 |                  0 | 1_3584578854011152015 |         1 |       0 |  9.02623e+06 |         0 |              0 | Mean         | 3584578854011152015 |
|           85 |           0 |                0 | 338547 |     2199 |            1 |                  0 | 1_3584578854011152015 |         1 |       0 |  8.46368e+06 |         0 |              0 | Mean         | 3584578854011152015 |


Table: cim_fact_fuel
|   Row_Number |   Cost |   DateId |   FuelId |    ObjectID_CombinedID |   Offtake |   PhaseId |   Price | SampleName   |          CombinedId |
|-------------:|-------:|---------:|---------:|-----------------------:|----------:|----------:|--------:|:-------------|--------------------:|
|         9690 |      0 |     5129 |       10 | 10_6282583166545062256 |         0 |         1 |       0 | Mean         | 6282583166545062256 |
|         9693 |      0 |     2932 |        2 |  2_6282583166545062256 |         0 |         1 |       0 | Mean         | 6282583166545062256 |
|         9694 |      0 |      368 |       11 | 11_6282583166545062256 |         0 |         1 |       0 | Mean         | 6282583166545062256 |
|         9697 |      0 |     3664 |        2 |  2_6282583166545062256 |         0 |         1 |       0 | Mean         | 6282583166545062256 |
|         9700 |      0 |     4397 |       10 | 10_6282583166545062256 |         0 |         1 |       0 | Mean         | 6282583166545062256 |
|         9702 |      0 |     2932 |        8 |  8_6282583166545062256 |         0 |         1 |       0 | Mean         | 6282583166545062256 |
|         9703 |      0 |        2 |        8 |  8_6282583166545062256 |         0 |         1 |       0 | Mean         | 6282583166545062256 |
|         9704 |      0 |     4763 |       11 | 11_6282583166545062256 |         0 |         1 |       0 | Mean         | 6282583166545062256 |
|         9705 |      0 |     2565 |        2 |  2_6282583166545062256 |         0 |         1 |       0 | Mean         | 6282583166545062256 |
|         9706 |      0 |     2199 |        8 |  8_6282583166545062256 |         0 |         1 |       0 | Mean         | 6282583166545062256 |


Table: cim_fact_generator
|   Row_Number |   Bid_Price |   Bid_Quantity |   Build_Cost |   Capacity_Built |   Capacity_Retired |   DateId |   Emissions_Cost |   Fuel_Cost |   Fuel_Offtake |   Generation |   Generation_Cost |   GeneratorId |   Hours_at_Minimum |   Hours_Curtailed |   Hours_Down |   Hours_Up |   Installed_Capacity |   Limits_Hitting |   Net_New_Capacity |   Net_Profit |     ObjectID_CombinedID |   Operating_Hours |   PhaseId |   Price_Received |   Rating |   Regulation_Lower_Reserve |   Regulation_Raise_Reserve |   Retirement_Cost | SampleName   |   SRMC |   Total_Cost |   Total_Generation_Cost |   Total_System_Cost |   Units |   Units_Built |   Units_Retired |          CombinedId |
|-------------:|------------:|---------------:|-------------:|-----------------:|-------------------:|---------:|-----------------:|------------:|---------------:|-------------:|------------------:|--------------:|-------------------:|------------------:|-------------:|-----------:|---------------------:|-----------------:|-------------------:|-------------:|------------------------:|------------------:|----------:|-----------------:|---------:|---------------------------:|---------------------------:|------------------:|:-------------|-------:|-------------:|------------------------:|--------------------:|--------:|--------------:|----------------:|--------------------:|
|        65357 |           0 |              0 |            0 |                0 |                  0 |      734 |                0 |           0 |              0 |          438 |                 0 |            71 |                  0 |                 0 |            0 |          0 |                   50 |                1 |                  0 |      21480.8 |  71_6282583166545062256 |                 0 |         1 |                0 |        0 |                          0 |                          0 |                 0 | Mean         |      0 |            0 |                       0 |                   0 |       0 |             0 |               0 | 6282583166545062256 |
|        65149 |           0 |              0 |            0 |                0 |                  0 |      368 |                0 |           0 |              0 |          438 |                 0 |            73 |                  0 |                 0 |            0 |          0 |                   50 |                1 |                  0 |      23259   |  73_6282583166545062256 |                 0 |         1 |                0 |        0 |                          0 |                          0 |                 0 | Mean         |      0 |            0 |                       0 |                   0 |       0 |             0 |               0 | 6282583166545062256 |
|        66441 |           0 |              0 |            0 |                0 |                  0 |     3298 |                0 |           0 |              0 |          438 |                 0 |           156 |                  0 |                 0 |            0 |          0 |                   50 |                1 |                  0 |      33264.4 | 156_6282583166545062256 |                 0 |         1 |                0 |        0 |                          0 |                          0 |                 0 | Mean         |      0 |            0 |                       0 |                   0 |       0 |             0 |               0 | 6282583166545062256 |
|        66732 |           0 |              0 |            0 |                0 |                  0 |      368 |                0 |           0 |              0 |          438 |                 0 |           158 |                  0 |                 0 |            0 |          0 |                   50 |                1 |                  0 |      20174.2 | 158_6282583166545062256 |                 0 |         1 |                0 |        0 |                          0 |                          0 |                 0 | Mean         |      0 |            0 |                       0 |                   0 |       0 |             0 |               0 | 6282583166545062256 |
|        67069 |           0 |              0 |            0 |                0 |                  0 |     5129 |                0 |           0 |              0 |          438 |                 0 |            71 |                  0 |                 0 |            0 |          0 |                   50 |                1 |                  0 |      33474.4 |  71_6282583166545062256 |                 0 |         1 |                0 |        0 |                          0 |                          0 |                 0 | Mean         |      0 |            0 |                       0 |                   0 |       0 |             0 |               0 | 6282583166545062256 |
|        67073 |           0 |              0 |            0 |                0 |                  0 |      734 |                0 |           0 |              0 |          438 |                 0 |            59 |                  0 |                 0 |            0 |          0 |                   50 |                1 |                  0 |      19970.2 |  59_6282583166545062256 |                 0 |         1 |                0 |        0 |                          0 |                          0 |                 0 | Mean         |      0 |            0 |                       0 |                   0 |       0 |             0 |               0 | 6282583166545062256 |
|        67080 |           0 |              0 |            0 |                0 |                  0 |     3298 |                0 |           0 |              0 |          438 |                 0 |           157 |                  0 |                 0 |            0 |          0 |                   50 |                1 |                  0 |      33264.4 | 157_6282583166545062256 |                 0 |         1 |                0 |        0 |                          0 |                          0 |                 0 | Mean         |      0 |            0 |                       0 |                   0 |       0 |             0 |               0 | 6282583166545062256 |
|        67098 |           0 |              0 |            0 |                0 |                  0 |     2932 |                0 |           0 |              0 |          438 |                 0 |           156 |                  0 |                 0 |            0 |          0 |                   50 |                1 |                  0 |      26474.5 | 156_6282583166545062256 |                 0 |         1 |                0 |        0 |                          0 |                          0 |                 0 | Mean         |      0 |            0 |                       0 |                   0 |       0 |             0 |               0 | 6282583166545062256 |
|        66783 |           0 |              0 |            0 |                0 |                  0 |     3664 |                0 |           0 |              0 |          438 |                 0 |            73 |                  0 |                 0 |            0 |          0 |                   50 |                1 |                  0 |      35388.3 |  73_6282583166545062256 |                 0 |         1 |                0 |        0 |                          0 |                          0 |                 0 | Mean         |      0 |            0 |                       0 |                   0 |       0 |             0 |               0 | 6282583166545062256 |
|        66613 |           0 |              0 |            0 |                0 |                  0 |      734 |                0 |           0 |              0 |          438 |                 0 |           157 |                  0 |                 0 |            0 |          0 |                   50 |                1 |                  0 |      18981.9 | 157_6282583166545062256 |                 0 |         1 |                0 |        0 |                          0 |                          0 |                 0 | Mean         |      0 |            0 |                       0 |                   0 |       0 |             0 |               0 | 6282583166545062256 |


Table: cim_fact_line
|   Row_Number |   Build_Cost |   DateId |   Flow |   Hours_Congested |   LineId |   Max_Rating |     ObjectID_CombinedID |   PhaseId |   Rating |   Retirement_Cost | SampleName   |   Shadow_Price |   Units |   Units_Built |   Units_Retired |          CombinedId |
|-------------:|-------------:|---------:|-------:|------------------:|---------:|-------------:|------------------------:|----------:|---------:|------------------:|:-------------|---------------:|--------:|--------------:|----------------:|--------------------:|
|         1652 |            0 |     4763 |      0 |                 0 |       28 |            0 |  28_3584578854011152015 |         1 |        0 |                 0 | Mean         |              0 |       0 |             0 |               0 | 3584578854011152015 |
|         1656 |            0 |      734 |      0 |                 0 |      103 |            0 | 103_3584578854011152015 |         1 |        0 |                 0 | Mean         |              0 |       0 |             0 |               0 | 3584578854011152015 |
|         1657 |            0 |      734 |      0 |                 0 |       74 |            0 |  74_3584578854011152015 |         1 |        0 |                 0 | Mean         |              0 |       0 |             0 |               0 | 3584578854011152015 |
|         1659 |            0 |     4397 |      0 |                 0 |       28 |            0 |  28_3584578854011152015 |         1 |        0 |                 0 | Mean         |              0 |       0 |             0 |               0 | 3584578854011152015 |
|         1662 |            0 |     2565 |      0 |                 0 |        4 |            0 |   4_3584578854011152015 |         1 |        0 |                 0 | Mean         |              0 |       0 |             0 |               0 | 3584578854011152015 |
|         1663 |            0 |     2932 |      0 |                 0 |       23 |            0 |  23_3584578854011152015 |         1 |        0 |                 0 | Mean         |              0 |       0 |             0 |               0 | 3584578854011152015 |
|         1664 |            0 |     5129 |      0 |                 0 |      105 |            0 | 105_3584578854011152015 |         1 |        0 |                 0 | Mean         |              0 |       0 |             0 |               0 | 3584578854011152015 |
|         1666 |            0 |     4397 |      0 |                 0 |       65 |            0 |  65_3584578854011152015 |         1 |        0 |                 0 | Mean         |              0 |       0 |             0 |               0 | 3584578854011152015 |
|         1671 |            0 |     2199 |      0 |                 0 |       23 |            0 |  23_3584578854011152015 |         1 |        0 |                 0 | Mean         |              0 |       0 |             0 |               0 | 3584578854011152015 |
|         1673 |            0 |     2565 |      0 |                 0 |       67 |            0 |  67_3584578854011152015 |         1 |        0 |                 0 | Mean         |              0 |       0 |             0 |               0 | 3584578854011152015 |


Table: cim_fact_node
|   Row_Number |   DateId |   DSP_Bid_Price |   DSP_Bid_Quantity |   Load |   Load_Served |   NodeId |    ObjectID_CombinedID |   PhaseId |   Phase_Angle |   Price | SampleName   |   Unserved_Energy |          CombinedId |
|-------------:|---------:|----------------:|-------------------:|-------:|--------------:|---------:|-----------------------:|----------:|--------------:|--------:|:-------------|------------------:|--------------------:|
|        62477 |      734 |               0 |                  0 |      0 |             0 |       68 | 68_6282583166545062256 |         0 |             1 | 41.2825 | Mean         |                 0 | 6282583166545062256 |
|        62478 |     2565 |               0 |                  0 |      0 |             0 |       54 | 54_6282583166545062256 |         0 |             1 | 53.5482 | Mean         |                 0 | 6282583166545062256 |
|        62479 |        2 |               0 |                  0 |      0 |             0 |       16 | 16_6282583166545062256 |         0 |             1 | 30.2235 | Mean         |                 0 | 6282583166545062256 |
|        62480 |     3298 |               0 |                  0 |      0 |             0 |       18 | 18_6282583166545062256 |         0 |             1 | 32.3397 | Mean         |                 0 | 6282583166545062256 |
|        62481 |     4030 |               0 |                  0 |      0 |             0 |       52 | 52_6282583166545062256 |         0 |             1 | 78.9514 | Mean         |                 0 | 6282583166545062256 |
|        62482 |     1100 |               0 |                  0 |      0 |             0 |       44 | 44_6282583166545062256 |         0 |             1 | 69.0453 | Mean         |                 0 | 6282583166545062256 |
|        62483 |      368 |               0 |                  0 |      0 |             0 |       13 | 13_6282583166545062256 |         0 |             1 | 49.4501 | Mean         |                 0 | 6282583166545062256 |
|        62484 |     1100 |               0 |                  0 |      0 |             0 |       19 | 19_6282583166545062256 |         0 |             1 | 61.481  | Mean         |                 0 | 6282583166545062256 |
|        62485 |     1100 |               0 |                  0 |      0 |             0 |       34 | 34_6282583166545062256 |         0 |             1 | 69.1983 | Mean         |                 0 | 6282583166545062256 |
|        62486 |     1467 |               0 |                  0 |      0 |             0 |       56 | 56_6282583166545062256 |         0 |             1 | 57.6754 | Mean         |                 0 | 6282583166545062256 |


Table: cim_fact_region
|   Row_Number |   Capacity_Reserves |   DateId |   Dump_Energy |   Exports |   Generation_Capacity |   Generation_Cost |   Generator_Retirement_Cost |   Imports |    Load |   Load_Served |   Max_Capacity_Reserves |   Min_Capacity_Reserves |   ObjectID_CombinedID |   Peak_Load |   PhaseId |   Planning_Peak_Load |    Price |   Price_of_Dump_Energy |   RegionId | SampleName   |       Total_Cost |   Unserved_Energy |   Wheeling_Charge |          CombinedId |
|-------------:|--------------------:|---------:|--------------:|----------:|----------------------:|------------------:|----------------------------:|----------:|--------:|--------------:|------------------------:|------------------------:|----------------------:|------------:|----------:|---------------------:|---------:|-----------------------:|-----------:|:-------------|-----------------:|------------------:|------------------:|--------------------:|
|          226 |             4250.12 |     3298 |             0 |         0 |               8550.12 |                 0 |                           0 |         0 | 18640.7 |       18640.6 |                       0 |                       0 | 1_3584578854011152015 |           0 |         1 |              18640.7 |  66.1126 |                      0 |          1 | Mean         | 759832           |        0.130773   |                 0 | 3584578854011152015 |
|          228 |            -1954.7  |     1833 |             0 |         0 |               4223.3  |                 0 |                           0 |         0 | 24532.4 |       24532.1 |                       0 |                       0 | 2_3584578854011152015 |           0 |         1 |              24532.4 |  74.7528 |                      0 |          2 | Mean         | 616376           |        0.339389   |                 0 | 3584578854011152015 |
|          229 |            -1951.7  |     1467 |             0 |         0 |               4123.3  |                 0 |                           0 |         0 | 24029.4 |       24029.1 |                       0 |                       0 | 2_3584578854011152015 |           0 |         1 |              24029.4 |  78.0469 |                      0 |          2 | Mean         | 515734           |        0.310315   |                 0 | 3584578854011152015 |
|          230 |              682.3  |     5129 |             0 |         0 |               8768.3  |                 0 |                           0 |         0 | 29932.6 |       29932.6 |                       0 |                       0 | 2_3584578854011152015 |           0 |         1 |              29932.6 | 109.063  |                      0 |          2 | Mean         | 497628           |        0.00560659 |                 0 | 3584578854011152015 |
|          232 |            -1750.7  |      734 |             0 |         0 |               4123.3  |                 0 |                           0 |         0 | 23183.9 |       23183.9 |                       0 |                       0 | 2_3584578854011152015 |           0 |         1 |              23183.9 |  49.6168 |                      0 |          2 | Mean         | 515198           |        0          |                 0 | 3584578854011152015 |
|          233 |              737.3  |     4763 |             0 |         0 |               8768.3  |                 0 |                           0 |         0 | 29451.4 |       29451.4 |                       0 |                       0 | 2_3584578854011152015 |           0 |         1 |              29451.4 | 100.196  |                      0 |          2 | Mean         |      2.94597e+06 |        0          |                 0 | 3584578854011152015 |
|          234 |             2856.9  |     1100 |             0 |         0 |               7913.9  |                 0 |                           0 |         0 | 23037.7 |       23037.7 |                       0 |                       0 | 3_3584578854011152015 |           0 |         1 |              23037.7 |  49.9745 |                      0 |          3 | Mean         | 900117           |        0          |                 0 | 3584578854011152015 |
|          235 |             4074.12 |     1833 |             0 |         0 |               8240.12 |                 0 |                           0 |         0 | 17256.4 |       17256.2 |                       0 |                       0 | 1_3584578854011152015 |           0 |         1 |              17256.4 |  51.6219 |                      0 |          1 | Mean         | 414032           |        0.187342   |                 0 | 3584578854011152015 |
|          236 |             3808.12 |     1467 |             0 |         0 |               8240.12 |                 0 |                           0 |         0 | 20014.8 |       20014.7 |                       0 |                       0 | 1_3584578854011152015 |           0 |         1 |              20014.8 |  56.588  |                      0 |          1 | Mean         | 433093           |        0.159524   |                 0 | 3584578854011152015 |
|          237 |            -1461.7  |     3298 |             0 |         0 |               5748.3  |                 0 |                           0 |         0 | 26534.2 |       26531.5 |                       0 |                       0 | 2_3584578854011152015 |           0 |         1 |              26534.2 | 109.015  |                      0 |          2 | Mean         |      1.16206e+06 |        2.65728    |                 0 | 3584578854011152015 |

 


tables: name: cim_dim_battery
data: cim_dim_battery.csv
name: cim_dim_combined_id_table
data: cim_dim_combined_id_table.csv
name: cim_dim_date
data: cim_dim_date.csv
name: cim_dim_emission
data: cim_dim_emission.csv
name: cim_dim_fuel
data: cim_dim_fuel.csv
name: cim_dim_generator
data: cim_dim_generator.csv
name: cim_dim_line
data: cim_dim_line.csv
name: cim_dim_node
data: cim_dim_node.csv
name: cim_dim_region
data: cim_dim_region.csv
name: cim_fact_battery
data: cim_fact_battery.csv
name: cim_fact_emission
data: cim_fact_emission.csv
name: cim_fact_fuel
data: cim_fact_fuel.csv
name: cim_fact_generator
data: cim_fact_generator.csv
name: cim_fact_line
data: cim_fact_line.csv
name: cim_fact_node
data: cim_fact_node.csv
name: cim_fact_region
data: cim_fact_region.csv
label: cim_fact_line
DateId
cim_dim_date
DateId
cim_fact_region
DateId
cim_dim_date
DateId
cim_fact_generator
DateId
cim_dim_date
DateId
cim_fact_battery
DateId
cim_dim_date
DateId
cim_fact_fuel
DateId
cim_dim_date
DateId
cim_dim_battery
CombinedId
cim_dim_combined_id_table
CombinedId
cim_dim_region
CombinedId
cim_dim_combined_id_table
CombinedId
cim_dim_node
CombinedId
cim_dim_combined_id_table
CombinedId
cim_dim_line
CombinedId
cim_dim_combined_id_table
CombinedId
cim_dim_generator
CombinedId
cim_dim_combined_id_table
CombinedId
cim_fact_node
CombinedId
cim_dim_combined_id_table
CombinedId
cim_fact_region
CombinedId
cim_dim_combined_id_table
CombinedId
cim_fact_fuel
CombinedId
cim_dim_combined_id_table
CombinedId
cim_dim_fuel
CombinedId
cim_dim_combined_id_table
CombinedId
cim_fact_generator
ObjectID_CombinedID
cim_dim_generator
ObjectID_CombinedID
cim_fact_battery
ObjectID_CombinedID
cim_dim_battery
ObjectID_CombinedID
cim_fact_emission
DateId
cim_dim_date
DateId
cim_fact_emission
ObjectID_CombinedID
cim_dim_emission
ObjectID_CombinedID
cim_dim_emission
CombinedId
cim_dim_combined_id_table
CombinedId
cim_fact_line
ObjectID_CombinedID
cim_dim_line
ObjectID_CombinedID
output: {
    "joins": [
        {
            "from_table": "cim_fact_line",
            "from_column": "DateId",
            "to_table": "cim_dim_date",
            "to_column": "DateId"
        },
        {
            "from_table": "cim_fact_region",
            "from_column": "DateId",
            "to_table": "cim_dim_date",
            "to_column": "DateId"
        },
        {
            "from_table": "cim_fact_generator",
            "from_column": "DateId",
            "to_table": "cim_dim_date",
            "to_column": "DateId"
        },
        {
            "from_table": "cim_fact_battery",
            "from_column": "DateId",
            "to_table": "cim_dim_date",
            "to_column": "DateId"
        },
        {
            "from_table": "cim_fact_fuel",
            "from_column": "DateId",
            "to_table": "cim_dim_date",
            "to_column": "DateId"
        },
        {
            "from_table": "cim_dim_battery",
            "from_column": "CombinedId",
            "to_table": "cim_dim_combined_id_table",
            "to_column": "CombinedId"
        },
        {
            "from_table": "cim_dim_region",
            "from_column": "CombinedId",
            "to_table": "cim_dim_combined_id_table",
            "to_column": "CombinedId"
        },
        {
            "from_table": "cim_dim_node",
            "from_column": "CombinedId",
            "to_table": "cim_dim_combined_id_table",
            "to_column": "CombinedId"
        },
        {
            "from_table": "cim_dim_line",
            "from_column": "CombinedId",
            "to_table": "cim_dim_combined_id_table",
            "to_column": "CombinedId"
        },
        {
            "from_table": "cim_dim_generator",
            "from_column": "CombinedId",
            "to_table": "cim_dim_combined_id_table",
            "to_column": "CombinedId"
        },
        {
            "from_table": "cim_fact_node",
            "from_column": "CombinedId",
            "to_table": "cim_dim_combined_id_table",
            "to_column": "CombinedId"
        },
        {
            "from_table": "cim_fact_region",
            "from_column": "CombinedId",
            "to_table": "cim_dim_combined_id_table",
            "to_column": "CombinedId"
        },
        {
            "from_table": "cim_fact_fuel",
            "from_column": "CombinedId",
            "to_table": "cim_dim_combined_id_table",
            "to_column": "CombinedId"
        },
        {
            "from_table": "cim_dim_fuel",
            "from_column": "CombinedId",
            "to_table": "cim_dim_combined_id_table",
            "to_column": "CombinedId"
        },
        {
            "from_table": "cim_fact_generator",
            "from_column": "ObjectID_CombinedID",
            "to_table": "cim_dim_generator",
            "to_column": "ObjectID_CombinedID"
        },
        {
            "from_table": "cim_fact_battery",
            "from_column": "ObjectID_CombinedID",
            "to_table": "cim_dim_battery",
            "to_column": "ObjectID_CombinedID"
        },
        {
            "from_table": "cim_fact_emission",
            "from_column": "DateId",
            "to_table": "cim_dim_date",
            "to_column": "DateId"
        },
        {
            "from_table": "cim_fact_emission",
            "from_column": "ObjectID_CombinedID",
            "to_table": "cim_dim_emission",
            "to_column": "ObjectID_CombinedID"
        },
        {
            "from_table": "cim_dim_emission",
            "from_column": "CombinedId",
            "to_table": "cim_dim_combined_id_table",
            "to_column": "CombinedId"
        },
        {
            "from_table": "cim_fact_line",
            "from_column": "ObjectID_CombinedID",
            "to_table": "cim_dim_line",
            "to_column": "ObjectID_CombinedID"
        }
    ]
}