ils_record_usage

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
indexingProfileId INT 10 null
recordId VARCHAR 36 NULL
year INT 10 null
month INT 10 null
timesUsed INT 10 null
pdfDownloadCount INT 10 0
supplementalFileDownloadCount INT 10 0
pdfViewCount INT 10 0
instance VARCHAR 100 NULL

Indexes

Constraint Name Type Sort Column(s)
ils_record_usage_s_pk Primary key Asc id
instance Must be unique Asc/Asc/Asc/Asc/Asc instance + indexingProfileId + recordId + year + month
PRIMARY Must be unique Asc id
year Performance Asc/Asc year + month

Relationships