Database structure

Post Reply
Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Database structure

Post by Delaide » Fri Dec 30, 2016 4:37 am

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.
Attachments
DSP Database structure.xlsx
(72.48 KiB) Downloaded 245 times

User avatar
whasf
Site Admin
Posts: 1312
Joined: Thu Jul 19, 2012 9:11 pm

Re: Database structure

Post by whasf » Fri Dec 30, 2016 2:33 pm

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

Post Reply