musicminer-schema
Table Name OM Class Description
MM_USER User  
GENRE Genre  
LABEL Label  
MEDIA Media  
MIMETYPE Mimetype  
LOCATION Location  
QUALITY Quality  
RATING Rating  
SONG Song  
AUDIO_FILE AudioFile  
SONG_HAS_GENRE SongHasGenre  
PLAYLIST Playlist  
PLAYLIST_HAS_GENRE PlaylistHasGenre  
ARTIST Artist  
ARTIST_HAS_GENRE ArtistHasGenre  
ARTIST_IN_BAND ArtistInBand  
ARTIST_RESEMBLES_ARTIST ArtistResemblesArtist  
SONG_PERFORMED_BY_ARTIST SongPerformedByArtist  
SONG_COMPOSED_BY_ARTIST SongComposedByArtist  
SONG_LYRICS_BY_ARTIST SongLyricsByArtist  
PLAYLIST_PERFORMED_BY_ARTIST PlaylistPerformedByArtist  
PLAYLIST_COMPOSED_BY_ARTIST PlaylistComposedByArtist  
SONG_ON_PLAYLIST SongOnPlaylist  
PLAYLIST_ON_PLAYLIST PlaylistOnPlaylist  
WEBSITE Website  
ARTIST_HAS_WEBSITE ArtistHasWebsite  
USER_PLAYS_SONG UserPlaysSong  
USER_PLAYS_PLAYLIST UserPlaysPlaylist  
USER_RATES_SONG UserRatesSong  
USER_RATES_PLAYLIST UserRatesPlaylist  
FEATURE Feature  
SONG_HAS_FEATURE SongHasFeature  
MUSIC_MAP MusicMap  
MUSIC_MAP_USES_FEATURE MusicMapUsesFeature  
SONG_BESTMATCH SongBestmatch  
SONG_GROUPING SongGrouping  
SONG_GROUP SongGroup  
SONG_IN_GROUP SongInGroup  
SONG_LIKE_SONG SongLikeSong  
DESCRIPTION Description  
SONG_HAS_DESCRIPTION SongHasDescription  

MM_USER

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (50)   Name
 
 
X
 
PASSWORD VARCHAR (50)   Password
 
 
 
 

GENRE

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (50)   Name
 
 
X
 

LABEL

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (50)   Name
 
 
X
 

MEDIA

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (255)   Name
 
 
X
 
LOCATION_ID INTEGER     LocationId
 
X
 
 

MIMETYPE

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (255)   Name
 
 
X
 
MIME VARCHAR (255)   Mime
 
 
X
 

LOCATION

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (255)   Name
 
 
X
 

QUALITY

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
RANK INTEGER     Rank
 
 
X
 
NAME VARCHAR (255)   Name
 
 
X
 

RATING

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
RANK INTEGER     Rank
 
 
X
 
NAME VARCHAR (255)   Name
 
 
X
 

SONG

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (255)   Name
 
 
X
 
PLAYTIME INTEGER     Playtime
 
 
X
 
ADDED DATE     Added
 
 
X
 
SHARED BIT     Shared
 
 
X
 
SUBMITTED BIT     Submitted
 
 
X
 
RELEASE_YEAR INTEGER     Year
 
 
 
 
COMMENT VARCHAR (255)   Comment
 
 
 
 
LYRICS BINARY     Lyrics
 
 
 
 
ARTIST_ID INTEGER     ArtistId
 
X
 
 
ALBUM_ID INTEGER     AlbumId
 
X
 
 
POS INTEGER     Position
 
 
 
 
OWNER_ID INTEGER     OwnerId
 
X
 
 
GENRE_ID INTEGER     GenreId
 
X
 
 
LABEL_ID INTEGER     LabelId
 
X
 
 

AUDIO_FILE

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
URL VARCHAR (255)   URL
 
 
X
 
AUDIO BINARY     Audio
 
 
 
 
FILESIZE INTEGER     Filesize
 
 
 
 
BITRATE VARCHAR (10)   Bitrate
 
 
 
 
CHANNELS INTEGER     Channels
 
 
 
 
SAMPLERATE INTEGER     SampleRate
 
 
 
 
VBR BIT     VBR
 
 
 
 
AFE_FAILED INTEGER     AFEFailed
 
 
 
 
MEDIA_ID INTEGER     MediaId
 
X
 
 
MIMETYPE_ID INTEGER     MimetypeId
 
X
 
 
QUALITY_ID INTEGER     QualityId
 
X
 
 
SONG_ID INTEGER     SongId
 
X
X
 

SONG_HAS_GENRE

Name Type Size Default JavaName PK FK not null Description
SONG_ID INTEGER     SongId
X
X
X
 
