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

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.