Albums table: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
(→Fields) |
||
| Line 17: | Line 17: | ||
| TEXT | | TEXT | ||
| | | | ||
| | | The name(s) of the AlbumArtist(s) | ||
|- | |- | ||
| ''Album'' | | ''Album'' | ||
| TEXT | | TEXT | ||
| | | | ||
| | | The Name of the Album | ||
|- | |- | ||
| Year | | Year | ||
| INTEGER | | INTEGER | ||
| | | | ||
| | | Not really in use | ||
|- | |- | ||
| Comment | | Comment | ||
| TEXT | | TEXT | ||
| | | | ||
| | | Album level comment | ||
|- | |- | ||
| Tracks | | Tracks | ||
| INTEGER | | INTEGER | ||
| Counter by trigger (0 to inf.) | | Counter by trigger (0 to inf.) | ||
| | | Count of Songs linked to the Album | ||
|} | |} | ||
== Connections == | == Connections == | ||
Revision as of 21:26, 23 January 2008
- [Database Structure]
- Albums
- Artists
- ArtistsAlbums
- ArtistsSongs
- Covers
- DBInfo
- DeviceFilters
- DeviceTracks
- Devices
- Downloads
- Filters
- Folders
- FoldersHier
- Genres
- GenresSongs
- LastTreePath
- Lists
- ListsSongs
- Medias
- OrganizeRules
- PathProcessing
- Pinned
- Played
- PlaylistSongs
- Playlists
- PodcastDirs
- PodcastEpisodes
- Podcasts
- Radio
- RemoteClients
- Songs
- SynchAlbum
- SynchArtist
- SynchLocation
- SynchPlaylist
- SynchPodcast
- URLRequestCache
Fields
| Name | Value Type | Possible Values | Description |
|---|---|---|---|
| ID | INTEGER | AUTOINCREMENT (1 to inf.) | |
| Artist | TEXT | The name(s) of the AlbumArtist(s) | |
| Album | TEXT | The Name of the Album | |
| Year | INTEGER | Not really in use | |
| Comment | TEXT | Album level comment | |
| Tracks | INTEGER | Counter by trigger (0 to inf.) | Count of Songs linked to the Album |
Connections
- Songs table
- Artists table (via the ArtistsAlbums table)
- ...
