overdrive_api_product_formats

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
productId INT 10 √ NULL
textId VARCHAR 25 √ NULL
numericId INT 10 √ NULL
name VARCHAR 512 √ NULL
fileName VARCHAR 215 √ NULL
fileSize INT 10 √ NULL
partCount SMALLINT 5 √ NULL
sampleSource_1 VARCHAR 215 √ NULL
sampleUrl_1 VARCHAR 215 √ NULL
sampleSource_2 VARCHAR 215 √ NULL
sampleUrl_2 VARCHAR 215 √ NULL

Indexes

Constraint Name Type Sort Column(s)
overdrive_api_product_formats_s_pk Primary key Asc id
numericId Performance Asc numericId
PRIMARY Must be unique Asc id
productId Performance Asc productId
productId_2 Must be unique Asc/Asc productId + textId

Relationships

Close relationships within degrees of separation