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: Customers Extended
| File As                   | Contact Name             |   ID | Company   | Last Name        | First Name    | E-mail Address   | Job Title                 | Business Phone   | Home Phone   | Mobile Phone   | Fax Number    | Address         | City          | State/Province   |   ZIP/Postal Code | Country/Region   | Web Page   | Notes   |
|:--------------------------|:-------------------------|-----:|:----------|:-----------------|:--------------|:-----------------|:--------------------------|:-----------------|:-------------|:---------------|:--------------|:----------------|:--------------|:-----------------|------------------:|:-----------------|:-----------|:--------|
| Andersen, Elizabeth       | Elizabeth Andersen       |    8 | Company H | Andersen         | Elizabeth     |                  | Purchasing Representative | (123)555-0100    |              |                | (123)555-0101 | 123 8th Street  | Portland      | OR               |             99999 | USA              |            |         |
| Autier Miconi, Catherine  | Catherine Autier Miconi  |   18 | Company R | Autier Miconi    | Catherine     |                  | Purchasing Representative | (123)555-0100    |              |                | (123)555-0101 | 456 18th Street | Boston        | MA               |             99999 | USA              |            |         |
| Axen, Thomas              | Thomas Axen              |    3 | Company C | Axen             | Thomas        |                  | Purchasing Representative | (123)555-0100    |              |                | (123)555-0101 | 123 3rd Street  | Los Angelas   | CA               |             99999 | USA              |            |         |
| Bagel, Jean Philippe      | Jean Philippe Bagel      |   17 | Company Q | Bagel            | Jean Philippe |                  | Owner                     | (123)555-0100    |              |                | (123)555-0101 | 456 17th Street | Seattle       | WA               |             99999 | USA              |            |         |
| Bedecs, Anna              | Anna Bedecs              |    1 | Company A | Bedecs           | Anna          |                  | Owner                     | (123)555-0100    |              |                | (123)555-0101 | 123 1st Street  | Seattle       | WA               |             99999 | USA              |            |         |
| Edwards, John             | John Edwards             |   12 | Company L | Edwards          | John          |                  | Purchasing Manager        | (123)555-0100    |              |                | (123)555-0101 | 123 12th Street | Las Vegas     | NV               |             99999 | USA              |            |         |
| Eggerer, Alexander        | Alexander Eggerer        |   19 | Company S | Eggerer          | Alexander     |                  | Accounting Assistant      | (123)555-0100    |              |                | (123)555-0101 | 789 19th Street | Los Angelas   | CA               |             99999 | USA              |            |         |
| Entin, Michael            | Michael Entin            |   23 | Company W | Entin            | Michael       |                  | Purchasing Manager        | (123)555-0100    |              |                | (123)555-0101 | 789 23th Street | Portland      | OR               |             99999 | USA              |            |         |
| Goldschmidt, Daniel       | Daniel Goldschmidt       |   16 | Company P | Goldschmidt      | Daniel        |                  | Purchasing Representative | (123)555-0100    |              |                | (123)555-0101 | 456 16th Street | San Francisco | CA               |             99999 | USA              |            |         |
| Gratacos Solsona, Antonio | Antonio Gratacos Solsona |    2 | Company B | Gratacos Solsona | Antonio       |                  | Owner                     | (123)555-0100    |              |                | (123)555-0101 | 123 2nd Street  | Boston        | MA               |             99999 | USA              |            |         |


Table: Customers
|   ID | Company   | Last Name        | First Name   | E-mail Address   | Job Title                 | Business Phone   | Home Phone   | Mobile Phone   | Fax Number    | Address         | City           | State/Province   |   ZIP/Postal Code | Country/Region   | Web Page   | Notes   |
|-----:|:----------|:-----------------|:-------------|:-----------------|:--------------------------|:-----------------|:-------------|:---------------|:--------------|:----------------|:---------------|:-----------------|------------------:|:-----------------|:-----------|:--------|
|    1 | Company A | Bedecs           | Anna         |                  | Owner                     | (123)555-0100    |              |                | (123)555-0101 | 123 1st Street  | Seattle        | WA               |             99999 | USA              |            |         |
|    2 | Company B | Gratacos Solsona | Antonio      |                  | Owner                     | (123)555-0100    |              |                | (123)555-0101 | 123 2nd Street  | Boston         | MA               |             99999 | USA              |            |         |
|    3 | Company C | Axen             | Thomas       |                  | Purchasing Representative | (123)555-0100    |              |                | (123)555-0101 | 123 3rd Street  | Los Angelas    | CA               |             99999 | USA              |            |         |
|    4 | Company D | Lee              | Christina    |                  | Purchasing Manager        | (123)555-0100    |              |                | (123)555-0101 | 123 4th Street  | New York       | NY               |             99999 | USA              |            |         |
|    5 | Company E | O’Donnell        | Martin       |                  | Owner                     | (123)555-0100    |              |                | (123)555-0101 | 123 5th Street  | Minneapolis    | MN               |             99999 | USA              |            |         |
|    6 | Company F | Pérez-Olaeta     | Francisco    |                  | Purchasing Manager        | (123)555-0100    |              |                | (123)555-0101 | 123 6th Street  | Milwaukee      | WI               |             99999 | USA              |            |         |
|    7 | Company G | Xie              | Ming-Yang    |                  | Owner                     | (123)555-0100    |              |                | (123)555-0101 | 123 7th Street  | Boise          | ID               |             99999 | USA              |            |         |
|    8 | Company H | Andersen         | Elizabeth    |                  | Purchasing Representative | (123)555-0100    |              |                | (123)555-0101 | 123 8th Street  | Portland       | OR               |             99999 | USA              |            |         |
|    9 | Company I | Mortensen        | Sven         |                  | Purchasing Manager        | (123)555-0100    |              |                | (123)555-0101 | 123 9th Street  | Salt Lake City | UT               |             99999 | USA              |            |         |
|   10 | Company J | Wacker           | Roland       |                  | Purchasing Manager        | (123)555-0100    |              |                | (123)555-0101 | 123 10th Street | Chicago        | IL               |             99999 | USA              |            |         |


Table: DateTable
| Date                    |   Year |   Quarter | QuarterName   |   Month | MonthName   |   Week | WeekName   |
|:------------------------|-------:|----------:|:--------------|--------:|:------------|-------:|:-----------|
| 2006-01-15 00:00:00.000 |   2006 |         1 | Qtr 1         |       1 | Jan         |      3 | Week 3     |
| 2006-01-16 00:00:00.000 |   2006 |         1 | Qtr 1         |       1 | Jan         |      3 | Week 3     |
| 2006-01-17 00:00:00.000 |   2006 |         1 | Qtr 1         |       1 | Jan         |      3 | Week 3     |
| 2006-01-18 00:00:00.000 |   2006 |         1 | Qtr 1         |       1 | Jan         |      3 | Week 3     |
| 2006-01-19 00:00:00.000 |   2006 |         1 | Qtr 1         |       1 | Jan         |      3 | Week 3     |
| 2006-01-20 00:00:00.000 |   2006 |         1 | Qtr 1         |       1 | Jan         |      3 | Week 3     |
| 2006-01-21 00:00:00.000 |   2006 |         1 | Qtr 1         |       1 | Jan         |      3 | Week 3     |
| 2006-01-22 00:00:00.000 |   2006 |         1 | Qtr 1         |       1 | Jan         |      4 | Week 4     |
| 2006-01-23 00:00:00.000 |   2006 |         1 | Qtr 1         |       1 | Jan         |      4 | Week 4     |
| 2006-01-24 00:00:00.000 |   2006 |         1 | Qtr 1         |       1 | Jan         |      4 | Week 4     |


Table: Employee Privileges
|   Employee ID |   Privilege ID |
|--------------:|---------------:|
|             2 |              2 |


Table: Employees Extended
| File As              | Employee Name       |   ID | Company           | Last Name      | First Name   | E-mail Address               | Job Title             | Business Phone   | Home Phone    | Mobile Phone   | Fax Number    | Address        | City     | State/Province   |   ZIP/Postal Code | Country/Region   | Web Page                                                  | Notes                                                                                                                   |
|:---------------------|:--------------------|-----:|:------------------|:---------------|:-------------|:-----------------------------|:----------------------|:-----------------|:--------------|:---------------|:--------------|:---------------|:---------|:-----------------|------------------:|:-----------------|:----------------------------------------------------------|:------------------------------------------------------------------------------------------------------------------------|
| Cencini, Andrew      | Andrew Cencini      |    2 | Northwind Traders | Cencini        | Andrew       | andrew@northwindtraders.com  | Vice President, Sales | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 2nd Avenue | Bellevue | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales. |
| Freehafer, Nancy     | Nancy Freehafer     |    1 | Northwind Traders | Freehafer      | Nancy        | nancy@northwindtraders.com   | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 1st Avenue | Seattle  | WA               |             99999 | USA              | #http://northwindtraders.com#                             |                                                                                                                         |
| Giussani, Laura      | Laura Giussani      |    8 | Northwind Traders | Giussani       | Laura        | laura@northwindtraders.com   | Sales Coordinator     | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 8th Avenue | Redmond  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Reads and writes French.                                                                                                |
| Hellung-Larsen, Anne | Anne Hellung-Larsen |    9 | Northwind Traders | Hellung-Larsen | Anne         | anne@northwindtraders.com    | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 9th Avenue | Seattle  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Fluent in French and German.                                                                                            |
| Kotas, Jan           | Jan Kotas           |    3 | Northwind Traders | Kotas          | Jan          | jan@northwindtraders.com     | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 3rd Avenue | Redmond  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Was hired as a sales associate and was promoted to sales representative.                                                |
| Neipper, Michael     | Michael Neipper     |    6 | Northwind Traders | Neipper        | Michael      | michael@northwindtraders.com | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 6th Avenue | Redmond  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Fluent in Japanese and can read and write French, Portuguese, and Spanish.                                              |
| Sergienko, Mariya    | Mariya Sergienko    |    4 | Northwind Traders | Sergienko      | Mariya       | mariya@northwindtraders.com  | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 4th Avenue | Kirkland | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# |                                                                                                                         |
| Thorpe, Steven       | Steven Thorpe       |    5 | Northwind Traders | Thorpe         | Steven       | steven@northwindtraders.com  | Sales Manager         | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 5th Avenue | Seattle  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Joined the company as a sales representative and was promoted to sales manager.  Fluent in French.                      |
| Zare, Robert         | Robert Zare         |    7 | Northwind Traders | Zare           | Robert       | robert@northwindtraders.com  | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 7th Avenue | Seattle  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# |                                                                                                                         |


