vendredi 29 janvier 2016

table and fields for a friend request system on Spotify

Require some help on in what table and fields required to create a database on sql.

The aim of the project is to design implement social side of program like Spotify. Requirements as follows

If the customer has a paid subscription The customer can add other customers as friends provided the friend is a paying subscriber.

The customer can mark themselves as discoverable so that friends can find them or the customer can remain as private.

To add someone as a friend a private message is sent to another customer, who can accept or decline.

Upon acceptance of a friend invite they are added as a friend to the customer’s ‘friend list’.

A customer can remove a friend from their “friends list” at any time.

Subscribed users must be able to see the tracks in their friends’ playlists but should not be able to edit them.

I have two table and require assistance on the the other tables that are required.

customer table with the fields, customer_id, customer_name, discoverable_flag

customer_relationship table with the fields, customer_initiated_id, customer_requested_id, relationship_status

I am stuck on the other tables and fields and would like help on the tables and fields require for the specification.

Aucun commentaire:

Enregistrer un commentaire