Table Schema: mf_sites

This topic describes the columns in the mf_sites table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
site_guid uniqueidentifier 1 0 1   27  
company_guid uniqueidentifier 0 1 2   0 mf_companies.company_guid
site_handler_guid uniqueidentifier 0 1 3   0 mf_site_handlers.site_handler_guid
timezone_id smallint 0 1 4   0  
site_state_id smallint 0 1 5   0 mf_country_regions.country_region_id
site_country_id smallint 0 1 6   0 mf_countries.country_id
site_sstate_id smallint 0 1 7   0 mf_country_regions.country_region_id
site_scountry_id smallint 0 1 8   0 mf_countries.country_id
site_type_id smallint 0 0 9   0 mf_site_types.site_type_id
site_cd varchar (50) 0 1 10   0  
site_label varchar (50) 0 1 11   0  
site_label_short varchar (50) 0 1 12   0  
site_description varchar (255) 0 1 13   0  
site_name varchar (75) 0 1 14   0  
site_attention varchar (50) 0 1 15   0  
site_company_name varchar (255) 0 1 16   0  
site_address varchar (80) 0 1 17   0  
site_address2 varchar (80) 0 1 18   0  
site_address3 varchar (80) 0 1 19   0  
site_city varchar (50) 0 1 20   0  
site_postal_code varchar (50) 0 1 21   0  
site_country_region_name nvarchar (50) 0 1 22   0  
site_sattention varchar (50) 0 1 23   0  
site_scompany_name varchar (255) 0 1 24   0  
site_saddress varchar (80) 0 1 25   0  
site_saddress2 varchar (80) 0 1 26   0  
site_saddress3 varchar (80) 0 1 27   0  
site_scity varchar (50) 0 1 28   0  
site_spostal_code varchar (50) 0 1 29   0  
site_scountry_region_name nvarchar (50) 0 1 30   0  
site_phone varchar (50) 0 1 31   0  
site_fax varchar (50) 0 1 32   0  
site_email varchar (80) 0 1 33   0  
site_email_from varchar (80) 0 1 34   0  
site_email_from_display_name varchar (100) 0 1 35   0  
site_email_copies varchar (80) 0 1 36   0  
site_contact varchar (75) 0 1 37   0  
site_contact_email varchar (75) 0 1 38   0  
site_geography_lat decimal (8,5) 0 1 39   0  
site_geography_long decimal (8,5) 0 1 40   0  
site_default tinyint 0 0 41   0  
site_suppress_sale tinyint 0 0 42   0  
site_suppress_allocate tinyint 0 0 43   0  
site_suppress_pick tinyint 0 0 44   0  
site_deleted tinyint 0 0 45   0  
site_flag tinyint 0 0 46   0  
site_alert tinyint 0 0 47   0  
site_visible tinyint 0 0 48   0  
site_approved tinyint 0 0 49   0  
site_suspended tinyint 0 0 50   0  
site_locked tinyint 0 0 51   0  
site_closed tinyint 0 0 52   0  
site_filed tinyint 0 0 53   0  
lu_dt datetime 0 1 54   0  
cr_dt datetime 0 1 55   0  
lu_guid uniqueidentifier 0 1 56   0  
cr_guid uniqueidentifier 0 1 57   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.