Select Code to Download

image_properties      file                        mp3_properties
id    INTEGER     --> id        INTEGER       <-- id         INTEGER
width INTEGER         name      VARCHAR(1024)     playlength INTEGER
height INTEGER        size      INTEGER           artist     VARCHAR(1
+024)
                      mime_type VARCHAR(64)

file_denormalized
id        INTEGER PRIMARY KEY
...
-- image properties
width INTEGER                  
height INTEGER