So I've been planning a project for a multi purpose platform. The idea is to use the same platform for several sites which will in turn result in a network. Log in on one site, and you are logged in on all sites in the network (this part i've got sorted out).
The sites will focus on different topics like, attractions, entertainment, hotels. So now I'm trying to figure out a database structure that can be used on each platform.
Let's take the music site first. It will hold information like:
- Artists
- Name
- Genre
- Contact/Booking info
- Labels
- Contact info
- Name
- Releases
- Title
- Artist
- Track list
Then the site for hotels will contain info such as
- Name
- Address
- Contact info
I've been thinking that I can treat them like items, but I'm stuck on how to build a solid structure so I don't have to build every site from scratch.
Any ideas are very much appreciated