MySQL · Chinook

MediaType

Source rows: 5
Synthetic rows: 5
Broken foreign keys: No foreign keys
Rows equal to a source row: 100%

Every synthetic row matches a source row outside its keys. Kept reference data and resampled source values match by design, and columns with few possible values can match by chance: see how each column was generated below. You can review, replace or remove kept values before you publish a profile.

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.

MediaTypeId key	Name
Source database · 5 of 5 rows
1	MPEG audio file
2	Protected AAC audio file
3	Protected MPEG-4 video file
4	Purchased AAC audio file
5	AAC audio file
Synthetic database · 5 of 5 rows
1	MPEG audio file
2	Protected AAC audio file
3	Protected MPEG-4 video file
4	Purchased AAC audio file
5	AAC audio file

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
MediaTypeIdint	record key	New key values	S 0% Y 0%	S 5 Y 5	S 1 → 5 Y 1 → 5	S 1 20% · 2 20% · 3 20% · 4 20% · 5 20% Y 1 20% · 2 20% · 3 20% · 4 20% · 5 20%	—
Namevarchar(120)	title name	Kept from the source as reference data	S 0% Y 0%	S 5 Y 5	S 20.8 chars avg Y 20.8 chars avg	S MPEG audio file 20% · Protected AAC audio file 20% · Protected MPEG-4 video file 20% · Purchased AAC audio file 20% · AAC audio file 20% Y MPEG audio file 20% · Protected AAC audio file 20% · Protected MPEG-4 video file 20% · Purchased AAC audio file 20% · AAC audio file 20%	0 TVD