ip_lookup

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
locationid INT 10 null
location VARCHAR 255 null
ip VARCHAR 255 null
startIpVal BIGINT 19 √ NULL
endIpVal BIGINT 19 √ NULL
isOpac TINYINT UNSIGNED 3 1
blockAccess TINYINT 3 0
allowAPIAccess TINYINT 3 0
showDebuggingInformation TINYINT 3 0
logTimingInformation TINYINT 3 √ 0
logAllQueries TINYINT 3 √ 0
defaultLogMeOutAfterPlacingHoldOn BOOLEAN 3 √ 1
authenticatedForEBSCOhost TINYINT 3 √ 0
blockedForSpam TINYINT 3 √ 0
masqueradeMode BOOLEAN 3 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
endIpVal Performance Asc endIpVal
endIpVal_2 Performance Asc endIpVal
startIpVal Performance Asc startIpVal
startIpVal_2 Performance Asc startIpVal

Relationships