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