Users table

Column Type

User_Id

String

Role_Id

String

Name

String

Email

String

User_Role

String

Status

String

Is_Current_User

Boolean

Photo_Url

String

Is_Customer_Segmented

Boolean

Is_Vendor_Segmented

Boolean

User_Type

String

Mobile

String

Default_Branch_Id

String

Billing_Rate

Number

Is_Super_Admin

Boolean

Is_Accountant

Boolean

Role_Role

Object

Role_Role_Id

String

Role_Name

String

Role_Email

String

Role_Zuid

String

Is_Employee

Boolean

Is_Associated_For_Approval

Boolean

Is_Claimant

Boolean

Invitation_Type

String

Created_Time

Timestamp

Is_Associated_With_Org_Email

Boolean

Email_Ids

Array

Associated_Clients

Array

Examples

INSERT INTO
    Users ([Name], Email, Role_Id, Billing_Rate)
values
    (
        'Sally Smedley',
        's.smedley@easysoft.com',
        '579676000000000682',
        150
    )
UPDATE Users
SET
    Billing_Rate = 159
WHERE
    User_Id = '579676000000160069'