Icebreaker::Design

From XiphWiki
Revision as of 16:04, 3 February 2008 by Saoshyant (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Design

I've put a few things that I've been thinking about on this wiki page.
If you would like to comment, please make a note.

Database

Here is a simple structure with explanations.

Database: On a server or sqlite, doesnt matter.

data- table; houses file data.
path- path of file on the file system.
genre- genre example: Rock
artist- artist example: Misfits
title- title example: Hybrid Moments
album- album example: Static Age
playlists- table; definition on databases, scheduling, defined in web-app.
name- playlist name.
description- description of playlist
position- position in playlist, so that play is not started over from beginning. Incremented when track begins.
day- scheduling, a string of days to play??? numbers 1-7.
time- scheduling, a dictionary of times to play based with day (1-7) as key.
current- designates the currently running playlist, value is 1 or 0.
playlist- table, name of table is playlist? maybe incorporated in playlists table?