Database Structure: Difference between revisions

From MediaMonkey Wiki
Jump to navigation Jump to search
No edit summary
 
No edit summary
Line 1: Line 1:
[[Image:MonkeyBar.gif]]
==MediaMonkey v3.0 and higher==
 
-- no info yet --
 
MediaMonkey 3 and it's database structure are in development.
 
 
 
==MediaMonkey v2.5 and lower==
 
===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]
 
 
===AddSongInfo===
''Value field is "TextData"''
 
 
'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || Music Composer
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}
 
 
===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)
 
 
'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>
 
 
 
===Memos===
''Value field is "MemoText"''
 
 
'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

Revision as of 00:48, 22 April 2007

MediaMonkey v3.0 and higher

-- no info yet --

MediaMonkey 3 and it's database structure are in development.


MediaMonkey v2.5 and lower

Database structure


AddSongInfo

Value field is "TextData"


DataType

Value AIF Code Description
100 AIF_COPYRIGHT Copyright
101 AIF_PUBLISHER Publisher
102 AIF_ENCODER Encoder
103 AIF_ENCODEDBY Encoded By
200 AIF_LYRICIST Lyricist
201 AIF_BAND Band
202 AIF_CONDUCTOR Conductor
203 AIF_REMIXER Remixer
204 AIF_INVOLVEDPEOPLE Involved People
205 AIF_MUSICCOMPOSER Music Composer
300 AIF_ORIGTITLE Original Title
301 AIF_ORIGARTIST Original Artist
302 AIF_ORIGLYRICIST Original Lyricist
400 AIF_GROUPDESC
401 AIF_SUBTITLE
402 AIF_ISRC
500 AIF_INITIALKEY
501 AIF_LANGUAGE
502 AIF_MEDIATYPE
503 AIF_RATINGSTRING
1000 AIF_WEB_COMMERCIAL
1001 AIF_WEB_COPYRIGHT
1002 AIF_WEB_FILEPAGE
1003 AIF_WEB_ARTIST
1004 AIF_WEB_SOURCE
1005 AIF_WEB_RADIO
1006 AIF_WEB_PAYMENT
1007 AIF_WEB_PUBLISHER
1100 AIF_WEB_USER


AddSongInfoInt

Value field is "IntData" (linked to Lists.ID)


DataType (partially linked to Lists.IDListType)

Value AIF Code Description
10000 AIF_ORIGYEAR Original Year
10101 AIF_TEMPO Tempo
10102 AIF_MOOD Mood
10103 AIF_OCCASION Occasion
10104 AIF_QUALITY Quality

<references/>


Memos

Value field is "MemoText"


MemoType

Value AIF Code Description
20000 AIF_LYRICS Lyrics
20001 AIF_COMMENT Comment
Retrieved from "https://www.mediamonkey.com/wiki/index.php?title=Database_Structure&oldid=2551"