Matrix Games Forums

Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

I fear you got your table design backwards

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [New Releases from Matrix Games] >> Shadow Empire >> Suggestions and Feedback >> I fear you got your table design backwards Page: [1]
Login
Message << Older Topic   Newer Topic >>
I fear you got your table design backwards - 5/30/2021 4:49:53 PM   
zgrssd

 

Posts: 3212
Joined: 6/9/2020
Status: online
The new Modding tools exposed how you are doing things. The game appears to be a database on the hood - just set up exactly the wrong way :)

Few things show that as well as the Planet Classes table I found.
Normally you would use the Planet Classes as the Rows of the table. Each planet type would be a row in the table.
Code that has to parse them - say the Planet Class Selection - would only need to do a partial select.

You used the Planet Classes as the Columns.
The way you set it up, you have to modify the backend and the parsing code, to add a new planet class.
What you used as the Description, should be the Columns.

Every piece of Database Designer in me tells me you should rework this. This is just going to end up biting you in the butt.
But the realist in me knows that would be way too much work to bother. At least you should try not to do that mistake with future tables :)

Attachment (1)
Post #: 1
Page:   [1]
All Forums >> [New Releases from Matrix Games] >> Shadow Empire >> Suggestions and Feedback >> I fear you got your table design backwards Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.113