client-user

Field	Usage	Mandatory	Data Type	Comment
id	ID		INT(10)
client_id	Client ID		INT(10)
username	Username	YES	VARCHAR(20)
Password	Password		VARCHAR(50)	Mandatory when creating
new_password	New password		VARCHAR(50)	Mandatory when you want to change the password
re_password	Retype password when changing		VARCHAR(50)	Mandatory when you want to change the password
first_name	First name		VARCHAR(20)
last_name	Last name		VARCHAR(20)
department	Department		VARCHAR(100)
email	Email	YES	VARCHAR(40)
qq	QQ (Chinese instant message service)	YES	VARCHAR(50)
telephone	Telephone	YES	VARCHAR(50)
is_receive_notification_sms	'1' to indict user would like to receive notification by SMS		TINYINT(1)
is_receive_notification_email	'1' to indict user would like to receive notification by email		TINYINT(1)
is_receive_notification_qq_group	'1' to indict user would like to receive notification from QQ Group		TINYINT(1)
client_user_group_id	Client User Group ID		INT(10)
status	Status	YES	ENUM('INACTIVE','ACTIVE')