Music Player
In the original days of iTunes and MP3 players, you owned your own music and they were just files on your device. I'd like to return to that.

Functional Requirements
Store and play music locally. Upload your own album art.
Non Functional Requirements
- Beautiful UI
- Mobile Friendly
UI Design
The UI is based on several Dribble designs and Facebook
Wireframes

Mockups
Next I created the Profile page. I wanted something much more simple than Facebook and only features that are engaging (nothing boring). This should be a simple way to get to know someone.

Media Schema
User
Description about Shipment should go here. Should be described in 5 sentences or less and may include the "who, what, when, where, and how" (and perhaps "which") of what this model is.
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| user_account | |
| first_name | |
| last_name | |
| location | |
| university | |
| employer | |
| employed_since | |
| gender | |
| birthday | |
| ip_address | |
| browser | |
| status | |
| created_at | |
| updated_at |
Song
Description about Shipment should go here. Should be described in 5 sentences or less and may include the "who, what, when, where, and how" (and perhaps "which") of what this model is.
| Attribute | Description |
|---|---|
| id | The unique id to identify the song. |
| title | |
| content | |
| author (user_id) | |
| group_id | |
| ip_address | |
| user_agent | |
| created_at | |
| updated_at |
SongLikes
Description about Shipment should go here. Should be described in 5 sentences or less and may include the "who, what, when, where, and how" (and perhaps "which") of what this model is.
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| song_id | |
| user_id |
SongTags
Description about Shipment should go here. Should be described in 5 sentences or less and may include the "who, what, when, where, and how" (and perhaps "which") of what this model is.
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| song_id | |
| tag | The label for the tag |
Comment
Description about Shipment should go here. Should be described in 5 sentences or less and may include the "who, what, when, where, and how" (and perhaps "which") of what this model is.
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| comment_id | |
| content | |
| song_id | |
| reply_to | |
| author | |
| created_at | |
| updated_at |
Interests
Description about Shipment should go here. Should be described in 5 sentences or less and may include the "who, what, when, where, and how" (and perhaps "which") of what this model is.
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| user_id | |
| interest |
UserGroups
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| user_id | |
| group_id |
Group
Description about Shipment should go here. Should be described in 5 sentences or less and may include the "who, what, when, where, and how" (and perhaps "which") of what this model is.
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| group_id | |
| title | |
| moderator | |
| created_at | |
| updated_at |
GroupMembership
Description about Shipment should go here. Should be described in 5 sentences or less and may include the "who, what, when, where, and how" (and perhaps "which") of what this model is.
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| membership_id | |
| group_id | |
| member_account | |
| joined_date |
Album
Description about Shipment should go here. Should be described in 5 sentences or less and may include the "who, what, when, where, and how" (and perhaps "which") of what this model is.
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| album_id | |
| creator | |
| title | |
| created_at | |
| updated_at |
Photo
Description about Shipment should go here. Should be described in 5 sentences or less and may include the "who, what, when, where, and how" (and perhaps "which") of what this model is.
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| photo_id | |
| album_id | |
| location | |
| latitude | |
| longitude | |
| taken_time | |
| ip_address | |
| user_agent |
PhotoTags
Description about Shipment should go here. Should be described in 5 sentences or less and may include the "who, what, when, where, and how" (and perhaps "which") of what this model is.
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| photo_id | |
| tag_account |
Notification
| Attribute | Description |
|---|---|
| id | The unique id to identify the song like. |
| unread | |
| href | |
| text |
Resources
https://wiki.sahanafoundation.org/req/logistics_module_draft_table_structure_diagram


