[Home]|[Architecture Docs]|[Server Schema]
Server Database Schema
Songs Table
| Field | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| ID | int(11) | No | ||||
| ID3_Title | text | No | ||||
| ID3_Artist | text | No | ||||
| ID3_Album | text | No | ||||
| ID3_Length | int(11) | No | ||||
| ID3_Playcount | int(11) | No | ||||
| ID3_Genre | text | No | ||||
| ID3_Year | int(11) | No | ||||
| ID3_Rating | int(11) | No | ||||
| ID3_Bitrate | int(11) | No | ||||
| ID3_TrackNumber | int(11) | No | ||||
| ID3_TotalTrackNumber | int(11) | No | ||||
| ID3_Encoding | text | No | ||||
| ID3_Composer | text | No | ||||
| ID3_Language | text | No | ||||
| ID3_Publisher | text | No | ||||
| ID3_ParentalRating | int(11) | No | ||||
| ID3_DateRecorded | int(11) | No | ||||
| ID3_Binary | blob | No | ||||
| DateAdded | text | No | Date the song was added to the database | |||
| FilesystemDateModified | int(11) | No | ||||
| DbDateModified | int(11) | No | ||||
| LastInformationSync | int(11) | No | Last time database information was synced with the physical file | |||
| SongMD5 | text | No |
Users table
| Field | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| ID | int(11) | No | ||||
| UserName | text | No |
songRequests Table
| Field | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| ID | int(11) | No | ||||
| SongID | int(11) | No | songs -> ID | |||
| Requester | text | No | ||||
| Time | int(11) | No |