Table: Employees
|   ID | Company           | Last Name      | First Name   | E-mail Address               | Job Title             | Business Phone   | Home Phone    | Mobile Phone   | Fax Number    | Address        | City     | State/Province   |   ZIP/Postal Code | Country/Region   | Web Page                                                  | Notes                                                                                                                   |
|-----:|:------------------|:---------------|:-------------|:-----------------------------|:----------------------|:-----------------|:--------------|:---------------|:--------------|:---------------|:---------|:-----------------|------------------:|:-----------------|:----------------------------------------------------------|:------------------------------------------------------------------------------------------------------------------------|
|    1 | Northwind Traders | Freehafer      | Nancy        | nancy@northwindtraders.com   | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 1st Avenue | Seattle  | WA               |             99999 | USA              | #http://northwindtraders.com#                             |                                                                                                                         |
|    2 | Northwind Traders | Cencini        | Andrew       | andrew@northwindtraders.com  | Vice President, Sales | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 2nd Avenue | Bellevue | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales. |
|    3 | Northwind Traders | Kotas          | Jan          | jan@northwindtraders.com     | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 3rd Avenue | Redmond  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Was hired as a sales associate and was promoted to sales representative.                                                |
|    4 | Northwind Traders | Sergienko      | Mariya       | mariya@northwindtraders.com  | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 4th Avenue | Kirkland | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# |                                                                                                                         |
|    5 | Northwind Traders | Thorpe         | Steven       | steven@northwindtraders.com  | Sales Manager         | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 5th Avenue | Seattle  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Joined the company as a sales representative and was promoted to sales manager.  Fluent in French.                      |
|    6 | Northwind Traders | Neipper        | Michael      | michael@northwindtraders.com | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 6th Avenue | Redmond  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Fluent in Japanese and can read and write French, Portuguese, and Spanish.                                              |
|    7 | Northwind Traders | Zare           | Robert       | robert@northwindtraders.com  | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 7th Avenue | Seattle  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# |                                                                                                                         |
|    8 | Northwind Traders | Giussani       | Laura        | laura@northwindtraders.com   | Sales Coordinator     | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 8th Avenue | Redmond  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Reads and writes French.                                                                                                |
|    9 | Northwind Traders | Hellung-Larsen | Anne         | anne@northwindtraders.com    | Sales Representative  | (123)555-0100    | (123)555-0102 |                | (123)555-0103 | 123 9th Avenue | Seattle  | WA               |             99999 | USA              | http://northwindtraders.com#http://northwindtraders.com/# | Fluent in French and German.                                                                                            |


Table: Inventory on Hold
|   Product ID |   Quantity On Hold |
|-------------:|-------------------:|
|            1 |                 25 |
|           34 |                 23 |
|           43 |                325 |
|           56 |                110 |
|           80 |                 20 |
|           81 |                 75 |


Table: Inventory on Order
|   Product ID |   Quantity On Order |
|-------------:|--------------------:|
|            1 |                  41 |
|            3 |                  50 |
|            4 |                  40 |
|            6 |                  10 |
|           19 |                  20 |
|           20 |                  40 |
|           40 |                 120 |
|           43 |                 300 |
|           51 |                  40 |
|           72 |                  40 |


Table: Inventory Purchased
|   Product ID |   Quantity Purchased |
|-------------:|---------------------:|
|            1 |                   40 |
|            3 |                  100 |
|            4 |                   40 |
|            5 |                   40 |
|            6 |                  100 |
|            7 |                   40 |
|            8 |                   65 |
|           14 |                   40 |
|           17 |                   40 |
|           19 |                   85 |


Table: Inventory Sold
|   Product ID |   Quantity Sold |
|-------------:|----------------:|
|            1 |              15 |
|            3 |              50 |
|            4 |              40 |
|            5 |              25 |
|            6 |             100 |
|            7 |              40 |
|            8 |              65 |
|           17 |              40 |
|           19 |              85 |
|           20 |              40 |


Table: Inventory Transaction Types
|   ID | Type Name   |
|-----:|:------------|
|    1 | Purchased   |
|    2 | Sold        |
|    3 | On Hold     |
|    4 | Waste       |


Table: Inventory Transactions
|   Transaction ID |   Transaction Type | Transaction Created Date   | Transaction Modified Date   |   Product ID |   Quantity | Purchase Order ID   | Customer Order ID   | Comments   |
|-----------------:|-------------------:|:---------------------------|:----------------------------|-------------:|-----------:|:--------------------|:--------------------|:-----------|
|               35 |                  1 | 2006-03-22 16:02:28.000    | 2006-03-22 16:02:28.000     |           80 |         75 |                     |                     |            |
|               36 |                  1 | 2006-03-22 16:02:48.000    | 2006-03-22 16:02:48.000     |           72 |         40 |                     |                     |            |
|               37 |                  1 | 2006-03-22 16:03:04.000    | 2006-03-22 16:03:04.000     |           52 |        100 |                     |                     |            |
|               38 |                  1 | 2006-03-22 16:03:09.000    | 2006-03-22 16:03:09.000     |           56 |        120 |                     |                     |            |
|               39 |                  1 | 2006-03-22 16:03:14.000    | 2006-03-22 16:03:14.000     |           57 |         80 |                     |                     |            |
|               40 |                  1 | 2006-03-22 16:03:40.000    | 2006-03-22 16:03:40.000     |            6 |        100 |                     |                     |            |
|               41 |                  1 | 2006-03-22 16:03:47.000    | 2006-03-22 16:03:47.000     |            7 |         40 |                     |                     |            |
|               42 |                  1 | 2006-03-22 16:03:54.000    | 2006-03-22 16:03:54.000     |            8 |         40 |                     |                     |            |
|               43 |                  1 | 2006-03-22 16:04:02.000    | 2006-03-22 16:04:02.000     |           14 |         40 |                     |                     |            |
|               44 |                  1 | 2006-03-22 16:04:07.000    | 2006-03-22 16:04:07.000     |           17 |         40 |                     |                     |            |


Table: Invoices
|   Invoice ID |   Order ID | Invoice Date            | Due Date   |   Tax |   Shipping |   Amount Due |
|-------------:|-----------:|:------------------------|:-----------|------:|-----------:|-------------:|
|            5 |         31 | 2006-03-22 16:08:59.000 |            |     0 |          0 |            0 |
|            6 |         32 | 2006-03-22 16:10:27.000 |            |     0 |          0 |            0 |
|            7 |         40 | 2006-03-24 10:41:41.000 |            |     0 |          0 |            0 |
|            8 |         39 | 2006-03-24 10:55:46.000 |            |     0 |          0 |            0 |
|            9 |         38 | 2006-03-24 10:56:57.000 |            |     0 |          0 |            0 |
|           10 |         37 | 2006-03-24 10:57:38.000 |            |     0 |          0 |            0 |
|           11 |         36 | 2006-03-24 10:58:40.000 |            |     0 |          0 |            0 |
|           12 |         35 | 2006-03-24 10:59:41.000 |            |     0 |          0 |            0 |
|           13 |         34 | 2006-03-24 11:00:55.000 |            |     0 |          0 |            0 |
|           14 |         33 | 2006-03-24 11:02:02.000 |            |     0 |          0 |            0 |


Table: MeasuresTable



Table: Order Details Extended
|   ID |   Order ID |   Product ID |   Quantity |   Unit Price |   Discount |   Status ID | Date Allocated   | Purchase Order ID   |   Inventory ID |   Extended Price | Status Name   |
|-----:|-----------:|-------------:|-----------:|-------------:|-----------:|------------:|:-----------------|:--------------------|---------------:|-----------------:|:--------------|
|   27 |         30 |           34 |        100 |        14    |          0 |           2 |                  | 96                  |             83 |           1400   | Invoiced      |
|   28 |         30 |           80 |         30 |         3.5  |          0 |           2 |                  |                     |             63 |            105   | Invoiced      |
|   29 |         31 |            7 |         10 |        30    |          0 |           2 |                  |                     |             64 |            300   | Invoiced      |
|   30 |         31 |           51 |         10 |        53    |          0 |           2 |                  |                     |             65 |            530   | Invoiced      |
|   31 |         31 |           80 |         10 |         3.5  |          0 |           2 |                  |                     |             66 |             35   | Invoiced      |
|   32 |         32 |            1 |         15 |        18    |          0 |           2 |                  |                     |             67 |            270   | Invoiced      |
|   33 |         32 |           43 |         20 |        46    |          0 |           2 |                  |                     |             68 |            920   | Invoiced      |
|   34 |         33 |           19 |         30 |         9.2  |          0 |           2 |                  | 97                  |             81 |            276   | Invoiced      |
|   35 |         34 |           19 |         20 |         9.2  |          0 |           2 |                  |                     |             69 |            184   | Invoiced      |
|   36 |         35 |           48 |         10 |        12.75 |          0 |           2 |                  |                     |             70 |            127.5 | Invoiced      |


