The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
NATG / Data-Babel-1.12_01 / t / babel.044.pdups_hand / pdups_hand.data_nulls_history.ini 
##### defines data for handcrafted database with pseudo-duplicates
# adapted from babel.040.translate_hand

[maptable_001]
data=<<DATA
type_001/a_001 type_002/a_001
type_001/a_111 type_002/a_111
type_001/a_001 NULL
type_001/a_111 NULL
NULL	type_002/a_001
NULL	type_002/a_111
DATA

[maptable_002]
data=<<DATA
type_001/a_001	multi_001
type_001/a_111	multi_001
type_001/a_001	multi_002
type_001/a_111	multi_002
type_001/a_001	NULL
type_001/a_111	NULL
NULL	       multi_001
NULL	       multi_002
DATA

[maptable_003]
data=<<DATA
multi_001	type_003/a_001
multi_001	type_003/a_111
multi_001	NULL
NULL	type_003/a_001
NULL	type_003/a_111
DATA

[maptable_004]
data=<<DATA
type_003/a_001	multi_001
type_003/a_111	multi_001
type_003/a_001	multi_002
type_003/a_111	multi_002
type_003/a_001	NULL
type_003/a_010	NULL
type_003/a_111	NULL
NULL	       multi_001
NULL	       multi_002
DATA

[maptable_005]
data=<<DATA
multi_001	type_004/a_001
multi_001	type_004/a_111
NULL	type_004/a_001
NULL	type_004/a_111
multi_001	NULL
DATA

### these guys are deliberately simple - 1:1 histories

[type_001_master]
data=<<DATA
type_001/x_000 type_001/a_000
type_001/x_001 type_001/a_001
type_001/x_111 type_001/a_111
DATA

[type_002_master]
data=<<DATA
type_002/x_000 type_002/a_000
type_002/x_001 type_002/a_001
type_002/x_111 type_002/a_111
DATA

# correct ur selections
[ur1_select]
data=<<DATA
type_001/a_001	type_002/a_001	type_003/a_001	type_004/a_001	type_001/x_001	type_002/x_001
type_001/a_001	type_002/a_001	type_003/a_001	type_004/a_111	type_001/x_001	type_002/x_001
type_001/a_001	type_002/a_001	type_003/a_001	NULL	type_001/x_001	type_002/x_001
type_001/a_001	NULL	type_003/a_001	type_004/a_001	type_001/x_001	NULL
type_001/a_001	NULL	type_003/a_001	type_004/a_111	type_001/x_001	NULL
type_001/a_001	NULL	type_003/a_001	NULL	type_001/x_001	NULL
DATA

[ur2_select]
data=<<DATA
type_001/a_111	type_002/a_111	type_003/a_111	type_004/a_001	type_001/x_111	type_002/x_111
type_001/a_111	type_002/a_111	type_003/a_111	type_004/a_111	type_001/x_111	type_002/x_111
type_001/a_111	type_002/a_111	type_003/a_111	NULL	type_001/x_111	type_002/x_111
type_001/a_111	NULL	type_003/a_111	type_004/a_001	type_001/x_111	NULL
type_001/a_111	NULL	type_003/a_111	type_004/a_111	type_001/x_111	NULL
type_001/a_111	NULL	type_003/a_111	NULL	type_001/x_111	NULL
DATA

# correct ur translations. type_001 repeated because it's input idtype
[ur1_translate]
data=<<DATA
type_001/x_001	type_001/a_001	type_002/a_001	type_003/a_001	type_004/a_001
type_001/x_001	type_001/a_001	type_002/a_001	type_003/a_001	type_004/a_111
DATA

[ur2_translate]
data=<<DATA
type_001/x_111	type_001/a_111	type_002/a_111	type_003/a_111	type_004/a_001
type_001/x_111	type_001/a_111	type_002/a_111	type_003/a_111	type_004/a_111
DATA