MySQL · Chinook
Employee
- Source rows
- 8
- Synthetic rows
- 8
- Broken foreign keys
- 0
- Rows equal to a source row
- 0%
References: ReportsTo → Employee
Rows
Both databases, first rows by primary key, in one table: scrolling sideways moves them together. Rows at the same position are unrelated, unless the table holds kept reference data. Long values are cut at 60 characters.
| EmployeeId key | LastName | FirstName | Title | ReportsTo | BirthDate | HireDate | Address | City | State | Country | PostalCode | Phone | Fax | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Source database · 8 of 8 rows | ||||||||||||||
| 1 | Adams | Andrew | General Manager | NULL | 1962-02-18 00:00:00 | 2002-08-14 00:00:00 | 11120 Jasper Ave NW | Edmonton | AB | Canada | T5K 2N1 | +1 (780) 428-9482 | +1 (780) 428-3457 | andrew@chinookcorp.com |
| 2 | Edwards | Nancy | Sales Manager | 1 | 1958-12-08 00:00:00 | 2002-05-01 00:00:00 | 825 8 Ave SW | Calgary | AB | Canada | T2P 2T3 | +1 (403) 262-3443 | +1 (403) 262-3322 | nancy@chinookcorp.com |
| 3 | Peacock | Jane | Sales Support Agent | 2 | 1973-08-29 00:00:00 | 2002-04-01 00:00:00 | 1111 6 Ave SW | Calgary | AB | Canada | T2P 5M5 | +1 (403) 262-3443 | +1 (403) 262-6712 | jane@chinookcorp.com |
| 4 | Park | Margaret | Sales Support Agent | 2 | 1947-09-19 00:00:00 | 2003-05-03 00:00:00 | 683 10 Street SW | Calgary | AB | Canada | T2P 5G3 | +1 (403) 263-4423 | +1 (403) 263-4289 | margaret@chinookcorp.com |
| 5 | Johnson | Steve | Sales Support Agent | 2 | 1965-03-03 00:00:00 | 2003-10-17 00:00:00 | 7727B 41 Ave | Calgary | AB | Canada | T3B 1Y7 | 1 (780) 836-9987 | 1 (780) 836-9543 | steve@chinookcorp.com |
| 6 | Mitchell | Michael | IT Manager | 1 | 1973-07-01 00:00:00 | 2003-10-17 00:00:00 | 5827 Bowness Road NW | Calgary | AB | Canada | T3B 0C5 | +1 (403) 246-9887 | +1 (403) 246-9899 | michael@chinookcorp.com |
| 7 | King | Robert | IT Staff | 6 | 1970-05-29 00:00:00 | 2004-01-02 00:00:00 | 590 Columbia Boulevard West | Lethbridge | AB | Canada | T1K 5N8 | +1 (403) 456-9986 | +1 (403) 456-8485 | robert@chinookcorp.com |
| 8 | Callahan | Laura | IT Staff | 6 | 1968-01-09 00:00:00 | 2004-03-04 00:00:00 | 923 7 ST NW | Lethbridge | AB | Canada | T1H 1Y8 | +1 (403) 467-3351 | +1 (403) 467-8772 | laura@chinookcorp.com |
| Synthetic database · 8 of 8 rows | ||||||||||||||
| 1 | Morgan | Benjamin | Field Technician | NULL | 1949-07-09 14:04:00 | 2002-04-11 10:32:05 | 1 High Central, Didsbury, Manchester | Manchester | AB | Canada | 110 | 3 (190) 869-0708 | 5 (198) 856-5869 | benjamin.morgan373@example.com |
| 2 | Williams | Ethan | Software Engineer | 1 | 1969-06-01 03:17:34 | 2003-12-05 18:57:30 | 2 High Riverside, Brooklyn, New York | New York | AB | Canada | 10011 | +3 (360) 441-9877 | 7 (194) 431-5715 | ethan.williams159@northwind.test |
| 3 | Cole | Aiden | Product Manager | 1 | 1972-09-09 20:42:10 | 2002-04-06 03:50:18 | 3 High Hillcrest, Hyde Park, Chicago | Chicago | AB | Canada | 60612 | 5 (194) 469-3030 | 7 (194) 366-0730 | aiden.cole747@example.org |
| 4 | Nelson | Skylar | Accountant | 1 | 1960-11-07 16:37:09 | 2004-02-15 05:23:11 | 4 Church Oakwood, Manly, Sydney | Sydney | AB | Canada | 200013 | 3 (190) 993-3655 | 6 (191) 294-3490 | skylar.nelson436@cedarpost.test |
| 5 | Jackson | Stanley | Quality Engineer | 2 | 1968-12-17 14:07:42 | 2003-10-23 22:46:14 | 5 Church Parkside, Greenwich, London | London | AB | Canada | 01004 | 1 (198) 132-7342 | 4 (193) 926-0072 | stanley.jackson308@notes.example |
| 6 | Cruz | William | Quality Engineer | 2 | 1970-01-01 03:29:13 | 2003-11-27 07:16:34 | 6 Church West End, Manhattan, New York | New York | AB | Canada | 10015 | +3 (363) 840-7318 | 6 (190) 477-5084 | william.cruz246@brightloft.test |
| 7 | Thomas | Jack | Accountant | 3 | 1963-10-06 23:57:07 | 2004-02-04 17:30:39 | 7 Station Central, Chorlton, Manchester | Manchester | AB | Canada | 116 | 1 (192) 576-0387 | +3 (373) 057-0381 | jack.thomas49@bluefinch.example |
| 8 | Thompson | Carter | Product Manager | 3 | 1966-11-16 23:51:28 | 2002-04-02 01:14:58 | 8 Station Riverside, Evanston, Chicago | Chicago | AB | Canada | 60617 | 2 (193) 570-3222 | 3 (365) 951-7973 | carter.thompson904@brightloft.test |
Column by column
Each figure is computed from all rows of both databases in the same way. S is the source, Y the synthetic copy. Difference runs from 0 (same distribution) to 1 (no overlap): Kolmogorov-Smirnov for numbers and times, total variation for columns with few values. Personal columns are meant to differ, so they show how many values also appear in the source instead. Lyrebird draws names from built-in lists, not from the source, so common names can match.
| Column | Model read it as | How it was generated | Empty | Distinct | Range or length | Most common | Difference |
|---|---|---|---|---|---|---|---|
| EmployeeIdint | record key | New key values | S 0% Y 0% | S 8 Y 8 | S 1 → 8 Y 1 → 8 | S 1 12.5% · 2 12.5% · 3 12.5% · 4 12.5% · 5 12.5% · 6 12.5% Y 1 12.5% · 2 12.5% · 3 12.5% · 4 12.5% · 5 12.5% · 6 12.5% | — |
| LastNamevarchar(20) | last namepersonal | New text in the measured format | S 0% Y 0% | S 8 Y 8 | S 6.2 chars avg Y 6.1 chars avg | S Adams 12.5% · Edwards 12.5% · Peacock 12.5% · Park 12.5% · Johnson 12.5% · Mitchell 12.5% Y Morgan 12.5% · Williams 12.5% · Cole 12.5% · Nelson 12.5% · Jackson 12.5% · Cruz 12.5% | 0% in source |
| FirstNamevarchar(20) | first namepersonal | New text in the measured format | S 0% Y 0% | S 8 Y 8 | S 5.8 chars avg Y 6 chars avg | S Andrew 12.5% · Nancy 12.5% · Jane 12.5% · Margaret 12.5% · Steve 12.5% · Michael 12.5% Y Benjamin 12.5% · Ethan 12.5% · Aiden 12.5% · Skylar 12.5% · Stanley 12.5% · William 12.5% | 0% in source |
| Titlevarchar(30) | job title | New text in the measured format | S 0% Y 0% | S 5 Y 5 | S 13.9 chars avg Y 14.4 chars avg | S Sales Support Agent 37.5% · IT Staff 25% · General Manager 12.5% · Sales Manager 12.5% · IT Manager 12.5% Y Product Manager 25% · Accountant 25% · Quality Engineer 25% · Field Technician 12.5% · Software Engineer 12.5% | 1 TVD |
| ReportsToint | record key | Foreign key, from the measured relationship | S 12.5% Y 12.5% | S 3 Y 3 | S 1 → 6 Y 1 → 3 | S 2 42.9% · 1 28.6% · 6 28.6% Y 1 42.9% · 2 28.6% · 3 28.6% | 0.286 KS |
| BirthDatedatetime | birth datepersonal | Times from the measured distribution | S 0% Y 0% | S 8 Y 8 | S 1947-09-19 00:00:00 → 1973-08-29 00:00:00 Y 1949-07-09 14:04:00 → 1972-09-09 20:42:10 | S 1962-02-18 00:00:00 12.5% · 1958-12-08 00:00:00 12.5% · 1973-08-29 00:00:00 12.5% · 1947-09-19 00:00:00 12.5% · 1965-03-03 00:00:00 12.5% · 1973-07-01 00:00:00 12.5% Y 1949-07-09 14:04:00 12.5% · 1969-06-01 03:17:34 12.5% · 1972-09-09 20:42:10 12.5% · 1960-11-07 16:37:09 12.5% · 1968-12-17 14:07:42 12.5% · 1970-01-01 03:29:13 12.5% | 0.25 KS |
| HireDatedatetime | lifecycle timestamp | Times from the measured distribution | S 0% Y 0% | S 7 Y 8 | S 2002-04-01 00:00:00 → 2004-03-04 00:00:00 Y 2002-04-02 01:14:58 → 2004-02-15 05:23:11 | S 2003-10-17 00:00:00 25% · 2002-08-14 00:00:00 12.5% · 2002-05-01 00:00:00 12.5% · 2002-04-01 00:00:00 12.5% · 2003-05-03 00:00:00 12.5% · 2004-01-02 00:00:00 12.5% Y 2002-04-11 10:32:05 12.5% · 2003-12-05 18:57:30 12.5% · 2002-04-06 03:50:18 12.5% · 2004-02-15 05:23:11 12.5% · 2003-10-23 22:46:14 12.5% · 2003-11-27 07:16:34 12.5% | 0.375 KS |
| Addressvarchar(70) | postal addresspersonal | New text in the measured format | S 0% Y 0% | S 8 Y 8 | S 16.2 chars avg Y 36.2 chars avg | S 11120 Jasper Ave NW 12.5% · 825 8 Ave SW 12.5% · 1111 6 Ave SW 12.5% · 683 10 Street SW 12.5% · 7727B 41 Ave 12.5% · 5827 Bowness Road NW 12.5% Y 1 High Central, Didsbury, Manchester 12.5% · 2 High Riverside, Brooklyn, New York 12.5% · 3 High Hillcrest, Hyde Park, Chicago 12.5% · 4 Church Oakwood, Manly, Sydney 12.5% · 5 Church Parkside, Greenwich, London 12.5% · 6 Church West End, Manhattan, New York 12.5% | 0% in source |
| Cityvarchar(40) | city | New text in the measured format | S 0% Y 0% | S 3 Y 5 | S 7.9 chars avg Y 7.8 chars avg | S Calgary 62.5% · Lethbridge 25% · Edmonton 12.5% Y Manchester 25% · New York 25% · Chicago 25% · Sydney 12.5% · London 12.5% | 1 TVD |
| Statevarchar(40) | generic value | Source values, at measured frequencies | S 0% Y 0% | S 1 Y 1 | S 2 chars avg Y 2 chars avg | S AB 100% Y AB 100% | 0 TVD |
| Countryvarchar(40) | country name | Source values, at measured frequencies | S 0% Y 0% | S 1 Y 1 | S 6 chars avg Y 6 chars avg | S Canada 100% Y Canada 100% | 0 TVD |
| PostalCodevarchar(10) | postal codepersonal | New text in the measured format | S 0% Y 0% | S 8 Y 8 | S 7 chars avg Y 4.6 chars avg | S T5K 2N1 12.5% · T2P 2T3 12.5% · T2P 5M5 12.5% · T2P 5G3 12.5% · T3B 1Y7 12.5% · T3B 0C5 12.5% Y 110 12.5% · 10011 12.5% · 60612 12.5% · 200013 12.5% · 01004 12.5% · 10015 12.5% | 0% in source |
| Phonevarchar(24) | phone numberpersonal | New text in the measured format | S 0% Y 0% | S 7 Y 8 | S 16.9 chars avg Y 16.2 chars avg | S +1 (403) 262-3443 25% · +1 (780) 428-9482 12.5% · +1 (403) 263-4423 12.5% · 1 (780) 836-9987 12.5% · +1 (403) 246-9887 12.5% · +1 (403) 456-9986 12.5% Y 3 (190) 869-0708 12.5% · +3 (360) 441-9877 12.5% · 5 (194) 469-3030 12.5% · 3 (190) 993-3655 12.5% · 1 (198) 132-7342 12.5% · +3 (363) 840-7318 12.5% | 0% in source |
| Faxvarchar(24) | phone numberpersonal | New text in the measured format | S 0% Y 0% | S 8 Y 8 | S 16.9 chars avg Y 16.1 chars avg | S +1 (780) 428-3457 12.5% · +1 (403) 262-3322 12.5% · +1 (403) 262-6712 12.5% · +1 (403) 263-4289 12.5% · 1 (780) 836-9543 12.5% · +1 (403) 246-9899 12.5% Y 5 (198) 856-5869 12.5% · 7 (194) 431-5715 12.5% · 7 (194) 366-0730 12.5% · 6 (191) 294-3490 12.5% · 4 (193) 926-0072 12.5% · 6 (190) 477-5084 12.5% | 0% in source |
| Emailvarchar(60) | emailpersonal | New text in the measured format | S 0% Y 0% | S 8 Y 8 | S 21.8 chars avg Y 30.8 chars avg | S andrew@chinookcorp.com 12.5% · nancy@chinookcorp.com 12.5% · jane@chinookcorp.com 12.5% · margaret@chinookcorp.com 12.5% · steve@chinookcorp.com 12.5% · michael@chinookcorp.com 12.5% Y benjamin.morgan373@example.com 12.5% · ethan.williams159@northwind.test 12.5% · aiden.cole747@example.org 12.5% · skylar.nelson436@cedarpost.test 12.5% · stanley.jackson308@notes.example 12.5% · william.cruz246@brightloft.test 12.5% | 0% in source |