Reply to thread

This is a sample datamodel I designed which might fit the space between good enough and clean enough.

I would represent:

an artist (e.g. Music or Movie) as

LabelType = "Artist"

Label = "R.E.M."

additional info might be in the Artist Table (Biography etc.)

a genre as

LabelType = "Genre"

Label = "Grunge"

ParentLabel = "Rock" (sample!)

an album as

LabelType = "Album"

Label = "Automatic for the people"

ParentLabel = "R.E.M." (The Album Artist)

a directory as

LabelType = "Directory"

Label = "d:\Music\R.E.M.\Automatic for the people"

Directory.strPath = "d:\Music\R.E.M.\Automatic for the people"

a playlist as

LabelType = "Play List"

Label = "My Summer"

 --> Might need a reference to a file as well for storage or also be an item

LabelMap contains:

 map to song "Drive"

 map to picture "SomePicture_002" --> Can mix media in playlists!

a song as

Item.strName = "Drive"

File.strFileName = "01 Drive.mp3"

File.idPath.strPath = "d:\Music\R.E.M.\Automatic for the people"

LabelMap contains:

 map to Album "Automatic for the people" (Role Empty)

 map to Genre "Rock" (Role Empty)

 map to Directory "d:\Music\R.E.M.\Automatic for the people" (Role Empty)

 map to Artist R.E.M (Role Artist)

 map to Artist "Bill Berny" (Role Composer)

 map to Artist "Peter Buck" (Role Composer)

 map to Playlist "My Summer" (Role 00001), forgot to add iPosition to LabelMap

a movie as

Item.strName = "The Rock"

file.strFileName = "the_rock_cd1.iso" (File 1)

file.strFileName = "the rock_cd2.iso" (File 2)

LabelMap contains:

 map to Genre "Whatever"

 map to Artist "Michael Bay" (Role Director)

 map to Artist "Sean Connery" (Role Actor)

...

a TV Channel as

Item.strName = "CNN International"

Label.strLabel = "CNN International"

LabelType = "TV Channel"

Channel.iChannelNr = 123

...

a program series (epg) as

Label.strLabel = "The Simpsons"

LabelType = "Series"

a TV Program (epg) as

Item.strName = "The Simpsons - Homer in Space"

Item.ParentItem = "Pro 7" (The Channel, maybe)

LabelMap contains

  map to Channel "Pro 7"

  map to Series "The Simpsons"

  map to Artist "Matt Groening" (Role Author)

  map to Artist "Bart Simpson" (Role Actor)

  map to Directory "d:\My Recordings"

File.strFileName = "Pro7_TheSimpsons_HomerInSpace_2006010122222.dvr-ms"

File. (Either allready there or scheduled for recording)

an Internet TV Stream as

Item.strName = "BBC World Stream"

Stream.strURL = "http://bbc.co.uk/123456.123.asx"

LabelMap contains

  map to Country "UK" (Sample)

a Picture 

Item.strName = "SomePicture_002"

file.strFileName = "SomePicture_002.jpg"

Directoy.str_Path = "d:\My Pics\Summer of 2006"

LabelMap contains

  map to Directory "d:\My Pics\Summer of 2006"

  map to CustomLabel "Holiday 2006"

  map to Playlist "My Summer" (Role 000002)

  map to PrintedLabel "Printed on 15th July 2006"

I guess I added most of the important types. I am willing (but time limited) to help out on this further.