biblio_metadata

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
biblionumber INT 10 null
biblio.biblionumber record_metadata_fk_1 C
format VARCHAR 16 null
schema VARCHAR 16 null
metadata LONGTEXT 2147483647 null
timestamp TIMESTAMP 19 current_timestamp()
record_source_id INT 10 null
record_sources.record_source_id record_metadata_fk_2 C

The record source for the metadata

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
biblio_metadata_uniq_key Must be unique Asc/Asc/Asc biblionumber + format + schema
record_metadata_fk_2 Performance Asc record_source_id
timestamp Performance Asc timestamp

Relationships