EVE SDE - Relationships between tables

[Metrequia]

@Blacksmoke16

Technically there is no SQL SDE database tables. Steve’s conversions originate from YAML files which he converts to the SQL database format.

Oh yes I realise and already knew that, I wasn’t looking to create any relationships myself in the actual database.

@Blacksmoke16

As such you would have to define such relations yourself. With some work it shouldn’t be too hard to figure out, but can get messy in certain parts for sure.

Oh I wasn’t looking to create any relationships myself, was merely wanting to note which tables use fields that also exist in other tables, and note this done so that it would help me in creating queries later on.

@Blacksmoke16

EDIT: From what i can tell from quickly going thru the SDE files

Race -> Bloodline -> Ancestry Also maybe crpNPCCorporations for system of each NPC corp?

When creating a character using the eve client, ancestry is able to be choosen at the same time as the education / starting corp.

Also the crpNPCCorporations table only has a solarSystemID and nothing deeper than this, so unsure how I would get down to region level by starting with each NPC corp as you suggest.