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

##</code><code>##

file_denormalized
id        INTEGER PRIMARY KEY
-- file properties
name      VARCHAR(1024)           
size      INTEGER
mime_type VARCHAR(64)
-- mp3 properties
playlength INTEGER
artist     VARCHAR(1024)
-- image properties
width INTEGER                  
height INTEGER