client-user

URI:   http://test.birdsystem.com/client/client-user



FieldUsageMandatoryData TypeComment

id

ID


INT(10)


client_id

Client ID


INT(10)


username

Username

YES

VARCHAR(20)


PasswordPassword
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')