Table: Order Details Status
|   Status ID | Status Name   |
|------------:|:--------------|
|           0 | None          |
|           1 | Allocated     |
|           2 | Invoiced      |
|           3 | Shipped       |
|           4 | On Order      |
|           5 | No Stock      |


Table: Order Details
|   ID |   Order ID |   Product ID |   Quantity |   Unit Price |   Discount |   Status ID | Date Allocated   | Purchase Order ID   |   Inventory ID |
|-----:|-----------:|-------------:|-----------:|-------------:|-----------:|------------:|:-----------------|:--------------------|---------------:|
|   27 |         30 |           34 |        100 |        14    |          0 |           2 |                  | 96                  |             83 |
|   28 |         30 |           80 |         30 |         3.5  |          0 |           2 |                  |                     |             63 |
|   29 |         31 |            7 |         10 |        30    |          0 |           2 |                  |                     |             64 |
|   30 |         31 |           51 |         10 |        53    |          0 |           2 |                  |                     |             65 |
|   31 |         31 |           80 |         10 |         3.5  |          0 |           2 |                  |                     |             66 |
|   32 |         32 |            1 |         15 |        18    |          0 |           2 |                  |                     |             67 |
|   33 |         32 |           43 |         20 |        46    |          0 |           2 |                  |                     |             68 |
|   34 |         33 |           19 |         30 |         9.2  |          0 |           2 |                  | 97                  |             81 |
|   35 |         34 |           19 |         20 |         9.2  |          0 |           2 |                  |                     |             69 |
|   36 |         35 |           48 |         10 |        12.75 |          0 |           2 |                  |                     |             70 |


Table: Order Price Totals
|   OrderID |   Price Total |
|----------:|--------------:|
|        30 |        1505   |
|        31 |         865   |
|        32 |        1190   |
|        33 |         276   |
|        34 |         184   |
|        35 |         127.5 |
|        36 |        1930   |
|        37 |         680   |
|        38 |       13800   |
|        39 |        1275   |


Table: Order Subtotals
|   Order ID |   Subtotal |
|-----------:|-----------:|
|         30 |     1505   |
|         31 |      865   |
|         32 |     1190   |
|         33 |      276   |
|         34 |      184   |
|         35 |      127.5 |
|         36 |     1930   |
|         37 |      680   |
|         38 |    13800   |
|         39 |     1275   |


Table: Order Summary
|   Order ID |   Employee ID |   Customer ID | Order Date              | Shipped Date            |   Sub Total |   Shipping Fee |   Taxes |   Order Total | Ship Name              | Ship Address    | Paid Date               | Status   |
|-----------:|--------------:|--------------:|:------------------------|:------------------------|------------:|---------------:|--------:|--------------:|:-----------------------|:----------------|:------------------------|:---------|
|         81 |             2 |             3 | 2006-04-25 17:26:53.000 |                         |         0   |              0 |       0 |           0   | Thomas Axen            | 123 3rd Street  |                         | New      |
|         80 |             2 |             4 | 2006-04-25 17:03:55.000 |                         |       380   |              0 |       0 |         380   | Christina Lee          | 123 4th Street  |                         | New      |
|         79 |             2 |             6 | 2006-06-23 00:00:00.000 | 2006-06-23 00:00:00.000 |      2490   |              0 |       0 |        2490   | Francisco Pérez-Olaeta | 123 6th Street  | 2006-06-23 00:00:00.000 | Closed   |
|         78 |             1 |            29 | 2006-06-05 00:00:00.000 | 2006-06-05 00:00:00.000 |      1560   |            200 |       0 |        1760   | Soo Jung Lee           | 789 29th Street | 2006-06-05 00:00:00.000 | Closed   |
|         77 |             9 |            26 | 2006-06-05 00:00:00.000 | 2006-06-05 00:00:00.000 |      2250   |             60 |       0 |        2310   | Run Liu                | 789 26th Street | 2006-06-05 00:00:00.000 | Closed   |
|         76 |             9 |            25 | 2006-06-05 00:00:00.000 | 2006-06-05 00:00:00.000 |       660   |              5 |       0 |         665   | John Rodman            | 789 25th Street | 2006-06-05 00:00:00.000 | Closed   |
|         75 |             4 |             8 | 2006-06-05 00:00:00.000 | 2006-06-05 00:00:00.000 |       510   |             50 |       0 |         560   | Elizabeth Andersen     | 123 8th Street  | 2006-06-05 00:00:00.000 | Closed   |
|         74 |             6 |             6 | 2006-06-08 00:00:00.000 | 2006-06-08 00:00:00.000 |       510   |            300 |       0 |         810   | Francisco Pérez-Olaeta | 123 6th Street  | 2006-06-08 00:00:00.000 | Closed   |
|         73 |             7 |             9 | 2006-06-05 00:00:00.000 | 2006-06-05 00:00:00.000 |        96.5 |            100 |       0 |         196.5 | Sven Mortensen         | 123 9th Street  | 2006-06-05 00:00:00.000 | Closed   |
|         72 |             1 |            28 | 2006-06-07 00:00:00.000 | 2006-06-07 00:00:00.000 |       230   |             40 |       0 |         270   | Amritansh Raghav       | 789 28th Street | 2006-06-07 00:00:00.000 | Closed   |


Table: Orders Status
|   Status ID | Status Name   |
|------------:|:--------------|
|           0 | New           |
|           1 | Invoiced      |
|           2 | Shipped       |
|           3 | Closed        |


Table: Orders Tax Status
|   ID | Tax Status Name   |
|-----:|:------------------|
|    0 | Tax Exempt        |
|    1 | Taxable           |


Table: Orders
|   Order ID |   Employee ID |   Customer ID | Order Date              | Shipped Date            |   Shipper ID | Ship Name              | Ship Address    | Ship City   | Ship State/Province   |   Ship ZIP/Postal Code | Ship Country/Region   |   Shipping Fee |   Taxes | Payment Type   | Paid Date               | Notes   |   Tax Rate | Tax Status   |   Status ID |
|-----------:|--------------:|--------------:|:------------------------|:------------------------|-------------:|:-----------------------|:----------------|:------------|:----------------------|-----------------------:|:----------------------|---------------:|--------:|:---------------|:------------------------|:--------|-----------:|:-------------|------------:|
|         30 |             9 |            27 | 2006-01-15 00:00:00.000 | 2006-01-22 00:00:00.000 |            2 | Karen Toh              | 789 27th Street | Las Vegas   | NV                    |                  99999 | USA                   |            200 |       0 | Check          | 2006-01-15 00:00:00.000 |         |          0 |              |           3 |
|         31 |             3 |             4 | 2006-01-20 00:00:00.000 | 2006-01-22 00:00:00.000 |            1 | Christina Lee          | 123 4th Street  | New York    | NY                    |                  99999 | USA                   |              5 |       0 | Credit Card    | 2006-01-20 00:00:00.000 |         |          0 |              |           3 |
|         32 |             4 |            12 | 2006-01-22 00:00:00.000 | 2006-01-22 00:00:00.000 |            2 | John Edwards           | 123 12th Street | Las Vegas   | NV                    |                  99999 | USA                   |              5 |       0 | Credit Card    | 2006-01-22 00:00:00.000 |         |          0 |              |           3 |
|         33 |             6 |             8 | 2006-01-30 00:00:00.000 | 2006-01-31 00:00:00.000 |            3 | Elizabeth Andersen     | 123 8th Street  | Portland    | OR                    |                  99999 | USA                   |             50 |       0 | Credit Card    | 2006-01-30 00:00:00.000 |         |          0 |              |           3 |
|         34 |             9 |             4 | 2006-02-06 00:00:00.000 | 2006-02-07 00:00:00.000 |            3 | Christina Lee          | 123 4th Street  | New York    | NY                    |                  99999 | USA                   |              4 |       0 | Check          | 2006-02-06 00:00:00.000 |         |          0 |              |           3 |
|         35 |             3 |            29 | 2006-02-10 00:00:00.000 | 2006-02-12 00:00:00.000 |            2 | Soo Jung Lee           | 789 29th Street | Denver      | CO                    |                  99999 | USA                   |              7 |       0 | Check          | 2006-02-10 00:00:00.000 |         |          0 |              |           3 |
|         36 |             4 |             3 | 2006-02-23 00:00:00.000 | 2006-02-25 00:00:00.000 |            2 | Thomas Axen            | 123 3rd Street  | Los Angelas | CA                    |                  99999 | USA                   |              7 |       0 | Cash           | 2006-02-23 00:00:00.000 |         |          0 |              |           3 |
|         37 |             8 |             6 | 2006-03-06 00:00:00.000 | 2006-03-09 00:00:00.000 |            2 | Francisco Pérez-Olaeta | 123 6th Street  | Milwaukee   | WI                    |                  99999 | USA                   |             12 |       0 | Credit Card    | 2006-03-06 00:00:00.000 |         |          0 |              |           3 |
|         38 |             9 |            28 | 2006-03-10 00:00:00.000 | 2006-03-11 00:00:00.000 |            3 | Amritansh Raghav       | 789 28th Street | Memphis     | TN                    |                  99999 | USA                   |             10 |       0 | Check          | 2006-03-10 00:00:00.000 |         |          0 |              |           3 |
|         39 |             3 |             8 | 2006-03-22 00:00:00.000 | 2006-03-24 00:00:00.000 |            3 | Elizabeth Andersen     | 123 8th Street  | Portland    | OR                    |                  99999 | USA                   |              5 |       0 | Check          | 2006-03-22 00:00:00.000 |         |          0 |              |           3 |


Table: Privileges
|   Privilege ID | Privilege Name     |
|---------------:|:-------------------|
|              2 | Purchase Approvals |


