So, in my attempt to understand how the server core and database interact, I am working on a database structure with detailed explanation in excel.
This is still very much a wip, but I figured I would attach it here in case anyone is interested in examining it. Please note: Right now, only the database tables are shown in the excel. The accounts has some of the starting structure, but this is limited.
I will update the file as it progresses. Hopefully this will help explain to noobs like me how the sql works with the server.
Database structure
Database structure
- Attachments
-
DSP Database structure.xlsx
- (72.48 KiB) Downloaded 307 times
Re: Database structure
That's neat, aren't there programs that will create pretty graphics showing the relationships for you? I know they exist for MSQL, I'm sure there are some for MySQL too...
-- Whasf