Is there a particular reason you require a schema diagram? I wouldn't recommend working directly with database other than adding custom tables. Interacting directly with the umbraco tables isn't supported and could cause issues, better to work with the built in methods. If you feel confident interacting with it directly then you should be able to generate your own schema from the database.
So for my understanding, i should create new tables, so that umbraco and custom tables are seperated and safe.
My Case is this:
I want to create a booking tool for events:
the user should can do:
create Event Item
comment on Event Items
rate the Event Item
select Packages from the Event Item (food, hotel, etc.)
have a small user page with his coming Events and countdown
My thought was, that i can use members Table, create a Comment Table with the Event Item ID. And don't know how would Umbraco handle ACL with the rights.
For the Event Item ID itself name, location,.. that would be also easy.
Later list them under the users page with a simply countdown.
You shouldn't need to create any custom tables to do this. Checkout the forum package I recently posted it should give you an ide to start what you are looking for. It has membership with different levels where users can create posts and comments. Your Moodle is pretty similar you would just need to extend it to fit your needs but it essentially has the functionality you are looking for.
There are times where you will want to create you're own tables.
Its a common anti-pattern to try and use Umbraco for your use case. Umbraco calls this volatile data as it changes a lot.
If I was designing this, I'd hook into Umbraco's membership services for user management, but I'd create my own tables for anything around the events/bookings with the user id being stored against the records where it makes sense.
I would agree with Brendan once again, it all depends how scalable it needs to be.
The forum was originally designed for low volume traffic and would not scale well. I too would create custom tables for the forums and posts if it was to be a public facing site, might even do that for the next version :)
Umbraco 8 Database Schema
Hi there
Is there a DB Schema from v8?
I found some forum posts, but didn't found a picture/pdf from it.
https://our.umbraco.com/documentation/extending/database/
Is there a particular reason you require a schema diagram? I wouldn't recommend working directly with database other than adding custom tables. Interacting directly with the umbraco tables isn't supported and could cause issues, better to work with the built in methods. If you feel confident interacting with it directly then you should be able to generate your own schema from the database.
Hi Reddick
I'm coming from Wordpress and thought to create own plugins. So when umbraco got already tables, that i would use them.
like wp_users and umbracos members.
My plan is to create a custom booking solution and later to publish that free.
In Umbraco you don't deal directly with the database tables. There is essentially an API on top.
Here's a few links:
As Brendan says, you can accomplish what you need just using the back office tools and the services.
Another good place to look is the available packages, most of them have source code available you can look at to work out how stuff is done.
And post questions here if you get stuck, lots of people willing to help
Hi Brendan
thanks for the links.
So for my understanding, i should create new tables, so that umbraco and custom tables are seperated and safe.
My Case is this:
I want to create a booking tool for events:
the user should can do:
My thought was, that i can use members Table, create a Comment Table with the Event Item ID. And don't know how would Umbraco handle ACL with the rights.
For the Event Item ID itself name, location,.. that would be also easy.
Later list them under the users page with a simply countdown.
You shouldn't need to create any custom tables to do this. Checkout the forum package I recently posted it should give you an ide to start what you are looking for. It has membership with different levels where users can create posts and comments. Your Moodle is pretty similar you would just need to extend it to fit your needs but it essentially has the functionality you are looking for.
https://our.umbraco.com/packages/collaboration/mediawizards-forum/
There are times where you will want to create you're own tables.
Its a common anti-pattern to try and use Umbraco for your use case. Umbraco calls this volatile data as it changes a lot.
If I was designing this, I'd hook into Umbraco's membership services for user management, but I'd create my own tables for anything around the events/bookings with the user id being stored against the records where it makes sense.
I would agree with Brendan once again, it all depends how scalable it needs to be. The forum was originally designed for low volume traffic and would not scale well. I too would create custom tables for the forums and posts if it was to be a public facing site, might even do that for the next version :)
is working on a reply...