Table: Product Category Sales by Date
| Order Date              |   SumOfQuantity | Category                  |
|:------------------------|----------------:|:--------------------------|
| 2006-06-23 00:00:00.000 |              60 | Dried Fruit & Nuts        |
| 2006-06-08 00:00:00.000 |              40 | Candy                     |
| 2006-06-07 00:00:00.000 |               5 | Beverages                 |
| 2006-06-05 00:00:00.000 |              40 | Candy                     |
| 2006-06-05 00:00:00.000 |              40 | Canned Fruit & Vegetables |
| 2006-06-05 00:00:00.000 |              30 | Condiments                |
| 2006-06-05 00:00:00.000 |              90 | Jams, Preserves           |
| 2006-06-05 00:00:00.000 |              10 | Soups                     |
| 2006-05-24 00:00:00.000 |              40 | Canned Meat               |
| 2006-05-24 00:00:00.000 |              35 | Dried Fruit & Nuts        |


Table: Product Orders
|   Product ID |   Order ID | Order Date              | Shipped Date            |   Customer ID |   Quantity |   Unit Price |   Discount | Transaction   | Company Name   |   Status ID |
|-------------:|-----------:|:------------------------|:------------------------|--------------:|-----------:|-------------:|-----------:|:--------------|:---------------|------------:|
|           80 |         30 | 2006-01-15 00:00:00.000 | 2006-01-22 00:00:00.000 |            27 |         30 |         3.5  |          0 | Sale          | Company AA     |           2 |
|           34 |         30 | 2006-01-15 00:00:00.000 | 2006-01-22 00:00:00.000 |            27 |        100 |        14    |          0 | Sale          | Company AA     |           2 |
|            7 |         31 | 2006-01-20 00:00:00.000 | 2006-01-22 00:00:00.000 |             4 |         10 |        30    |          0 | Sale          | Company D      |           2 |
|           51 |         31 | 2006-01-20 00:00:00.000 | 2006-01-22 00:00:00.000 |             4 |         10 |        53    |          0 | Sale          | Company D      |           2 |
|           80 |         31 | 2006-01-20 00:00:00.000 | 2006-01-22 00:00:00.000 |             4 |         10 |         3.5  |          0 | Sale          | Company D      |           2 |
|            1 |         32 | 2006-01-22 00:00:00.000 | 2006-01-22 00:00:00.000 |            12 |         15 |        18    |          0 | Sale          | Company L      |           2 |
|           43 |         32 | 2006-01-22 00:00:00.000 | 2006-01-22 00:00:00.000 |            12 |         20 |        46    |          0 | Sale          | Company L      |           2 |
|           19 |         33 | 2006-01-30 00:00:00.000 | 2006-01-31 00:00:00.000 |             8 |         30 |         9.2  |          0 | Sale          | Company H      |           2 |
|           19 |         34 | 2006-02-06 00:00:00.000 | 2006-02-07 00:00:00.000 |             4 |         20 |         9.2  |          0 | Sale          | Company D      |           2 |
|           48 |         35 | 2006-02-10 00:00:00.000 | 2006-02-12 00:00:00.000 |            29 |         10 |        12.75 |          0 | Sale          | Company CC     |           2 |


Table: Product Purchases
|   Product ID |   Purchase Order ID | Creation Date           |   Quantity |   Unit Cost | Transaction   | Company Name   | Posted To Inventory   |
|-------------:|--------------------:|:------------------------|-----------:|------------:|:--------------|:---------------|:----------------------|
|           19 |                  92 | 2006-01-22 00:00:00.000 |         20 |           7 | Purchase      | Supplier B     | True                  |
|           56 |                  93 | 2006-01-22 00:00:00.000 |        120 |          28 | Purchase      | Supplier E     | True                  |
|           52 |                  93 | 2006-01-22 00:00:00.000 |        100 |           5 | Purchase      | Supplier E     | True                  |
|           51 |                  92 | 2006-01-22 00:00:00.000 |         40 |          40 | Purchase      | Supplier B     | True                  |
|           48 |                  92 | 2006-01-22 00:00:00.000 |        100 |          10 | Purchase      | Supplier B     | True                  |
|           43 |                  90 | 2006-01-22 00:00:00.000 |        100 |          34 | Purchase      | Supplier A     | True                  |
|           41 |                  92 | 2006-01-22 00:00:00.000 |         40 |           7 | Purchase      | Supplier B     | True                  |
|           40 |                  92 | 2006-01-22 00:00:00.000 |        120 |          14 | Purchase      | Supplier B     | True                  |
|           34 |                  90 | 2006-01-22 00:00:00.000 |         60 |          10 | Purchase      | Supplier A     | True                  |
|            1 |                  90 | 2006-01-22 00:00:00.000 |         40 |          14 | Purchase      | Supplier A     | True                  |


Table: Product Sales by Category
| Order Date              | Product Name                             | Category            |   Amount |
|:------------------------|:-----------------------------------------|:--------------------|---------:|
| 2006-01-15 00:00:00.000 | Northwind Traders Beer                   | Beverages           |   1400   |
| 2006-01-15 00:00:00.000 | Northwind Traders Dried Plums            | Dried Fruit & Nuts  |    105   |
| 2006-01-20 00:00:00.000 | Northwind Traders Dried Apples           | Dried Fruit & Nuts  |    530   |
| 2006-01-20 00:00:00.000 | Northwind Traders Dried Pears            | Dried Fruit & Nuts  |    300   |
| 2006-01-20 00:00:00.000 | Northwind Traders Dried Plums            | Dried Fruit & Nuts  |     35   |
| 2006-01-22 00:00:00.000 | Northwind Traders Chai                   | Beverages           |    270   |
| 2006-01-22 00:00:00.000 | Northwind Traders Coffee                 | Beverages           |    920   |
| 2006-01-30 00:00:00.000 | Northwind Traders Chocolate Biscuits Mix | Baked Goods & Mixes |    276   |
| 2006-02-06 00:00:00.000 | Northwind Traders Chocolate Biscuits Mix | Baked Goods & Mixes |    184   |
| 2006-02-10 00:00:00.000 | Northwind Traders Chocolate              | Candy               |    127.5 |


Table: Product Sales Qty by Employee and Date
| Order Date              | Employee Name       |   SumOfQuantity | Product Name                         |
|:------------------------|:--------------------|----------------:|:-------------------------------------|
| 2006-06-23 00:00:00.000 | Andrew Cencini      |              30 | Northwind Traders Dried Apples       |
| 2006-06-23 00:00:00.000 | Andrew Cencini      |              30 | Northwind Traders Dried Pears        |
| 2006-06-08 00:00:00.000 | Michael Neipper     |              40 | Northwind Traders Chocolate          |
| 2006-06-07 00:00:00.000 | Nancy Freehafer     |               5 | Northwind Traders Coffee             |
| 2006-06-05 00:00:00.000 | Anne Hellung-Larsen |              90 | Northwind Traders Boysenberry Spread |
| 2006-06-05 00:00:00.000 | Anne Hellung-Larsen |              30 | Northwind Traders Cajun Seasoning    |
| 2006-06-05 00:00:00.000 | Mariya Sergienko    |              40 | Northwind Traders Chocolate          |
| 2006-06-05 00:00:00.000 | Nancy Freehafer     |              40 | Northwind Traders Fruit Cocktail     |
| 2006-06-05 00:00:00.000 | Robert Zare         |              10 | Northwind Traders Clam Chowder       |
| 2006-05-24 00:00:00.000 | Mariya Sergienko    |              20 | Northwind Traders Almonds            |


Table: Product Sales Total by Date
| Product Name                         | Order Date              |   Amount |
|:-------------------------------------|:------------------------|---------:|
| Northwind Traders Coffee             | 2006-03-24 00:00:00.000 |    14950 |
| Northwind Traders Coffee             | 2006-03-10 00:00:00.000 |    13800 |
| Northwind Traders Beer               | 2006-04-08 00:00:00.000 |     4200 |
| Northwind Traders Marmalade          | 2006-04-22 00:00:00.000 |     3240 |
| Northwind Traders Boysenberry Spread | 2006-06-05 00:00:00.000 |     2250 |
| Northwind Traders Ravioli            | 2006-04-05 00:00:00.000 |     1950 |
| Northwind Traders Clam Chowder       | 2006-02-23 00:00:00.000 |     1930 |
| Northwind Traders Mozzarella         | 2006-04-05 00:00:00.000 |     1740 |
| Northwind Traders Dried Apples       | 2006-06-23 00:00:00.000 |     1590 |
| Northwind Traders Fruit Cocktail     | 2006-06-05 00:00:00.000 |     1560 |


Table: Products on Back Order



