open_archives_collection

11 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 BOOLEAN 3 √ 1
imageRegex TEXT 65535 √ NULL
deleted BOOLEAN 3 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships