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