Demographics

Here is a description of the columns contained in the Demographics add-on, provided in the order they are encountered in the extract file. This document attempts to be database-independent by providing a proper description of the column type, instead of a SQL statement.
  • Each field is delimited by character 127, DEL. Try typing this by holding the alt key, then pressing 0,1,2,7 in sequence. Try representing it with your favourite programming language with "\x7F".
  • Items Ended are split into one file for each meta category, for each auction end date.
PositionNameColumn TypeDescription
1 Item_id Integer, up to 18 digits A unique ID for the item, the same as one from the item extract.
2 Transaction ID Integer, up to 12 digits A unique ID for this transaction ( there might be multiple transactions per item, e.g. dutch auctions , stores, etc.)
3 buyer_id Integer, up to 12 digits A unique ID for the buyer (integer).
4 date_of_birth Date Buyer's date of birth.
5 gender 1 Character Gender : M, F, U (unspecified)
6 buyer_country_id Integer, up to 9 digits Numeric identifier for a country. See lookup package : Countries
7 pstl_code String, up to 10 characters long Zip Code/Postal code of the buyer