GENRE_ID INTEGER     GenreId
X
X
X
 

PLAYLIST

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (200)   Name
 
 
X
 
RELEASE_YEAR INTEGER     Year
 
 
 
 
FRONT_COVER BINARY     FrontCover
 
 
 
 
BACK_COVER BINARY     BackCover
 
 
 
 
COMMENT VARCHAR (255)   Comment
 
 
 
 
ARTIST_ID INTEGER     ArtistId
 
X
 
 
OWNER_ID INTEGER     OwnerId
 
X
 
 
GENRE_ID INTEGER     GenreId
 
X
 
 
LABEL_ID INTEGER     LabelId
 
X
 
 

PLAYLIST_HAS_GENRE

Name Type Size Default JavaName PK FK not null Description
PLAYLIST_ID INTEGER     PlaylistId
X
X
X
 
GENRE_ID INTEGER     GenreId
X
X
X
 

ARTIST

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (100)   Name
 
 
X
 
PATTERN VARCHAR (255)   Pattern
 
 
 
 
SORTNAME VARCHAR (255)   Sortname
 
 
 
 
GENRE_ID INTEGER     GenreId
 
X
 
 

ARTIST_HAS_GENRE

Name Type Size Default JavaName PK FK not null Description
ARTIST_ID INTEGER     ArtistId
X
X
X
 
GENRE_ID INTEGER     GenreId
X
X
X
 

ARTIST_IN_BAND

Name Type Size Default JavaName PK FK not null Description
ARTIST_ID INTEGER     ArtistId
X
X
X
 
BAND_ID INTEGER     BandId
X
X
X
 

ARTIST_RESEMBLES_ARTIST

Name Type Size Default JavaName PK FK not null Description
PARENT_ARTIST_ID INTEGER     ParentArtistId
X
X
X
 
CHILD_ARTIST_ID INTEGER     ChildArtistId
X
X
X
 

SONG_PERFORMED_BY_ARTIST

Name Type Size Default JavaName PK FK not null Description
POS INTEGER   0 Position
X
 
X
 
SONG_ID INTEGER     SongId
X
X
X
 
ARTIST_ID INTEGER     ArtistId
X
X
X
 

SONG_COMPOSED_BY_ARTIST

Name Type Size Default JavaName PK FK not null Description
SONG_ID INTEGER     SongId
X
X
X
 
ARTIST_ID INTEGER     ArtistId
X
X
X
 

SONG_LYRICS_BY_ARTIST

Name Type Size Default JavaName PK FK not null Description
SONG_ID INTEGER     SongId
X
X
X
 
ARTIST_ID INTEGER     ArtistId
X
X
X
 

PLAYLIST_PERFORMED_BY_ARTIST

Name Type Size Default JavaName PK FK not null Description
POS INTEGER   0 Position
X
 
X
 
PLAYLIST_ID INTEGER     PlaylistId
X
X
X
 
ARTIST_ID INTEGER     ArtistId
X
X
X
 

PLAYLIST_COMPOSED_BY_ARTIST

Name Type Size Default JavaName PK FK not null Description
PLAYLIST_ID INTEGER     PlaylistId
X
X
X
 
ARTIST_ID INTEGER     ArtistId
X
X
X
 

SONG_ON_PLAYLIST

Name Type Size Default JavaName PK FK not null Description
PLAYLIST_ID INTEGER     PlaylistId
X
X
X
 
POS INTEGER   0 Position
X
 
X
 
SONG_ID INTEGER     SongId
X
X
X
 

PLAYLIST_ON_PLAYLIST

Name Type Size Default JavaName PK FK not null Description
POS INTEGER   0 Position
X
 
X
 
PARENT_PLAYLIST_ID INTEGER     ParentPlaylistId
X
X
X
 
CHILD_PLAYLIST_ID INTEGER     ChildPlaylistId
X
X
X
 

WEBSITE

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (100)   Name
 
 
X
 
URL VARCHAR (200)   Url
 
 
X
 

ARTIST_HAS_WEBSITE

Name Type Size Default JavaName PK FK not null Description
ARTIST_ID INTEGER     ArtistId
X
X
X
 
WEBSITE_ID INTEGER     WebsiteId
X
X
X
 

USER_PLAYS_SONG

Name Type Size Default JavaName PK FK not null Description
USER_ID INTEGER     UserId
X
X
X
 
SONG_ID INTEGER     SongId
X
X
X
 
PLAYED_WHEN DATE     When
X
 
X
 
COMPLETED INTEGER     Completed
 
 
 
 

USER_PLAYS_PLAYLIST

Name Type Size Default JavaName PK FK not null Description
USER_ID INTEGER     UserId
X
X
X
 
