Table Schema: mf_auctions

This topic describes the columns in the mf_auctions table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
auction_guid uniqueidentifier 1 0 1   1  
company_guid uniqueidentifier 0 1 2   0  
catalog_guid uniqueidentifier 0 1 3   0 mf_catalogs.catalog_guid
site_guid uniqueidentifier 0 1 4   0 mf_sites.site_guid
item_guid uniqueidentifier 0 0 5   0 mf_items.item_guid
item_variation_guid uniqueidentifier 0 1 6   0  
item_hold_guid uniqueidentifier 0 1 7   0  
provider_guid uniqueidentifier 0 1 8   0 mf_provider.provider_guid
order_guid uniqueidentifier 0 1 9   0  
auction_group_guid uniqueidentifier 0 1 10   0  
company_agent_guid uniqueidentifier 0 1 11   0  
auction_code_guid uniqueidentifier 0 1 12   0  
auction_type_id smallint 0 1 13   0  
auction_cd varchar (50) 0 1 14   0  
auction_description varchar (255) 0 1 15   0  
auction_quantity smallint 0 1 16   0  
auction_quantity_sold smallint 0 1 17   0  
auction_time_span smallint 0 1 18   0  
auction_launch_date datetime 0 1 19   0  
auction_start_date datetime 0 1 20   0  
auction_end_date datetime 0 1 21   0  
auction_wholesale_price money 0 1 22   0  
auction_starting_price money 0 1 23   0  
auction_reserve_price money 0 1 24   0  
auction_purchase_price money 0 1 25   0  
auction_bids smallint 0 1 26   0  
auction_cost money 0 1 27   0  
auction_highbid_price money 0 1 28   0  
auction_highbid_user_guid uniqueidentifier 0 1 29   0  
auction_scan_dt datetime 0 1 30   0  
auction_error tinyint 0 0 31   0  
auction_prepared tinyint 0 0 32   0  
auction_exported tinyint 0 0 33   0  
auction_imported tinyint 0 0 34   0  
auction_launch_immediate tinyint 0 0 35   0  
auction_revise tinyint 0 0 36   0  
auction_relisted tinyint 0 0 37   0  
auction_sold tinyint 0 0 38   0  
auction_suspect tinyint 0 0 39   0  
auction_alert tinyint 0 0 40   0  
auction_visible tinyint 0 0 41   0  
auction_new tinyint 0 0 42   0  
auction_approved tinyint 0 0 43   0  
auction_suspended tinyint 0 0 44   0  
auction_locked tinyint 0 0 45   0  
auction_closed tinyint 0 0 46   0  
auction_filed tinyint 0 0 47   0  
auction_archived tinyint 0 0 48   0  
auction_flag tinyint 0 0 49   0  
lu_dt datetime 0 0 50   0  
cr_dt datetime 0 0 51   0  
lu_guid uniqueidentifier 0 1 52   0  
cr_guid uniqueidentifier 0 1 53   0  

Return to index of tables