Site 'other records'

[johanvonboer]

The SEAD database contains, what I presume is supposed to be bibliographic references to other data sources for certain sites, these references are stored in the table tbl_site_other_records. However, the biblio_id column in this table is always null, and without a bibliographic reference it seems rather pointless since all it says is that there is data stored 'not in SEAD', and presumably in some other database but it does not say which one.

Here's what the table (joined with tbl_record_types for completion) looks like:

This is the SQL for the above:

SELECT *
FROM tbl_site_other_records
INNER JOIN tbl_record_types ON tbl_record_types.record_type_id = tbl_site_other_records.record_type_id

[johanvonboer]

This is 'correct' in the way that there are no biblio references, but one could possibly make the connection via the dataset references.