image_uploads

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
hero_slider_playlist_image.imageId hero_slider_playlist_image_ibfk_2 C
title VARCHAR 255 null
fullSizePath VARCHAR 512 null
generateMediumSize TINYINT 3 0
mediumSizePath VARCHAR 512 √ NULL
generateSmallSize TINYINT 3 0
smallSizePath VARCHAR 512 √ NULL
type VARCHAR 25 null
generateLargeSize TINYINT 3 1
largeSizePath VARCHAR 512 √ ''
generateXLargeSize TINYINT 3 1
xLargeSizePath VARCHAR 512 √ ''
owningLibrary INT 10 -1
sharing INT 10 2
sharedWithLibrary INT 10 -1
deleted TINYINT 3 √ 0
dateDeleted INT 10 √ 0
deletedBy INT 10 √ NULL
aspectRatioWidth INT 10 √ NULL
aspectRatioHeight INT 10 √ NULL
calculatedAspectRatio DECIMAL 10,6 √ NULL
altText VARCHAR 512 √ NULL
pageLink VARCHAR 512 √ NULL
startDate INT 10 √ 0
endDate INT 10 √ 0

Indexes

Constraint Name Type Sort Column(s)
image_uploads_s_pk Primary key Asc id
aspectRatio Performance Asc/Asc aspectRatioWidth + aspectRatioHeight
dateRange Performance Asc/Asc startDate + endDate
PRIMARY Must be unique Asc id
type Performance Asc/Asc type + title

Relationships

Close relationships within degrees of separation