Table: Products
|   ID | Product Code   | Product Name                             | Description   |   Standard Cost |   List Price |   Reorder Level |   Target Level | Quantity Per Unit    | Discontinued   |   Minimum Reorder Quantity | Category                  | ProductNameShort       | DiscontinuedShort   |
|-----:|:---------------|:-----------------------------------------|:--------------|----------------:|-------------:|----------------:|---------------:|:---------------------|:---------------|---------------------------:|:--------------------------|:-----------------------|:--------------------|
|    1 | NWTB-1         | Northwind Traders Chai                   |               |         13.5    |        18    |              10 |             40 | 10 boxes x 20 bags   | False          |                         10 | Beverages                 | Chai                   | No                  |
|    3 | NWTCO-3        | Northwind Traders Syrup                  |               |          7.5    |        10    |              25 |            100 | 12 - 550 ml bottles  | False          |                         25 | Condiments                | Syrup                  | No                  |
|    4 | NWTCO-4        | Northwind Traders Cajun Seasoning        |               |         16.5    |        22    |              10 |             40 | 48 - 6 oz jars       | False          |                         10 | Condiments                | Cajun Seasoning        | No                  |
|    5 | NWTO-5         | Northwind Traders Olive Oil              |               |         16.0125 |        21.35 |              10 |             40 | 36 boxes             | False          |                         10 | Oil                       | Olive Oil              | No                  |
|    6 | NWTJP-6        | Northwind Traders Boysenberry Spread     |               |         18.75   |        25    |              25 |            100 | 12 - 8 oz jars       | False          |                         25 | Jams, Preserves           | Boysenberry Spread     | No                  |
|    7 | NWTDFN-7       | Northwind Traders Dried Pears            |               |         22.5    |        30    |              10 |             40 | 12 - 1 lb pkgs.      | False          |                         10 | Dried Fruit & Nuts        | Dried Pears            | No                  |
|    8 | NWTS-8         | Northwind Traders Curry Sauce            |               |         30      |        40    |              10 |             40 | 12 - 12 oz jars      | False          |                         10 | Sauces                    | Curry Sauce            | No                  |
|   14 | NWTDFN-14      | Northwind Traders Walnuts                |               |         17.4375 |        23.25 |              10 |             40 | 40 - 100 g pkgs.     | False          |                         10 | Dried Fruit & Nuts        | Walnuts                | No                  |
|   17 | NWTCFV-17      | Northwind Traders Fruit Cocktail         |               |         29.25   |        39    |              10 |             40 | 15.25 OZ             | False          |                         10 | Canned Fruit & Vegetables | Fruit Cocktail         | No                  |
|   19 | NWTBGM-19      | Northwind Traders Chocolate Biscuits Mix |               |          6.9    |         9.2  |               5 |             20 | 10 boxes x 12 pieces | False          |                          5 | Baked Goods & Mixes       | Chocolate Biscuits Mix | No                  |


Table: Purchase Details Extended
|   ID |   Purchase Order ID |   Product ID |   Quantity |   Unit Cost | Date Received           | Posted To Inventory   |   Inventory ID |   Extended Price | Product Name                             |
|-----:|--------------------:|-------------:|-----------:|------------:|:------------------------|:----------------------|---------------:|-----------------:|:-----------------------------------------|
|  238 |                  90 |            1 |         40 |          14 | 2006-01-22 00:00:00.000 | True                  |             59 |              560 | Northwind Traders Chai                   |
|  239 |                  91 |            3 |        100 |           8 | 2006-01-22 00:00:00.000 | True                  |             54 |              800 | Northwind Traders Syrup                  |
|  240 |                  91 |            4 |         40 |          16 | 2006-01-22 00:00:00.000 | True                  |             55 |              640 | Northwind Traders Cajun Seasoning        |
|  241 |                  91 |            5 |         40 |          16 | 2006-01-22 00:00:00.000 | True                  |             56 |              640 | Northwind Traders Olive Oil              |
|  242 |                  92 |            6 |        100 |          19 | 2006-01-22 00:00:00.000 | True                  |             40 |             1900 | Northwind Traders Boysenberry Spread     |
|  243 |                  92 |            7 |         40 |          22 | 2006-01-22 00:00:00.000 | True                  |             41 |              880 | Northwind Traders Dried Pears            |
|  244 |                  92 |            8 |         40 |          30 | 2006-01-22 00:00:00.000 | True                  |             42 |             1200 | Northwind Traders Curry Sauce            |
|  245 |                  92 |           14 |         40 |          17 | 2006-01-22 00:00:00.000 | True                  |             43 |              680 | Northwind Traders Walnuts                |
|  246 |                  92 |           17 |         40 |          29 | 2006-01-22 00:00:00.000 | True                  |             44 |             1160 | Northwind Traders Fruit Cocktail         |
|  247 |                  92 |           19 |         20 |           7 | 2006-01-22 00:00:00.000 | True                  |             45 |              140 | Northwind Traders Chocolate Biscuits Mix |


Table: Purchase Order Details
|   ID |   Purchase Order ID |   Product ID |   Quantity |   Unit Cost | Date Received           | Posted To Inventory   |   Inventory ID |
|-----:|--------------------:|-------------:|-----------:|------------:|:------------------------|:----------------------|---------------:|
|  238 |                  90 |            1 |         40 |          14 | 2006-01-22 00:00:00.000 | True                  |             59 |
|  239 |                  91 |            3 |        100 |           8 | 2006-01-22 00:00:00.000 | True                  |             54 |
|  240 |                  91 |            4 |         40 |          16 | 2006-01-22 00:00:00.000 | True                  |             55 |
|  241 |                  91 |            5 |         40 |          16 | 2006-01-22 00:00:00.000 | True                  |             56 |
|  242 |                  92 |            6 |        100 |          19 | 2006-01-22 00:00:00.000 | True                  |             40 |
|  243 |                  92 |            7 |         40 |          22 | 2006-01-22 00:00:00.000 | True                  |             41 |
|  244 |                  92 |            8 |         40 |          30 | 2006-01-22 00:00:00.000 | True                  |             42 |
|  245 |                  92 |           14 |         40 |          17 | 2006-01-22 00:00:00.000 | True                  |             43 |
|  246 |                  92 |           17 |         40 |          29 | 2006-01-22 00:00:00.000 | True                  |             44 |
|  247 |                  92 |           19 |         20 |           7 | 2006-01-22 00:00:00.000 | True                  |             45 |


Table: Purchase Order Status
|   Status ID | Status    |
|------------:|:----------|
|           0 | New       |
|           1 | Submitted |
|           2 | Approved  |
|           3 | Closed    |


Table: Purchase Orders
|   Purchase Order ID |   Supplier ID |   Created By | Submitted Date          | Creation Date           |   Status ID | Expected Date   |   Shipping Fee |   Taxes | Payment Date   |   Payment Amount | Payment Method   | Notes                                 |   Approved By | Approved Date           |   Submitted By |
|--------------------:|--------------:|-------------:|:------------------------|:------------------------|------------:|:----------------|---------------:|--------:|:---------------|-----------------:|:-----------------|:--------------------------------------|--------------:|:------------------------|---------------:|
|                  90 |             1 |            2 | 2006-01-14 00:00:00.000 | 2006-01-22 00:00:00.000 |           2 |                 |              0 |       0 |                |                0 |                  |                                       |             2 | 2006-01-22 00:00:00.000 |              2 |
|                  91 |             3 |            2 | 2006-01-14 00:00:00.000 | 2006-01-22 00:00:00.000 |           2 |                 |              0 |       0 |                |                0 |                  |                                       |             2 | 2006-01-22 00:00:00.000 |              2 |
|                  92 |             2 |            2 | 2006-01-14 00:00:00.000 | 2006-01-22 00:00:00.000 |           2 |                 |              0 |       0 |                |                0 |                  |                                       |             2 | 2006-01-22 00:00:00.000 |              2 |
|                  93 |             5 |            2 | 2006-01-14 00:00:00.000 | 2006-01-22 00:00:00.000 |           2 |                 |              0 |       0 |                |                0 |                  |                                       |             2 | 2006-01-22 00:00:00.000 |              2 |
|                  94 |             6 |            2 | 2006-01-14 00:00:00.000 | 2006-01-22 00:00:00.000 |           2 |                 |              0 |       0 |                |                0 |                  |                                       |             2 | 2006-01-22 00:00:00.000 |              2 |
|                  95 |             4 |            2 | 2006-01-14 00:00:00.000 | 2006-01-22 00:00:00.000 |           2 |                 |              0 |       0 |                |                0 |                  |                                       |             2 | 2006-01-22 00:00:00.000 |              2 |
|                  96 |             1 |            5 | 2006-01-14 00:00:00.000 | 2006-01-22 00:00:00.000 |           2 |                 |              0 |       0 |                |                0 |                  | Purchase generated based on Order #30 |             2 | 2006-01-22 00:00:00.000 |              5 |
|                  97 |             2 |            7 | 2006-01-14 00:00:00.000 | 2006-01-22 00:00:00.000 |           2 |                 |              0 |       0 |                |                0 |                  | Purchase generated based on Order #33 |             2 | 2006-01-22 00:00:00.000 |              7 |
|                  98 |             2 |            4 | 2006-01-14 00:00:00.000 | 2006-01-22 00:00:00.000 |           2 |                 |              0 |       0 |                |                0 |                  | Purchase generated based on Order #36 |             2 | 2006-01-22 00:00:00.000 |              4 |
|                  99 |             1 |            3 | 2006-01-14 00:00:00.000 | 2006-01-22 00:00:00.000 |           2 |                 |              0 |       0 |                |                0 |                  | Purchase generated based on Order #38 |             2 | 2006-01-22 00:00:00.000 |              3 |


Table: Purchase Price Totals
|   Purchase ID |   Price Total |
|--------------:|--------------:|
|            90 |          5370 |
|            91 |          4800 |
|            92 |         14020 |
|            93 |          5060 |
|            94 |          1040 |
|            95 |           225 |
|            96 |          1000 |
|            97 |           210 |
|            98 |          1400 |
|            99 |         10200 |


