These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Relationships between tables in static data dump
Author
Previous Topic Next Topic
Althalus Stenory
Flying Blacksmiths
#1 - 2012-09-06 18:39:14 UTC
Hello there !

Do anyone know where I will able to find the whole relationships from the static data dump (inferno 1.2) ?

I'd like to use that data with an ORM (Doctrine 2 in my case), but my problem is that i can't find those relationships... I already used this one http://zofu.no-ip.de/inf12/work/update-innodb.sql but, as far as I can see when i'm looking into some tables, there are many and many relationships missing...

Of course, i'd be able to find them into the dump provided by CCP.. but i'm on a mac, so it's not possible...

Any ideas ?

Thanks !

Regards,
Althalus

PS: sorry for my bad english :p

EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-09-06 19:19:25 UTC
Actually, the dump provided by CCP is pretty lacking in foreign key constraints.

The file you have is likely the work of someone determining the relationships by hand, and them implementing them.

As I despise ORMs (I'm a DBA. They might make a programmer's life easier, but they divorce them from having to understand how the DB fits together. and lead to bad designs/SQL), and it's a read only datasource, It's never bothered me. which is why you won't find the relationships added into my own conversions (I'm not leaving them out. They're not there in the first place)


You're going to have to put them together as you go, I'm afraid.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Althalus Stenory
Flying Blacksmiths
#3 - 2012-09-06 19:45:57 UTC
ow... well, let's go and try to fill at least the tables i need...
thanks for your answer :)

EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI
Vogue
Center for Advanced Studies
Gallente Federation
#4 - 2012-09-07 02:44:04 UTC
I found this pdf file that shows foreign keys for Tyrannis version data dump. I don't know how accurate it is.

http://www.filefactory.com/file/1o3p9swqfxg9/n/Tyrannis_SDD_FKs_pdf
Althalus Stenory
Flying Blacksmiths
#5 - 2012-09-07 16:55:08 UTC
Thx.

I'm using this one too : http://wiki.eve-id.net/Category:CCP_DB_Tables which is not fully accurate, but at least, it gives me an idea x)

EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI