Table Schema: mf

This topic describes the columns in the mf_users table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

Column Name	Data Type	Primary Key	Is Nullable	Column ID	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

Table Schema: mf_users