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