Table Schema: mf_users

This topic describes the columns in the mf_users table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
user_guid uniqueidentifier 1 0 1   14  
firm_guid uniqueidentifier 0 1 2   0 mf_firms.firm_guid
company_guid uniqueidentifier 0 1 3   0 mf_companies.company_guid
state_id smallint 0 1 4   0 mf_country_regions.country_region_id
country_id smallint 0 1 5   0 mf_countries.country_id
upload_state_id smallint 0 1 6   0  
security_level_id smallint 0 0 7   0 mf_security_levels.security_level_id
user_type_id smallint 0 1 8   0  
timezone_id smallint 0 1 9   0  
iso_culture_cd varchar (15) 0 1 10   0 mf_iso_cultures.iso_culture_cd
username varchar (255) 0 1 11   0  
password varchar (200) 0 1 12   0  
password_expire_date datetime 0 1 13   0  
password_question varchar (255) 0 1 14   0  
password_answer varchar (255) 0 1 15   0  
failed_password_attempt_count smallint 0 0 16   0  
failed_password_attempt_start datetime 0 1 17   0  
failed_password_answer_attempt_count smallint 0 0 18   0  
failed_password_answer_attempt_start datetime 0 1 19   0  
secret varchar (255) 0 1 20   0  
first_name varchar (255) 0 1 21   0  
last_name varchar (255) 0 1 22   0  
title varchar (50) 0 1 23   0  
description varchar (50) 0 1 24   0  
attention varchar (255) 0 1 25   0  
company_name varchar (255) 0 1 26   0  
address varchar (80) 0 1 27   0  
address2 varchar (80) 0 1 28   0  
address3 varchar (80) 0 1 29   0  
city varchar (50) 0 1 30   0  
postal_code varchar (50) 0 1 31   0  
country_region_name nvarchar (50) 0 1 32   0  
phone varchar (25) 0 1 33   0  
work_phone varchar (25) 0 1 34   0  
email varchar (80) 0 1 35   0  
notes varchar (255) 0 1 36   0  
locked_out tinyint 0 0 37   0  
visible tinyint 0 0 38   0  
active tinyint 0 0 39   0  
lu_dt datetime 0 1 40   0  
cr_dt datetime 0 1 41   0  
lu_guid uniqueidentifier 0 1 42   0  
cr_guid uniqueidentifier 0 1 43   0  
external_id_guid uniqueidentifier 0 1 46   0  

Return to index of tables