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.
 

walletTransactions and walletJournal
Author
Previous Topic Next Topic
Gallente Drone
Doomheim
#1 - 2013-02-26 00:34:46 UTC
Both of this api has two setuo for corporation and character, all of them has transactionID. Question is: are they unique? Can i store them in one db table (one table fo journal and one for transactions)? Or it's just column name coincidence?
Tonto Auri
Vhero' Multipurpose Corp
#2 - 2013-02-26 04:49:00 UTC
Yes, they are unique... in the sense, that one transaction does not have different ID's in different places.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison
Ydnari
Estrale Frontiers
#3 - 2013-02-26 13:39:11 UTC
Gallente Drone wrote:
Both of this api has two setuo for corporation and character, all of them has transactionID. Question is: are they unique? Can i store them in one db table (one table fo journal and one for transactions)? Or it's just column name coincidence?


If you do a transaction on behalf of corp the same transaction with the same transactionID will appear in both the corp and character data. It is the same transaction, but it's then up to you whether you want transactionID as primary key and be aware you may have to ignore duplicate key violations for this case, or a composite key with the owner ID (character or corp) plus transaction ID, so the char + corp transactions have two rows instead of one.

--
Gallente Drone
Doomheim
#4 - 2013-02-27 22:44:20 UTC
ok, so will create two separate table for each wallet type (journal\transaction)
Tonto Auri
Vhero' Multipurpose Corp
#5 - 2013-02-27 23:03:08 UTC  |  Edited by: Tonto Auri
What for? O.o
You'll have to tend to two tables, would transaction ids gets cut again in future.

Two most common elements in the universe are hydrogen and stupidity. -- Harlan Ellison