Table: Purchase Summary
| Creation Date           | Status    |   Supplier ID |   Shipping Fee |   Taxes |   Order Total |   Sub Total | Payment Date   | Approved By   | Approved Date           |   Submitted By | Submitted Date          |   Status ID |   Purchase Order ID |
|:------------------------|:----------|--------------:|---------------:|--------:|--------------:|------------:|:---------------|:--------------|:------------------------|---------------:|:------------------------|------------:|--------------------:|
| 2006-04-26 18:33:52.000 | Submitted |             5 |              0 |       0 |        1040   |      1040   |                |               |                         |              2 | 2006-04-26 18:33:52.000 |           1 |                 148 |
| 2006-04-26 18:33:28.000 | Submitted |             7 |              0 |       0 |        1560   |      1560   |                |               |                         |              2 | 2006-04-26 18:33:28.000 |           1 |                 147 |
| 2006-04-26 18:26:37.000 | Submitted |             2 |              0 |       0 |        3960   |      3960   |                |               |                         |              2 | 2006-04-26 18:26:37.000 |           1 |                 146 |
| 2006-04-25 17:18:29.000 | Approved  |             8 |              0 |       0 |          13.5 |        13.5 |                | 2             | 2006-04-25 17:18:51.000 |              2 | 2006-04-25 00:00:00.000 |           2 |                 142 |
| 2006-04-25 17:10:35.000 | Approved  |             8 |              0 |       0 |         187.5 |       187.5 |                | 2             | 2006-04-25 17:10:55.000 |              2 | 2006-04-25 00:00:00.000 |           2 |                 141 |
| 2006-04-25 16:40:51.000 | Approved  |             6 |              0 |       0 |          90   |        90   |                | 2             | 2006-04-25 16:41:33.000 |              2 | 2006-04-25 00:00:00.000 |           2 |                 140 |
| 2006-03-31 00:00:00.000 | Approved  |             1 |              0 |       0 |         500   |       500   |                | 2             | 2006-04-04 00:00:00.000 |              2 | 2006-03-31 00:00:00.000 |           2 |                 111 |
| 2006-03-24 00:00:00.000 | Approved  |             1 |              0 |       0 |        8500   |      8500   |                | 2             | 2006-04-04 00:00:00.000 |              3 | 2006-03-24 00:00:00.000 |           2 |                 110 |
| 2006-03-24 00:00:00.000 | Approved  |             2 |              0 |       0 |         175   |       175   |                | 2             | 2006-04-04 00:00:00.000 |              4 | 2006-03-24 00:00:00.000 |           2 |                 109 |
| 2006-03-24 00:00:00.000 | Approved  |             2 |              0 |       0 |         750   |       750   |                | 2             | 2006-04-04 00:00:00.000 |              4 | 2006-03-24 00:00:00.000 |           2 |                 108 |


Table: Sales Analysis
|   Order ID | Order Date              | Employee            | Customer Name   | Product Name                             |   Sales | State/Province   | Country/Region   |   Employee ID |   Product ID |   Customer ID |   Year |   Month |   Quarter | Month Name   | Category            | Product                                  | Customer   |   MonthOfQuarter |
|-----------:|:------------------------|:--------------------|:----------------|:-----------------------------------------|--------:|:-----------------|:-----------------|--------------:|-------------:|--------------:|-------:|--------:|----------:|:-------------|:--------------------|:-----------------------------------------|:-----------|-----------------:|
|         30 | 2006-01-15 00:00:00.000 | Anne Hellung-Larsen | Company AA      | Northwind Traders Beer                   |  1400   | NV               | USA              |             9 |           34 |            27 |   2006 |       1 |         1 | January      | Beverages           | Northwind Traders Beer                   | Company AA |                1 |
|         30 | 2006-01-15 00:00:00.000 | Anne Hellung-Larsen | Company AA      | Northwind Traders Dried Plums            |   105   | NV               | USA              |             9 |           80 |            27 |   2006 |       1 |         1 | January      | Dried Fruit & Nuts  | Northwind Traders Dried Plums            | Company AA |                1 |
|         31 | 2006-01-20 00:00:00.000 | Jan Kotas           | Company D       | Northwind Traders Dried Pears            |   300   | NY               | USA              |             3 |            7 |             4 |   2006 |       1 |         1 | January      | Dried Fruit & Nuts  | Northwind Traders Dried Pears            | Company D  |                1 |
|         31 | 2006-01-20 00:00:00.000 | Jan Kotas           | Company D       | Northwind Traders Dried Apples           |   530   | NY               | USA              |             3 |           51 |             4 |   2006 |       1 |         1 | January      | Dried Fruit & Nuts  | Northwind Traders Dried Apples           | Company D  |                1 |
|         31 | 2006-01-20 00:00:00.000 | Jan Kotas           | Company D       | Northwind Traders Dried Plums            |    35   | NY               | USA              |             3 |           80 |             4 |   2006 |       1 |         1 | January      | Dried Fruit & Nuts  | Northwind Traders Dried Plums            | Company D  |                1 |
|         32 | 2006-01-22 00:00:00.000 | Mariya Sergienko    | Company L       | Northwind Traders Chai                   |   270   | NV               | USA              |             4 |            1 |            12 |   2006 |       1 |         1 | January      | Beverages           | Northwind Traders Chai                   | Company L  |                1 |
|         32 | 2006-01-22 00:00:00.000 | Mariya Sergienko    | Company L       | Northwind Traders Coffee                 |   920   | NV               | USA              |             4 |           43 |            12 |   2006 |       1 |         1 | January      | Beverages           | Northwind Traders Coffee                 | Company L  |                1 |
|         33 | 2006-01-30 00:00:00.000 | Michael Neipper     | Company H       | Northwind Traders Chocolate Biscuits Mix |   276   | OR               | USA              |             6 |           19 |             8 |   2006 |       1 |         1 | January      | Baked Goods & Mixes | Northwind Traders Chocolate Biscuits Mix | Company H  |                1 |
|         34 | 2006-02-06 00:00:00.000 | Anne Hellung-Larsen | Company D       | Northwind Traders Chocolate Biscuits Mix |   184   | NY               | USA              |             9 |           19 |             4 |   2006 |       2 |         1 | February     | Baked Goods & Mixes | Northwind Traders Chocolate Biscuits Mix | Company D  |                2 |
|         35 | 2006-02-10 00:00:00.000 | Jan Kotas           | Company CC      | Northwind Traders Chocolate              |   127.5 | CO               | USA              |             3 |           48 |            29 |   2006 |       2 |         1 | February     | Candy               | Northwind Traders Chocolate              | Company CC |                2 |


Table: Sales Reports
| Group By       | Display        | Title             | Filter Row Source                                                                     | Default   |
|:---------------|:---------------|:------------------|:--------------------------------------------------------------------------------------|:----------|
| Category       | Category       | Sales By Category | SELECT DISTINCT [Category] FROM [Products] ORDER BY [Category];                       | False     |
| Country/Region | Country/Region | Sales By Country  | SELECT DISTINCT [Country/Region] FROM [Customers Extended] ORDER BY [Country/Region]; | False     |
| Customer ID    | Customer       | Sales By Customer | SELECT DISTINCT [Company] FROM [Customers Extended] ORDER BY [Company];               | False     |
| Employee ID    | Employee       | Sales By Employee | SELECT DISTINCT [Employee Name] FROM [Employees Extended] ORDER BY [Employee Name];   | False     |
| Product ID     | Product        | Sales by Product  | SELECT DISTINCT [Product Name] FROM [Products] ORDER BY [Product Name];               | True      |


Table: Shippers Extended
| File As            | Contact Name       |   ID | Company            | Last Name   | First Name   | E-mail Address   | Job Title   | Business Phone   | Home Phone   | Mobile Phone   | Fax Number   | Address        | City    | State/Province   |   ZIP/Postal Code | Country/Region   | Web Page   | Notes   |
|:-------------------|:-------------------|-----:|:-------------------|:------------|:-------------|:-----------------|:------------|:-----------------|:-------------|:---------------|:-------------|:---------------|:--------|:-----------------|------------------:|:-----------------|:-----------|:--------|
| Shipping Company A | Shipping Company A |    1 | Shipping Company A |             |              |                  |             |                  |              |                |              | 123 Any Street | Memphis | TN               |             99999 | USA              |            |         |
| Shipping Company B | Shipping Company B |    2 | Shipping Company B |             |              |                  |             |                  |              |                |              | 123 Any Street | Memphis | TN               |             99999 | USA              |            |         |
| Shipping Company C | Shipping Company C |    3 | Shipping Company C |             |              |                  |             |                  |              |                |              | 123 Any Street | Memphis | TN               |             99999 | USA              |            |         |


Table: Shippers
|   ID | Company            | Last Name   | First Name   | E-mail Address   | Job Title   | Business Phone   | Home Phone   | Mobile Phone   | Fax Number   | Address        | City    | State/Province   |   ZIP/Postal Code | Country/Region   | Web Page   | Notes   |
|-----:|:-------------------|:------------|:-------------|:-----------------|:------------|:-----------------|:-------------|:---------------|:-------------|:---------------|:--------|:-----------------|------------------:|:-----------------|:-----------|:--------|
|    1 | Shipping Company A |             |              |                  |             |                  |              |                |              | 123 Any Street | Memphis | TN               |             99999 | USA              |            |         |
|    2 | Shipping Company B |             |              |                  |             |                  |              |                |              | 123 Any Street | Memphis | TN               |             99999 | USA              |            |         |
|    3 | Shipping Company C |             |              |                  |             |                  |              |                |              | 123 Any Street | Memphis | TN               |             99999 | USA              |            |         |


Table: Strings
|   String ID | String Data                                                                                                         |
|------------:|:--------------------------------------------------------------------------------------------------------------------|
|           2 | Northwind Traders                                                                                                   |
|           3 | Cannot remove posted inventory!                                                                                     |
|           4 | Back ordered product filled for Order #|                                                                            |
|           5 | Discounted price below cost!                                                                                        |
|           6 | Insufficient inventory.                                                                                             |
|           7 | Insufficient inventory. Do you want to create a purchase order?                                                     |
|           8 | Purchase orders were successfully created for | products                                                            |
|           9 | There are no products below their respective reorder levels                                                         |
|          10 | Must specify customer name!                                                                                         |
|          11 | Restocking will generate purchase orders for all products below desired inventory levels.  Do you want to continue? |


