SQL Server · AdventureWorksLT
SalesLT.SalesOrderDetail
- Source rows
- 542
- Synthetic rows
- 542
- Broken foreign keys
- 0
- Rows equal to a source row
- 0%
References: ProductID → SalesLT.ProductSalesOrderID → SalesLT.SalesOrderHeader
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.
| SalesOrderID key | SalesOrderDetailID key | OrderQty | ProductID | UnitPrice | UnitPriceDiscount | LineTotal | rowguid | ModifiedDate |
|---|---|---|---|---|---|---|---|---|
| Source database · 12 of 542 rows | ||||||||
| 71774 | 110562 | 1 | 836 | 356.8980 | 0 | 356.898000 | E3A1994C-7A68-4CE8-96A3-77FDD3BBD730 | 2008-06-01 00:00:00 |
| 71774 | 110563 | 1 | 822 | 356.8980 | 0 | 356.898000 | 5C77F557-FDB6-43BA-90B9-9A7AEC55CA32 | 2008-06-01 00:00:00 |
| 71776 | 110567 | 1 | 907 | 63.9000 | 0 | 63.900000 | 6DBFE398-D15D-425E-AA58-88178FE360E5 | 2008-06-01 00:00:00 |
| 71780 | 110616 | 4 | 905 | 218.4540 | 0 | 873.816000 | 377246C9-4483-48ED-A5B9-E56F005364E0 | 2008-06-01 00:00:00 |
| 71780 | 110617 | 2 | 983 | 461.6940 | 0 | 923.388000 | 43A54BCD-536D-4A1B-8E69-24D083507A14 | 2008-06-01 00:00:00 |
| 71780 | 110618 | 6 | 988 | 112.9980 | 0.4000 | 406.792800 | 12706FAB-F3A2-48C6-B7C7-1CCDE4081F18 | 2008-06-01 00:00:00 |
| 71780 | 110619 | 2 | 748 | 818.7000 | 0 | 1637.400000 | B12F0D3B-5B4E-4F1F-B2F0-F7CDE99DD826 | 2008-06-01 00:00:00 |
| 71780 | 110620 | 1 | 990 | 323.9940 | 0 | 323.994000 | F117A449-039D-44B8-A4B2-B12001DACC01 | 2008-06-01 00:00:00 |
| 71780 | 110621 | 1 | 926 | 149.8740 | 0 | 149.874000 | 92E5052B-72D0-4C91-9A8C-42591803667E | 2008-06-01 00:00:00 |
| 71780 | 110622 | 1 | 743 | 809.7600 | 0 | 809.760000 | 8BD33BED-C4F6-4D44-84FB-A7D04AFCD794 | 2008-06-01 00:00:00 |
| 71780 | 110623 | 4 | 782 | 1376.9940 | 0 | 5507.976000 | 686999FB-42E6-4D00-9A14-83FFA86833E3 | 2008-06-01 00:00:00 |
| 71780 | 110624 | 2 | 918 | 158.4300 | 0 | 316.860000 | 82940B03-C70B-4183-8660-6B3418908429 | 2008-06-01 00:00:00 |
| Synthetic database · 12 of 542 rows | ||||||||
| 71774 | 110562 | 3 | 861 | 105.2940 | 0 | 315.882000 | 2EB61058-1985-47A6-8000-000000000050 | 2008-06-01 00:00:00 |
| 71774 | 110590 | 1 | 756 | 20.9940 | 0 | 20.994000 | 2EB61058-1985-47A6-8000-000000000096 | 2008-06-01 00:00:00 |
| 71774 | 110618 | 2 | 746 | 72 | 0 | 144 | 2EB61058-1985-47A6-8000-00000000014F | 2008-06-01 00:00:00 |
| 71779 | 111721 | 1 | 937 | 158.4300 | 0 | 158.430000 | 2EB61058-1985-47A6-8000-00000000001E | 2008-06-01 00:00:00 |
| 71779 | 111749 | 1 | 885 | 29.9940 | 0 | 29.994000 | 2EB61058-1985-47A6-8000-0000000001BB | 2008-06-01 00:00:00 |
| 71779 | 111777 | 4 | 844 | 29.9940 | 0 | 119.976000 | 2EB61058-1985-47A6-8000-00000000003D | 2008-06-01 00:00:00 |
| 71779 | 111805 | 2 | 792 | 20.9940 | 0 | 41.988000 | 2EB61058-1985-47A6-8000-00000000014C | 2008-06-01 00:00:00 |
| 71779 | 111833 | 9 | 791 | 5.2142 | 0.0200 | 45.989244 | 2EB61058-1985-47A6-8000-0000000001A3 | 2008-06-01 00:00:00 |
| 71779 | 111861 | 1 | 870 | 149.8740 | 0 | 149.874000 | 2EB61058-1985-47A6-8000-000000000213 | 2008-06-01 00:00:00 |
| 71779 | 111889 | 2 | 681 | 1430.4420 | 0 | 2860.884000 | 2EB61058-1985-47A6-8000-000000000198 | 2008-06-01 00:00:00 |
| 71779 | 111917 | 4 | 733 | 12.1440 | 0 | 48.576000 | 2EB61058-1985-47A6-8000-000000000211 | 2008-06-01 00:00:00 |
| 71779 | 111945 | 2 | 935 | 1430.4420 | 0 | 2860.884000 | 2EB61058-1985-47A6-8000-000000000186 | 2008-06-01 00:00:00 |
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 |
|---|---|---|---|---|---|---|---|
| SalesOrderIDint | record key | Generated together with related columns | S 0% Y 0% | S 32 Y 32 | S 71774 → 71946 Y 71774 → 71929 | S 71902 9.2% · 71797 8.5% · 71936 8.5% · 71782 7.9% · 71783 7.9% · 71784 7.9% Y 71814 9.2% · 71784 8.5% · 71819 8.5% · 71789 7.9% · 71799 7.9% · 71804 7.9% | — |
| SalesOrderDetailIDint | record key | Generated together with related columns | S 0% Y 0% | S 542 Y 528 | S 110562 → 113406 Y 110562 → 113004 | S — Y — | — |
| OrderQtysmallint | quantity integer | Source values, at measured frequencies | S 0% Y 0% | S 19 Y 17 | S 1 → 25 Y 1 → 25 | S 1 23.6% · 2 19% · 3 16.8% · 4 11.1% · 5 8.5% · 6 6.5% Y 1 24.9% · 2 18.6% · 3 17.9% · 4 10.3% · 5 10.1% · 6 6.5% | 0.03 KS |
| ProductIDint | record key | Foreign key, from the measured relationship | S 0% Y 0% | S 142 Y 142 | S 707 → 999 Y 681 → 969 | S — Y — | 0.327 KS |
| UnitPricemoney | monetary amount | Source values, at measured frequencies | S 0% Y 0% | S 64 Y 59 | S 1.3740 → 1466.0100 Y 1.3740 → 1466.0100 | S 445.4100 5.9% · 1430.4420 5.7% · 323.9940 4.6% · 32.3940 4.4% · 112.9980 3.5% · 29.9940 3.5% Y 445.4100 7.9% · 323.9940 6.5% · 1430.4420 5.5% · 5.3940 4.6% · 32.3940 4.4% · 29.9940 3.7% | 0.039 KS |
| UnitPriceDiscountmoney | percentage | Generated together with related columns | S 0% Y 0% | S 5 Y 4 | S 0 → 0.4000 Y 0 → 0.4000 | S 0.0000 92.1% · 0.4000 3.5% · 0.0200 2.8% · 0.0500 1.5% · 0.1000 0.2% Y 0.0000 94.3% · 0.4000 3% · 0.0200 2.4% · 0.0500 0.4% | 0.022 KS |
| LineTotalnumeric(38,6) | monetary amount | Computed by the database | S 0% Y 0% | S 259 Y 270 | S 2.994000 → 19136.137500 Y 2.748000 → 25514.850000 | S — Y — | 0.052 KS |
| rowguiduniqueidentifier | uuid | New key values | S 0% Y 0% | S 542 Y 542 | S 36 chars avg Y 36 chars avg | S — Y — | — |
| ModifiedDatedatetime | lifecycle timestamp | Times from the measured distribution | S 0% Y 0% | S 1 Y 1 | S 2008-06-01 00:00:00 → 2008-06-01 00:00:00 Y 2008-06-01 00:00:00 → 2008-06-01 00:00:00 | S 2008-06-01 00:00:00 100% Y 2008-06-01 00:00:00 100% | 0 KS |