mardi 26 mai 2015

Best way to represent a song, consisting of an arbitrary number of chords?

How can I best represent the following data in sqlite3?

I'm creating a database of songs, which each consist of an unpredictable number of chords. Each chord has a root (string, 1 or 2 characters) and a tonality (string, <20 characters).

It would make intuitive sense to me to have two classes: Chord containing two strings, and Song containing an arbitrary-length list of Chords. However, as far as I can tell, that's not how sqlite operates. Is there a better/canonical way of handling this type of data?

Aucun commentaire:

Enregistrer un commentaire