trade
Copyright © 2000-2007 Jim Michaels
trade_bidhistory
Field Type Collation Null Key Default Extra
----------- ---------------- ----------------- ------ ------ ------- --------------
itemhist_id int(10) unsigned binary PRI (NULL) auto_increment
dt timestamp latin1_swedish_ci YES (NULL)
bid_amt decimal(6,2) binary 0.00
bidder_id int(11) binary 0
trade_categories
Field Type Collation Null Key Default Extra
---------- ------------------------------ ----------------- ------ ------ ------- --------------
cat_id int(11) unsigned binary PRI (NULL) auto_increment
category char(100) character set latin1 latin1_swedish_ci
cat_grp int(11) unsigned binary MUL 0
subcat_grp int(10) unsigned binary 0
ordr tinyint(3) unsigned binary YES (NULL)
lvl tinyint(3) unsigned binary YES (NULL)
flag tinyint(1) unsigned binary MUL 0
trade_deals
Field Type Collation Null Key Default Extra
------- ---------------- --------- ------ ------ ------- --------------
deal_id int(10) unsigned binary PRI (NULL) auto_increment
trade_items
Field Type Collation Null Key Default Extra
------------------ ----------------------------- ----------------- ------ ------ ------- --------------
item_id int(10) unsigned binary PRI (NULL) auto_increment
item_desc longtext character set latin1 latin1_swedish_ci YES (NULL)
img longtext character set latin1 latin1_swedish_ci YES (NULL)
item_paid_price decimal(6,2) binary YES (NULL)
item_retail_price decimal(6,2) binary YES (NULL)
item_list_price decimal(6,2) binary YES (NULL)
item_ask_price decimal(6,2) binary YES (NULL)
item_min_price decimal(6,2) binary YES (NULL)
owned_by_trader_id int(11) binary 0
weight_lbs double binary YES (NULL)
size_l_in double binary YES (NULL)
size_w_in double binary YES (NULL)
size_h_in double binary YES (NULL)
is_used char(1) character set latin1 latin1_swedish_ci y
dt_purchased date latin1_swedish_ci YES (NULL)
comments longtext character set latin1 latin1_swedish_ci YES (NULL)
new_in_box char(1) character set latin1 latin1_swedish_ci n
taken tinyint(1) unsigned binary 0
trade_traders
Field Type Collation Null Key Default Extra
------------------- --------------------------------- ----------------- ------ ------ ------------ --------------
trade_trader_id int(10) unsigned binary PRI (NULL) auto_increment
trader_name varchar(90) character set latin1 latin1_swedish_ci
trader_city varchar(50) character set latin1 latin1_swedish_ci Woodland
trader_state char(2) character set latin1 latin1_swedish_ci WA
trader_zip varchar(10) character set latin1 latin1_swedish_ci 00000-0000
trader_phone varchar(20) character set latin1 latin1_swedish_ci YES 360-000-0000
trader_addr varchar(100) character set latin1 latin1_swedish_ci YES (NULL)
trader_handle varchar(30) character set latin1 latin1_swedish_ci YES (NULL)
trader_email varchar(64) character set latin1 latin1_swedish_ci YES (NULL)
trader_fax varchar(20) character set latin1 latin1_swedish_ci YES (NULL)
trader_last_updated date latin1_swedish_ci 0000-00-00
trader_comments longtext character set latin1 latin1_swedish_ci YES (NULL)
trade_wants
Field Type Collation Null Key Default Extra
-------------- ---------------- --------- ------ ------ ------- --------------
trader_want_id int(10) unsigned binary PRI (NULL) auto_increment
trader int(10) unsigned binary 0
item_wanted int(10) unsigned binary 0