Dataset-DataUnit Joins¶

The join tables in this section relate concrete DataUnit to Datasets. They thus hold the information necessary to relate DatasetRefs to Datasets.

The following direct connections exist:

$graph dataset_dataunit_joins { Visit -- Dataset Snap -- Dataset Tract -- Dataset Patch -- Dataset AbstractFilter -- Dataset PhysicalFilter -- Dataset PhysicalSensor -- Dataset }$

Note

There is no join table to relate Datasets to ObservedSensors, because the latter is itself a join table.

PhysicalFilterDatasetJoins¶

Fields:

physical_filter_name	varchar	NOT NULL
camera_name	varchar	NOT NULL
dataset_id	int	NOT NULL
registry_id	int	NOT NULL

Foreign Keys:

(physical_filter_name, camera_name) references PhysicalFilter (physical_filter_name, camera_name)
(dataset_id, registry_id) references Dataset (dataset_id, registry_id)

PhysicalSensorDatasetJoin¶

Fields:

physical_sensor_number	int	NOT NULL
camera_name	varchar	NOT NULL
dataset_id	int	NOT NULL
registry_id	int	NOT NULL

Foreign Keys:

(physical_sensor_number, camera_name) references PhysicalSensor (physical_sensor_number, camera_name)
(dataset_id, registry_id) references Dataset (dataset_id, registry_id)

VisitDatasetJoin¶

Fields:

visit_number	int	NOT NULL
camera_name	varchar	NOT NULL
dataset_id	int	NOT NULL
registry_id	int	NOT NULL

Foreign Keys:

(visit_number, camera_name) references Visit (number, camera_name)
(dataset_id, registry_id) references Dataset (dataset_id, registry_id)

SnapDatasetJoin¶

Fields:

snap_index	int	NOT NULL
visit_number	int	NOT NULL
camera_name	varchar	NOT NULL
dataset_id	int	NOT NULL
registry_id	int	NOT NULL

Foreign Keys:

(snap_index, visit_number, camera_name) references Snap (snap_index, visit_number, camera_name)
(dataset_id, registry_id) references Dataset (dataset_id, registry_id)

VisitRangeDatasetJoin¶

Fields:

visit_begin	int	NOT NULL
visit_end	int	NOT NULL
dataset_id	int	NOT NULL
registry_id	int	NOT NULL

Foreign Keys:

(visit_begin, visit_end, camera_name) references VisitRange (visit_begin, visit_end, camera_name)
(dataset_id, registry_id) references Dataset (dataset_id, registry_id)

AbstractFilterDatasetJoin¶

Fields:

abstract_filter_name	varchar	NOT NULL
dataset_id	int	NOT NULL
registry_id	int	NOT NULL

Foreign Keys:

(abstract_filter_name) references AbstractFilter (abstract_filter_name)
(dataset_id, registry_id) references Dataset (dataset_id, registry_id)

TractDatasetJoin¶

Fields:

tract_number	int	NOT NULL
skymap_name	varchar	NOT NULL
dataset_id	int	NOT NULL
registry_id	int	NOT NULL

Foreign Keys:

(tract_number, skymap_name) references Tract (number, skymap_name)
(dataset_id, registry_id) references Dataset (dataset_id, registry_id)

PatchDatasetJoin¶

Fields:

patch_index	int	NOT NULL
tract_number	int	NOT NULL
skymap_name	varchar	NOT NULL
dataset_id	int	NOT NULL
registry_id	int	NOT NULL

Foreign Keys:

(patch_index, tract_number, skymap_name) references Patch (patch_index, tract_number, skymap_name)
(dataset_id, registry_id) references Dataset (dataset_id, registry_id)