ils_records

90214 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
ilsId VARCHAR 50 null
checksum BIGINT UNSIGNED 20 null
dateFirstDetected BIGINT 19 √ NULL
source VARCHAR 50 'ils'
deleted BOOLEAN 3 √ NULL
dateDeleted INT 10 √ NULL
suppressedNoMarcAvailable BOOLEAN 3 √ NULL
sourceData MEDIUMBLOB 16777215 √ NULL
lastModified INT 10 √ NULL
suppressed BOOLEAN 3 √ 0
suppressionNotes TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_ils_records_ilsid Performance Asc ilsId
source Must be unique Asc/Asc source + ilsId

Relationships