Table: Suppliers Extended
| File As                     | Contact Name               |   ID | Company    | Last Name            | First Name   | E-mail Address   | Job Title            | Business Phone   | Home Phone   | Mobile Phone   | Fax Number   | Address   | City   | State/Province   | ZIP/Postal Code   | Country/Region   | Web Page   | Notes   |
|:----------------------------|:---------------------------|-----:|:-----------|:---------------------|:-------------|:-----------------|:---------------------|:-----------------|:-------------|:---------------|:-------------|:----------|:-------|:-----------------|:------------------|:-----------------|:-----------|:--------|
| Andersen, Elizabeth A.      | Elizabeth A. Andersen      |    1 | Supplier A | Andersen             | Elizabeth A. |                  | Sales Manager        |                  |              |                |              |           |        |                  |                   |                  |            |         |
| Dunton, Bryn Paul           | Bryn Paul Dunton           |    8 | Supplier H | Dunton               | Bryn Paul    |                  | Sales Representative |                  |              |                |              |           |        |                  |                   |                  |            |         |
| Glasson, Stuart             | Stuart Glasson             |    7 | Supplier G | Glasson              | Stuart       |                  | Marketing Manager    |                  |              |                |              |           |        |                  |                   |                  |            |         |
| Hayakawa, Satomi            | Satomi Hayakawa            |    6 | Supplier F | Hayakawa             | Satomi       |                  | Marketing Assistant  |                  |              |                |              |           |        |                  |                   |                  |            |         |
| Hernandez-Echevarria, Amaya | Amaya Hernandez-Echevarria |    5 | Supplier E | Hernandez-Echevarria | Amaya        |                  | Sales Manager        |                  |              |                |              |           |        |                  |                   |                  |            |         |
| Kelley, Madeleine           | Madeleine Kelley           |    3 | Supplier C | Kelley               | Madeleine    |                  | Sales Representative |                  |              |                |              |           |        |                  |                   |                  |            |         |
| Sandberg, Mikael            | Mikael Sandberg            |    9 | Supplier I | Sandberg             | Mikael       |                  | Sales Manager        |                  |              |                |              |           |        |                  |                   |                  |            |         |
| Sato, Naoki                 | Naoki Sato                 |    4 | Supplier D | Sato                 | Naoki        |                  | Marketing Manager    |                  |              |                |              |           |        |                  |                   |                  |            |         |
| Sousa, Luis                 | Luis Sousa                 |   10 | Supplier J | Sousa                | Luis         |                  | Sales Manager        |                  |              |                |              |           |        |                  |                   |                  |            |         |
| Weiler, Cornelia            | Cornelia Weiler            |    2 | Supplier B | Weiler               | Cornelia     |                  | Sales Manager        |                  |              |                |              |           |        |                  |                   |                  |            |         |


Table: Suppliers
|   ID | Company    | Last Name            | First Name   | E-mail Address   | Job Title            | Business Phone   | Home Phone   | Mobile Phone   | Fax Number   | Address   | City   | State/Province   | ZIP/Postal Code   | Country/Region   | Web Page   | Notes   |
|-----:|:-----------|:---------------------|:-------------|:-----------------|:---------------------|:-----------------|:-------------|:---------------|:-------------|:----------|:-------|:-----------------|:------------------|:-----------------|:-----------|:--------|
|    1 | Supplier A | Andersen             | Elizabeth A. |                  | Sales Manager        |                  |              |                |              |           |        |                  |                   |                  |            |         |
|    2 | Supplier B | Weiler               | Cornelia     |                  | Sales Manager        |                  |              |                |              |           |        |                  |                   |                  |            |         |
|    3 | Supplier C | Kelley               | Madeleine    |                  | Sales Representative |                  |              |                |              |           |        |                  |                   |                  |            |         |
|    4 | Supplier D | Sato                 | Naoki        |                  | Marketing Manager    |                  |              |                |              |           |        |                  |                   |                  |            |         |
|    5 | Supplier E | Hernandez-Echevarria | Amaya        |                  | Sales Manager        |                  |              |                |              |           |        |                  |                   |                  |            |         |
|    6 | Supplier F | Hayakawa             | Satomi       |                  | Marketing Assistant  |                  |              |                |              |           |        |                  |                   |                  |            |         |
|    7 | Supplier G | Glasson              | Stuart       |                  | Marketing Manager    |                  |              |                |              |           |        |                  |                   |                  |            |         |
|    8 | Supplier H | Dunton               | Bryn Paul    |                  | Sales Representative |                  |              |                |              |           |        |                  |                   |                  |            |         |
|    9 | Supplier I | Sandberg             | Mikael       |                  | Sales Manager        |                  |              |                |              |           |        |                  |                   |                  |            |         |
|   10 | Supplier J | Sousa                | Luis         |                  | Sales Manager        |                  |              |                |              |           |        |                  |                   |                  |            |         |


Table: Top Ten Orders by Sales Amount
|   Order ID | Order Date              |   SaleAmount | CompanyName   | Shipped Date            |
|-----------:|:------------------------|-------------:|:--------------|:------------------------|
|         41 | 2006-03-24 00:00:00.000 |     13800    | Company G     |                         |
|         38 | 2006-03-10 00:00:00.000 |     13800    | Company BB    | 2006-03-11 00:00:00.000 |
|         47 | 2006-04-08 00:00:00.000 |      4200    | Company F     | 2006-04-08 00:00:00.000 |
|         46 | 2006-04-05 00:00:00.000 |      3690    | Company I     | 2006-04-05 00:00:00.000 |
|         58 | 2006-04-22 00:00:00.000 |      3520    | Company D     | 2006-04-22 00:00:00.000 |
|         79 | 2006-06-23 00:00:00.000 |      2490    | Company F     | 2006-06-23 00:00:00.000 |
|         77 | 2006-06-05 00:00:00.000 |      2250    | Company Z     | 2006-06-05 00:00:00.000 |
|         36 | 2006-02-23 00:00:00.000 |      1930    | Company C     | 2006-02-25 00:00:00.000 |
|         44 | 2006-03-24 00:00:00.000 |      1674.75 | Company A     |                         |
|         78 | 2006-06-05 00:00:00.000 |      1560    | Company CC    | 2006-06-05 00:00:00.000 |

 


