hoopla_scopes

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
name VARCHAR 50 null
includeEBooks TINYINT 3 √ 1
maxCostPerCheckoutEBooks FLOAT 12 √ 5
includeEComics TINYINT 3 √ 1
maxCostPerCheckoutEComics FLOAT 12 √ 5
includeEAudiobook TINYINT 3 √ 1
maxCostPerCheckoutEAudiobook FLOAT 12 √ 5
includeMovies TINYINT 3 √ 1
maxCostPerCheckoutMovies FLOAT 12 √ 5
includeMusic TINYINT 3 √ 1
maxCostPerCheckoutMusic FLOAT 12 √ 5
includeTelevision TINYINT 3 √ 1
maxCostPerCheckoutTelevision FLOAT 12 √ 5
restrictToChildrensMaterial TINYINT 3 √ 0
ratingsToExclude VARCHAR 100 √ NULL
excludeAbridged TINYINT 3 √ 0
excludeParentalAdvisory TINYINT 3 √ 0
excludeProfanity TINYINT 3 √ 0
settingId INT 10 √ NULL
excludeTitlesWithCopiesFromOtherVendors TINYINT 3 √ 0
includeBingePass TINYINT 3 √ 1
maxCostPerCheckoutBingePass FLOAT 12 √ 5
genresToExclude LONGTEXT 2147483647 √ NULL

Indexes

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

Relationships