user_list_entry

19 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
sourceId VARCHAR 50 null
listId INT 10 √ NULL
notes LONGTEXT 2147483647 √ NULL
dateAdded INT 10 √ NULL
weight INT 10 √ NULL
source VARCHAR 20 'GroupedWork'
importedFrom VARCHAR 20 √ NULL
title VARCHAR 50 √ ''

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
groupedWorkPermanentId Performance Asc sourceId
listId Performance Asc listId
source Performance Asc/Asc source + sourceId

Relationships