datasetlocations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dataset_id INT 10 null
datasets.id datasetlocations_ibfk_1 C
location_id INT 10 null
locations.id datasetlocations_ibfk_2 C
created_on DATETIME 19 √ CURRENT_TIMESTAMP
updated_on TIMESTAMP 19 √ CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc dataset_id + location_id
location_id Performance Asc location_id

Relationships

Close relationships within degrees of separation