cloud_library_availability

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
cloudLibraryId VARCHAR 25 null
totalCopies SMALLINT 5 0
sharedCopies SMALLINT 5 0
totalLoanCopies SMALLINT 5 0
totalHoldCopies SMALLINT 5 0
sharedLoanCopies SMALLINT 5 0
rawChecksum BIGINT 19 NULL
rawResponse LONGTEXT 2147483647 NULL
lastChange INT 10 null
settingId INT 10 NULL
availabilityType SMALLINT 5 1
typeRawChecksum BIGINT 19 NULL
typeRawResponse MEDIUMTEXT 16777215 NULL

Indexes

Constraint Name Type Sort Column(s)
cloud_library_availability_s_pk Primary key Asc id
cloudLibraryId Must be unique Asc/Asc cloudLibraryId + settingId
lastChange Performance Asc lastChange
PRIMARY Must be unique Asc id

Relationships