ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Tables (9)
2
NameTypeSchema
3
AlbumArtCREATE TABLE "AlbumArt" ( id INTEGER PRIMARY KEY AUTOINCREMENT, hash TEXT,
albumArt BLOB )
4
idINTEGER"id" INTEGER
5
hashTEXT"hash" TEXT
6
albumArtBLOB"albumArt" BLOB
7
InformationCREATE TABLE Information ( id INTEGER PRIMARY KEY AUTOINCREMENT, uuid TEXT,
schemaVersionMajor INTEGER, schemaVersionMinor INTEGER, schemaVersionPatch INTEGER, currentPlayedIndiciator INTEGER,
lastRekordBoxLibraryImportRea dCounter INTEGER )
8
idINTEGER"id" INTEGER
9
uuidTEXT"uuid" TEXT
10
schemaVersionMajorINTEGER"schemaVersionMajor" INTEGER
11
schemaVersionMinorINTEGER"schemaVersionMinor" INTEGER
12
schemaVersionPatchINTEGER"schemaVersionPatch" INTEGER
13
currentPlayedIndiciatorINTEGER"currentPlayedIndiciator" INTEGER
14
lastRekordBoxLibraryImpo rtReadCounterINTEGER"lastRekordBoxLibraryImportReadCount er" INTEGER
15
PackCREATE TABLE Pack ( id INTEGER PRIMARY KEY AUTOINCREMENT, packId TEXT,
changeLogDatabaseUuid TEXT, changeLogId INTEGER , lastPackTime DATETIME)
16
idINTEGER"id" INTEGER
17
NameTypeSchema
18
packIdTEXT"packId" TEXT
19
changeLogDatabaseUuidTEXT"changeLogDatabaseUuid" TEXT
20
changeLogIdINTEGER"changeLogId" INTEGER
21
lastPackTimeDATETIME"lastPackTime" DATETIME
22
PlaylistCREATE TABLE Playlist ( id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT,
parentListId INTEGER, isPersisted BOOLEAN, nextListId INTEGER, lastEditTime DATETIME, isExplicitlyExported BOOLEAN, CONSTRAINT C_NAME_UNIQUE_FOR_PARENT
UNIQUE (title, parentListId), CONSTRAINT C_NEXT_LIST_ID_UNIQUE_FOR_PAR
ENT UNIQUE (parentListId, nextListId) )
23
idINTEGER"id" INTEGER
24
titleTEXT"title" TEXT
25
parentListIdINTEGER"parentListId" INTEGER
26
isPersistedBOOLEAN"isPersisted" BOOLEAN
27
nextListIdINTEGER"nextListId" INTEGER
28
lastEditTimeDATETIME"lastEditTime" DATETIME
29
isExplicitlyExportedBOOLEAN"isExplicitlyExported" BOOLEAN
30
PlaylistEntityCREATE TABLE PlaylistEntity ( id INTEGER PRIMARY KEY AUTOINCREMENT, listId INTEGER, trackId INTEGER,
databaseUuid TEXT, nextEntityId INTEGER, membershipReference INTEGER, CONSTRAINT
31
NameTypeSchema
32
C_NAME_UNIQUE_FOR_LIST UNIQUE
(listId, databaseUuid, trackId), FOREIGN KEY (listId) REFERENCES Playlist (id) ON DELETE CASCADE )
33
idINTEGER"id" INTEGER
34
listIdINTEGER"listId" INTEGER
35
trackIdINTEGER"trackId" INTEGER
36
databaseUuidTEXT"databaseUuid" TEXT
37
nextEntityIdINTEGER"nextEntityId" INTEGER
38
membershipReferenceINTEGER"membershipReference" INTEGER
39
PreparelistEntityCREATE TABLE
PreparelistEntity ( id INTEGER PRIMARY KEY AUTOINCREMENT, trackId
INTEGER, trackNumber INTEGER, FOREIGN KEY (trackId) REFERENCES Track (id) ON DELETE CASCADE )
40
idINTEGER"id" INTEGER
41
trackIdINTEGER"trackId" INTEGER
42
trackNumberINTEGER"trackNumber" INTEGER
43
SmartlistCREATE TABLE Smartlist ( listUuid TEXT NOT NULL PRIMARY KEY, title TEXT,
parentPlaylistPath TEXT, nextPlaylistPath TEXT, nextListUuid TEXT, rules TEXT, lastEditTime DATETIME, CONSTRAINT C_NAME_UNIQUE_FOR_PARENT
UNIQUE (title, parentPlaylistPath), CONSTRAINT C_NEXT_LIST_UNIQUE_FOR_PARENT
44
NameTypeSchema
45
UNIQUE (parentPlaylistPath, nextPlaylistPath, nextListUuid) )
46
listUuidTEXT"listUuid" TEXT NOT NULL
47
titleTEXT"title" TEXT
48
parentPlaylistPathTEXT"parentPlaylistPath" TEXT
49
nextPlaylistPathTEXT"nextPlaylistPath" TEXT
50
nextListUuidTEXT"nextListUuid" TEXT
51
rulesTEXT"rules" TEXT
52
lastEditTimeDATETIME"lastEditTime" DATETIME
53
TrackCREATE TABLE Track ( id INTEGER PRIMARY KEY
AUTOINCREMENT, playOrder INTEGER, length INTEGER, bpm INTEGER, year INTEGER, path TEXT, filename TEXT, bitrate INTEGER, bpmAnalyzed REAL, albumArtId INTEGER, fileBytes INTEGER, title TEXT, artist TEXT, album TEXT, genre TEXT, comment TEXT, label TEXT, composer TEXT, remixer TEXT, key INTEGER, rating INTEGER, albumArt TEXT, timeLastPlayed DATETIME, isPlayed BOOLEAN,
fileType TEXT, isAnalyzed BOOLEAN, dateCreated DATETIME, dateAdded DATETIME,
isAvailable BOOLEAN, isMetadataOfPackedTrackChange d BOOLEAN,
isPerfomanceDataOfPackedTrack Changed BOOLEAN, playedIndicator INTEGER, isMetadataImported BOOLEAN, pdbImportKey INTEGER,
54
55
NameTypeSchema
56
streamingSource TEXT, uri TEXT, isBeatGridLocked BOOLEAN, originDatabaseUuid TEXT, originTrackId INTEGER, trackData BLOB, overviewWaveFormData BLOB, beatData BLOB, quickCues BLOB, loops BLOB, thirdPartySourceId INTEGER, streamingFlags INTEGER, explicitLyrics BOOLEAN, activeOnLoadLoops INTEGER, lastEditTime DATETIME, CONSTRAINT
C_originDatabaseUuid_originTr ackId UNIQUE (originDatabaseUuid, originTrackId), CONSTRAINT C_path UNIQUE (path), FOREIGN KEY (albumArtId) REFERENCES AlbumArt (id) ON DELETE RESTRICT )
57
idINTEGER"id" INTEGER
58
playOrderINTEGER"playOrder" INTEGER
59
lengthINTEGER"length" INTEGER
60
bpmINTEGER"bpm" INTEGER
61
yearINTEGER"year" INTEGER
62
pathTEXT"path" TEXT
63
filenameTEXT"filename" TEXT
64
bitrateINTEGER"bitrate" INTEGER
65
bpmAnalyzedREAL"bpmAnalyzed" REAL
66
albumArtIdINTEGER"albumArtId" INTEGER
67
fileBytesINTEGER"fileBytes" INTEGER
68
titleTEXT"title" TEXT
69
artistTEXT"artist" TEXT
70
albumTEXT"album" TEXT
71
genreTEXT"genre" TEXT
72
commentTEXT"comment" TEXT
73
labelTEXT"label" TEXT
74
composerTEXT"composer" TEXT
75
remixerTEXT"remixer" TEXT
76
keyINTEGER"key" INTEGER
77
ratingINTEGER"rating" INTEGER
78
albumArtTEXT"albumArt" TEXT
79
timeLastPlayedDATETIME"timeLastPlayed" DATETIME
80
isPlayedBOOLEAN"isPlayed" BOOLEAN
81
fileTypeTEXT"fileType" TEXT
82
isAnalyzedBOOLEAN"isAnalyzed" BOOLEAN
83
dateCreatedDATETIME"dateCreated" DATETIME
84
dateAddedDATETIME"dateAdded" DATETIME
85
isAvailableBOOLEAN"isAvailable" BOOLEAN
86
isMetadataOfPackedTrack ChangedBOOLEAN"isMetadataOfPackedTrackChanged" BOOLEAN
87
isPerfomanceDataOfPack edTrackChangedBOOLEAN"isPerfomanceDataOfPackedTrackChan ged" BOOLEAN
88
playedIndicatorINTEGER"playedIndicator" INTEGER
89
isMetadataImportedBOOLEAN"isMetadataImported" BOOLEAN
90
pdbImportKeyINTEGER"pdbImportKey" INTEGER
91
streamingSourceTEXT"streamingSource" TEXT
92
uriTEXT"uri" TEXT
93
isBeatGridLockedBOOLEAN"isBeatGridLocked" BOOLEAN
94
originDatabaseUuidTEXT"originDatabaseUuid" TEXT
95
originTrackIdINTEGER"originTrackId" INTEGER
96
trackDataBLOB"trackData" BLOB
97
overviewWaveFormDataBLOB"overviewWaveFormData" BLOB
98
beatDataBLOB"beatData" BLOB
99
quickCuesBLOB"quickCues" BLOB
100
loopsBLOB"loops" BLOB