steamkeys - OpenPerpetuum/OPDB GitHub Wiki
Description
Contains all the steam keys that has been assigned out to accounts.
Table Structure
| ID | Type | Name | Description | Properties | Links |
|---|---|---|---|---|---|
| 1 | Number | id | The ID of the current entry. | PRIMARY | |
| 2 | Number | accountid | The account that the Steam Key created/activated. | ||
| 3 | String | steamid | The ID of the steam account. | ||
| 4 | String | steamkey | The actual CD key that was given out to the user. | ||
| 5 | DateTime | assigned | When did this assignment/linking take place? |
Notes
steamid
Steam64 ID, Community ID, SteamCMD ID, or login username?
Because Valve uses our usernames as the primary keys, because they're... Valve.