system_variables

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
errorEmail VARCHAR 128 NULL
ticketEmail VARCHAR 128 NULL
searchErrorEmail VARCHAR 128 NULL
loadCoversFrom020z TINYINT 3 0
runNightlyFullIndex TINYINT 3 0
currencyCode CHAR 3 'USD'
allowableHtmlTags VARCHAR 512 'p|div|span|a|b|em|strong|i|ul|ol|li|br|h1|h2|h3|h4|h5|h6'
allowHtmlInMarkdownFields TINYINT 3 1
useHtmlEditorRatherThanMarkdown TINYINT 3 1
storeRecordDetailsInSolr TINYINT 3 0
storeRecordDetailsInDatabase TINYINT 3 1
greenhouseUrl VARCHAR 128 NULL
libraryToUseForPayments TINYINT 3 0
solrConnectTimeout INT 10 2
solrQueryTimeout INT 10 10
catalogStatus TINYINT 3 0
offlineMessage TEXT 65535 NULL
indexVersion INT 10 2
searchVersion INT 10 1
regroupAllRecordsDuringNightlyIndex TINYINT 3 0
processEmptyGroupedWorks TINYINT 3 1
appScheme VARCHAR 72 'aspen-lida'
googleBucket VARCHAR 128 NULL
trackIpAddresses TINYINT 3 0
communityContentUrl VARCHAR 128 ''
allowScheduledUpdates TINYINT 3 1
doQuickUpdates TINYINT 3 0
supportingCompany VARCHAR 72 'ByWater Solutions'
monitorAntivirus TINYINT 3 1
enableBrandedApp TINYINT 3 0
enableNovelistSeriesIntegration TINYINT 3 1

Indexes

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

Relationships