Page History

...

Column names like item_id or community_id have been mostly replaced with the tuple (resource_id, resource_type_id) where resource_type_id is a constant specifying object type:

SELECT text_value FROM metadatavalue
JOIN handle as h ON h.resource_id = metadatavalue.dspace_object_id
WHERE metadata_field_id = (
  SELECT metadata_field_id
  FROM metadatafieldregistry mfr, metadataschemaregistry msr
  WHERE mfr.metadata_schema_id = msr.metadata_schema_id
  AND short_id = 'dc'
  AND element = 'title'
  AND qualifier IS NULL
)
AND resource_type_id=2;

...

Example eperson table in DSpace 4 (simplified to show only relevant parts):

Example eperson and metadatavalue tables in DSpace 5 (simplified to show only relevant parts):

eperson:

metadatavalue:

See also

...