open_archives_collection

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
name VARCHAR 100 null
baseUrl VARCHAR 255 null
setName VARCHAR 100 null
fetchFrequency enum('hourly', 'daily', 'weekly', 'monthly', 'yearly', 'once') 7 NULL
lastFetched INT 10 NULL
subjectFilters LONGTEXT 2147483647 NULL
subjects LONGTEXT 2147483647 NULL
loadOneMonthAtATime TINYINT 3 1
imageRegex TEXT 65535 NULL
deleted TINYINT 3 0
defaultCover VARCHAR 100 ''
metadataFormat VARCHAR 10 'oai_dc'
indexAllSets TINYINT 3 0

Indexes

Constraint Name Type Sort Column(s)
open_archives_collection_s_pk Primary key Asc id
PRIMARY Must be unique Asc id

Relationships