SAM-MetaCat mapping

	C	D	E	F	G	H
1
2	MetaCat		SAM
3		data type		join
4	File ID	text	string(data_files.file_id)
5	namespace	text	file_rucio_scopes.scope or 'default'
6	name	text	data_files.name
7
8	Metadata attributes
9	core.application.version	text	application_families.version		move from core to config?
10	core.application.family	text	application_families.family		move from core to config?
11	core.application.name	text	application_families.appl_name		move from core to config?
12	core.application	text	application_families.family \|\| '.' \|\| application_families.appl_name		move from core to config?
13	core.event_count	int	data_files.event_count
14	core.first_event_number	int	data_files.first_event_number		optional
15	core.last_event_number	int	data_files.last_event_number		optional
16	core.start_rime	int	epoch(data_files.start_time)
17	core.end_time	int	epoch(data_files.end_time)
18	core.file_content_status		file_content_statuses.file_content_status
19	core.data_stream	text	datastreams.datastream_name
20	core.data_tier	text	data_tiers.data_tier
21	core.events		dune.events		optional
22	core.file_type	text	file_types.file_type_desc
23	core.file_format	text	file_formats.file_format
24	core.run_type	text	run_types.run_type	data_files, data_files_runs, runs, run_types
25	core.runs	array	runs.run_number	data_files, data_files_runs, runs
26	core.runs_subruns	array	runs.run_number * 100000 + data_files_runs.subrun_number	data_files, data_files_runs, runs
27
28	File attributes
29	creator	username, text	data_files.create_user
30	created_timestamp	timestamp	data_files.create_timestamp
31	size	int	data_files.size
32	checksums	dictionary	data_files.checksum	data_files, checksums, checksum_types
33
34	Dimensions attributes
35	<category>.<name>		category: param_categories.param_category
36			name: param_types.param_type
37				integers: data_files, num_data_files_param_values, param_types, data_types, param_categories
38	Other info			floats: data_files, num_data_files_param_values, param_types, data_types, param_categories
39
40
41
42
43	History
44	update_date	timestamp	update_date
45	update_user	username,text	update_user
46	update_comment	possible blob?
47
48
49	Retention/access keys
50	retention.status		does not come from SAM
51	retention.class		does not come from SAM
52
53
54	legacy samweb stuff?		HMS - suggest that upload the full legacy samweb MD to legacy.<category>.<name> so that we aren			strings: data_files, data_types_param_values, param_values, param_types, data_types, param_categories
55			t forced to reproduce that full structure in future files. Or possibly a second metadata object called samweb...
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100