tables: name: Customers Extended
data: Customers Extended.csv
name: Customers
data: Customers.csv
name: DateTable
data: DateTable.csv
name: Employee Privileges
data: Employee Privileges.csv
name: Employees Extended
data: Employees Extended.csv
name: Employees
data: Employees.csv
name: Inventory on Hold
data: Inventory on Hold.csv
name: Inventory on Order
data: Inventory on Order.csv
name: Inventory Purchased
data: Inventory Purchased.csv
name: Inventory Sold
data: Inventory Sold.csv
name: Inventory Transaction Types
data: Inventory Transaction Types.csv
name: Inventory Transactions
data: Inventory Transactions.csv
name: Invoices
data: Invoices.csv
name: MeasuresTable
data: MeasuresTable.csv
name: Order Details Extended
data: Order Details Extended.csv
name: Order Details Status
data: Order Details Status.csv
name: Order Details
data: Order Details.csv
name: Order Price Totals
data: Order Price Totals.csv
name: Order Subtotals
data: Order Subtotals.csv
name: Order Summary
data: Order Summary.csv
name: Orders Status
data: Orders Status.csv
name: Orders Tax Status
data: Orders Tax Status.csv
name: Orders
data: Orders.csv
name: Privileges
data: Privileges.csv
name: Product Category Sales by Date
data: Product Category Sales by Date.csv
name: Product Orders
data: Product Orders.csv
name: Product Purchases
data: Product Purchases.csv
name: Product Sales by Category
data: Product Sales by Category.csv
name: Product Sales Qty by Employee and Date
data: Product Sales Qty by Employee and Date.csv
name: Product Sales Total by Date
data: Product Sales Total by Date.csv
name: Products on Back Order
data: Products on Back Order.csv
name: Products
data: Products.csv
name: Purchase Details Extended
data: Purchase Details Extended.csv
name: Purchase Order Details
data: Purchase Order Details.csv
name: Purchase Order Status
data: Purchase Order Status.csv
name: Purchase Orders
data: Purchase Orders.csv
name: Purchase Price Totals
data: Purchase Price Totals.csv
name: Purchase Summary
data: Purchase Summary.csv
name: Sales Analysis
data: Sales Analysis.csv
name: Sales Reports
data: Sales Reports.csv
name: Shippers Extended
data: Shippers Extended.csv
name: Shippers
data: Shippers.csv
name: Strings
data: Strings.csv
name: Suppliers Extended
data: Suppliers Extended.csv
name: Suppliers
data: Suppliers.csv
name: Top Ten Orders by Sales Amount
data: Top Ten Orders by Sales Amount.csv
label: Orders
Customer ID
Customers
ID
Employee Privileges
Employee ID
Employees
ID
Employee Privileges
Privilege ID
Privileges
Privilege ID
Orders
Employee ID
Employees
ID
Purchase Orders
Created By
Employees
ID
Inventory Transactions
Transaction Type
Inventory Transaction Types
ID
Inventory Transactions
Customer Order ID
Orders
Order ID
Inventory Transactions
Product ID
Products
ID
Purchase Order Details
Inventory ID
Inventory Transactions
Transaction ID
Invoices
Order ID
Orders
Order ID
Order Details
Status ID
Order Details Status
Status ID
Order Details
Order ID
Orders
Order ID
Order Details
Product ID
Products
ID
Orders
Status ID
Orders Status
Status ID
Orders
Tax Status
Orders Tax Status
ID
Orders
Shipper ID
Shippers
ID
Purchase Orders
Status ID
Purchase Order Status
Status ID
Purchase Orders
Supplier ID
Suppliers
ID
Order Details
ID
Order Details Extended
ID
Customers
Company
Customers Extended
Company
Suppliers
Company
Suppliers Extended
Company
Shippers
Company
Shippers Extended
Company
Customers Extended
Last Name
Suppliers Extended
Last Name
Employees Extended
Last Name
Employees
Last Name
Product Sales Qty by Employee and Date
Employee Name
Employees Extended
Employee Name
Inventory on Hold
Product ID
Inventory Purchased
Product ID
Inventory on Order
Product ID
Inventory Purchased
Product ID
Inventory Sold
Product ID
Inventory Purchased
Product ID
Order Details Extended
Product ID
Inventory Purchased
Product ID
Product Orders
Product ID
Inventory Purchased
Product ID
Product Purchases
Product ID
Inventory Purchased
Product ID
Purchase Details Extended
Product ID
Inventory Purchased
Product ID
Sales Analysis
Product ID
Inventory Purchased
Product ID
Inventory Transactions
Product ID
Inventory Purchased
Product ID
Order Price Totals
OrderID
Orders
Order ID
Order Subtotals
Order ID
Orders
Order ID
Order Summary
Order ID
Orders
Order ID
Product Orders
Order ID
Orders
Order ID
Sales Analysis
Order ID
Orders
Order ID
Top Ten Orders by Sales Amount
Order ID
Orders
Order ID
Product Orders
Status ID
Order Details Status
Status ID
Purchase Summary
Status ID
Order Details Status
Status ID
Purchase Order Status
Status ID
Order Details Status
Status ID
Purchase Summary
Status ID
Orders Status
Status ID
Purchase Orders
Status ID
Orders Status
Status ID
Product Purchases
Purchase Order ID
Purchase Orders
Purchase Order ID
Purchase Details Extended
Purchase Order ID
Purchase Orders
Purchase Order ID
Product Sales by Category
Product Name
Products
Product Name
Product Sales Qty by Employee and Date
Product Name
Products
Product Name
Product Sales Total by Date
Product Name
Products
Product Name
Purchase Details Extended
Product Name
Products
Product Name
Sales Analysis
Product Name
Products
Product Name
output: {
    "joins": [
        {
            "from_table": "Orders",
            "from_column": "Customer ID",
            "to_table": "Customers",
            "to_column": "ID"
        },
        {
            "from_table": "Employee Privileges",
            "from_column": "Employee ID",
            "to_table": "Employees",
            "to_column": "ID"
        },
        {
            "from_table": "Employee Privileges",
            "from_column": "Privilege ID",
            "to_table": "Privileges",
            "to_column": "Privilege ID"
        },
        {
            "from_table": "Orders",
            "from_column": "Employee ID",
            "to_table": "Employees",
            "to_column": "ID"
        },
        {
            "from_table": "Purchase Orders",
            "from_column": "Created By",
            "to_table": "Employees",
            "to_column": "ID"
        },
        {
            "from_table": "Inventory Transactions",
            "from_column": "Transaction Type",
            "to_table": "Inventory Transaction Types",
            "to_column": "ID"
        },
        {
            "from_table": "Inventory Transactions",
            "from_column": "Customer Order ID",
            "to_table": "Orders",
            "to_column": "Order ID"
        },
        {
            "from_table": "Inventory Transactions",
            "from_column": "Product ID",
            "to_table": "Products",
            "to_column": "ID"
        },
        {
            "from_table": "Purchase Order Details",
            "from_column": "Inventory ID",
            "to_table": "Inventory Transactions",
            "to_column": "Transaction ID"
        },
        {
            "from_table": "Invoices",
            "from_column": "Order ID",
            "to_table": "Orders",
            "to_column": "Order ID"
        },
        {
            "from_table": "Order Details",
            "from_column": "Status ID",
            "to_table": "Order Details Status",
            "to_column": "Status ID"
        },
        {
            "from_table": "Order Details",
            "from_column": "Order ID",
            "to_table": "Orders",
            "to_column": "Order ID"
        },
        {
            "from_table": "Order Details",
            "from_column": "Product ID",
            "to_table": "Products",
            "to_column": "ID"
        },
        {
            "from_table": "Orders",
            "from_column": "Status ID",
            "to_table": "Orders Status",
            "to_column": "Status ID"
        },
        {
            "from_table": "Orders",
            "from_column": "Tax Status",
            "to_table": "Orders Tax Status",
            "to_column": "ID"
        },
        {
            "from_table": "Orders",
            "from_column": "Shipper ID",
            "to_table": "Shippers",
            "to_column": "ID"
        },
        {
            "from_table": "Purchase Orders",
            "from_column": "Status ID",
            "to_table": "Purchase Order Status",
            "to_column": "Status ID"
        },
        {
            "from_table": "Purchase Orders",
            "from_column": "Supplier ID",
            "to_table": "Suppliers",
            "to_column": "ID"
        },
        {
            "from_table": "Order Details",
            "from_column": "ID",
            "to_table": "Order Details Extended",
            "to_column": "ID"
        },
        {
            "from_table": "Customers",
            "from_column": "Company",
            "to_table": "Customers Extended",
            "to_column": "Company"
        },
        {
            "from_table": "Suppliers",
            "from_column": "Company",
            "to_table": "Suppliers Extended",
            "to_column": "Company"
        },
        {
            "from_table": "Shippers",
            "from_column": "Company",
            "to_table": "Shippers Extended",
            "to_column": "Company"
        },
        {
            "from_table": "Customers Extended",
            "from_column": "Last Name",
            "to_table": "Suppliers Extended",
            "to_column": "Last Name"
        },
        {
            "from_table": "Employees Extended",
            "from_column": "Last Name",
            "to_table": "Employees",
            "to_column": "Last Name"
        },
        {
            "from_table": "Product Sales Qty by Employee and Date",
            "from_column": "Employee Name",
            "to_table": "Employees Extended",
            "to_column": "Employee Name"
        },
        {
            "from_table": "Inventory on Hold",
            "from_column": "Product ID",
            "to_table": "Inventory Purchased",
            "to_column": "Product ID"
        },
        {
            "from_table": "Inventory on Order",
            "from_column": "Product ID",
            "to_table": "Inventory Purchased",
            "to_column": "Product ID"
        },
        {
            "from_table": "Inventory Sold",
            "from_column": "Product ID",
            "to_table": "Inventory Purchased",
            "to_column": "Product ID"
        },
        {
            "from_table": "Order Details Extended",
            "from_column": "Product ID",
            "to_table": "Inventory Purchased",
            "to_column": "Product ID"
        },
        {
            "from_table": "Product Orders",
            "from_column": "Product ID",
            "to_table": "Inventory Purchased",
            "to_column": "Product ID"
        },
        {
            "from_table": "Product Purchases",
            "from_column": "Product ID",
            "to_table": "Inventory Purchased",
            "to_column": "Product ID"
        },
        {
            "from_table": "Purchase Details Extended",
            "from_column": "Product ID",
            "to_table": "Inventory Purchased",
            "to_column": "Product ID"
        },
        {
            "from_table": "Sales Analysis",
            "from_column": "Product ID",
            "to_table": "Inventory Purchased",
            "to_column": "Product ID"
        },
        {
            "from_table": "Inventory Transactions",
            "from_column": "Product ID",
            "to_table": "Inventory Purchased",
            "to_column": "Product ID"
        },
        {
            "from_table": "Order Price Totals",
            "from_column": "OrderID",
            "to_table": "Orders",
            "to_column": "Order ID"
        },
        {
            "from_table": "Order Subtotals",
            "from_column": "Order ID",
            "to_table": "Orders",
            "to_column": "Order ID"
        },
        {
            "from_table": "Order Summary",
            "from_column": "Order ID",
            "to_table": "Orders",
            "to_column": "Order ID"
        },
        {
            "from_table": "Product Orders",
            "from_column": "Order ID",
            "to_table": "Orders",
            "to_column": "Order ID"
        },
        {
            "from_table": "Sales Analysis",
            "from_column": "Order ID",
            "to_table": "Orders",
            "to_column": "Order ID"
        },
        {
            "from_table": "Top Ten Orders by Sales Amount",
            "from_column": "Order ID",
            "to_table": "Orders",
            "to_column": "Order ID"
        },
        {
            "from_table": "Product Orders",
            "from_column": "Status ID",
            "to_table": "Order Details Status",
            "to_column": "Status ID"
        },
        {
            "from_table": "Purchase Summary",
            "from_column": "Status ID",
            "to_table": "Order Details Status",
            "to_column": "Status ID"
        },
        {
            "from_table": "Purchase Order Status",
            "from_column": "Status ID",
            "to_table": "Order Details Status",
            "to_column": "Status ID"
        },
        {
            "from_table": "Purchase Summary",
            "from_column": "Status ID",
            "to_table": "Orders Status",
            "to_column": "Status ID"
        },
        {
            "from_table": "Purchase Orders",
            "from_column": "Status ID",
            "to_table": "Orders Status",
            "to_column": "Status ID"
        },
        {
            "from_table": "Product Purchases",
            "from_column": "Purchase Order ID",
            "to_table": "Purchase Orders",
            "to_column": "Purchase Order ID"
        },
        {
            "from_table": "Purchase Details Extended",
            "from_column": "Purchase Order ID",
            "to_table": "Purchase Orders",
            "to_column": "Purchase Order ID"
        },
        {
            "from_table": "Product Sales by Category",
            "from_column": "Product Name",
            "to_table": "Products",
            "to_column": "Product Name"
        },
        {
            "from_table": "Product Sales Qty by Employee and Date",
            "from_column": "Product Name",
            "to_table": "Products",
            "to_column": "Product Name"
        },
        {
            "from_table": "Product Sales Total by Date",
            "from_column": "Product Name",
            "to_table": "Products",
            "to_column": "Product Name"
        },
        {
            "from_table": "Purchase Details Extended",
            "from_column": "Product Name",
            "to_table": "Products",
            "to_column": "Product Name"
        },
        {
            "from_table": "Sales Analysis",
            "from_column": "Product Name",
            "to_table": "Products",
            "to_column": "Product Name"
        }
    ]
}