PLAYLIST_ID INTEGER     PlaylistId
X
X
X
 
PLAYED_WHEN DATE     When
X
 
X
 
COMPLETED INTEGER     Completed
 
 
 
 

USER_RATES_SONG

Name Type Size Default JavaName PK FK not null Description
USER_ID INTEGER     UserId
X
X
X
 
SONG_ID INTEGER     SongId
X
X
X
 
RATING_ID INTEGER     RatingId
X
X
X
 

USER_RATES_PLAYLIST

Name Type Size Default JavaName PK FK not null Description
USER_ID INTEGER     UserId
X
X
X
 
PLAYLIST_ID INTEGER     PlaylistId
X
X
X
 
RATING_ID INTEGER     RatingId
X
X
X
 

FEATURE

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (50)   Name
 
 
 
 
VERSION VARCHAR (10)   Version
 
 
 
 
SIZE INTEGER     Size
 
 
 
 
XML BINARY     XML
 
 
 
 

SONG_HAS_FEATURE

Name Type Size Default JavaName PK FK not null Description
SONG_ID INTEGER     SongId
X
X
X
 
FEATURE_ID INTEGER     FeatureId
X
X
X
 
DATA BINARY     Data
 
 
 
 

MUSIC_MAP

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (255)   Name
 
 
X
 
GRID VARCHAR     Grid
 
 
X
 
WEIGHTS BINARY     Weights
 
 
X
 
ROWS INTEGER     Rows
 
 
X
 
COLS INTEGER     Cols
 
 
X
 
DIMENSIONS INTEGER     Dimensions
 
 
X
 
HEIGHTS BINARY     Heights
 
 
 
 
ISLAND_MASK BINARY     IslandMask
 
 
 
 
CLASS_MASK BINARY     ClassMask
 
 
 
 
BACKGROUND VARCHAR (50)   Background
 
 
 
 
GRADIENT VARCHAR (50)   Gradient
 
 
 
 
CONTOURS BIT     Contours
 
 
 
 
TILED BIT     Tiled
 
 
 
 
ZOOM INTEGER     Zoom
 
 
 
 
COLORS INTEGER     Colors
 
 
 
 
CLIP INTEGER     Clip
 
 
 
 
FOREGROUND VARCHAR (50)   Foreground
 
 
 
 
BMSIZE INTEGER     Bmsize
 
 
 
 
FRAME BIT     Frame
 
 
 
 
PLAYLIST_ID INTEGER     PlaylistId
 
X
 
 

MUSIC_MAP_USES_FEATURE

Name Type Size Default JavaName PK FK not null Description
POS INTEGER   0 Position
X
 
X
 
MUSIC_MAP_ID INTEGER     MusicMapId
X
X
X
 
FEATURE_ID INTEGER     FeatureId
X
X
X
 

SONG_BESTMATCH

Name Type Size Default JavaName PK FK not null Description
ROW INTEGER     Row
 
 
X
 
COL INTEGER     Col
 
 
X
 
SONG_ID INTEGER     SongId
X
X
X
 
MUSIC_MAP_ID INTEGER     MusicMapId
X
X
X
 

SONG_GROUPING

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (255)   Name
 
 
X
 

SONG_GROUP

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (255)   Name
 
 
X
 
COLOR INTEGER     Color
 
 
 
 
SONG_GROUPING_ID INTEGER     SongGroupingId
 
X
X
 

SONG_IN_GROUP

Name Type Size Default JavaName PK FK not null Description
SONG_GROUP_ID INTEGER     SongGroupId
X
X
X
 
SONG_ID INTEGER     SongId
X
X
X
 

SONG_LIKE_SONG

Name Type Size Default JavaName PK FK not null Description
SONG_ONE_ID INTEGER     SongOneId
X
X
X
 
SONG_TWO_ID INTEGER     SongTwoId
X
X
X
 
DISTANCE FLOAT     Distance
 
 
 
 

DESCRIPTION

Name Type Size Default JavaName PK FK not null Description
ID INTEGER     Id
X
 
X
 
NAME VARCHAR (100)   Name
 
 
 
 
ZERO VARCHAR (50)   Zero
 
 
 
 
ONE VARCHAR (50)   One
 
 
 
 
COMMENT VARCHAR (255)   Comment
 
 
 
 

SONG_HAS_DESCRIPTION

Name Type Size Default JavaName PK FK not null Description
SONG_ID INTEGER     SongId
X
X
X
 
DESCRIPTION_ID INTEGER     DescriptionId
X
X
X
 
USER_ID INTEGER     UserId
X
X
X
 
DEGREE FLOAT     Degree