Versions Compared

Old Version 32

changes.mady.by.user René Ponce Carrillo (Deactivated)

Saved on

compared with

New Version 33

changes.mady.by.user René Ponce Carrillo (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleUsers

User Table

This table contains all the users within CAM.

Query the table by: select * from user limit 100

^Use the user Query type

Info

Important: Don’t type users as the table name; this is an old antiquated table and you won’t get proper results.

Column

Description

id

Displays the row number of the entry in the user table

userId

Displays the user id associated to the user name.

userName

Displays the user name

emailIdemail

Displays the user email Id

officeN/A

Displays the office to which the user belongs

titleN/A

Displays the title currently associated with the user

phoneN/A

Displays phone number currently associated with the user

locationN/A

Displays the location currently associated with the user

isExternal

N/A

userType

Displays the user type (Internal/External)

subscriberIduserContainerType

Displays the tenant subscriber Idsystemcontainer type

extContainerId

Displays the external system namecontainer id

documentDBNameExtContainerName

Displays the database name of the external container

repositoryIdisCamUser

Displays the repository name

writeDate

Displays

flag

N/A

createdOnwhether the user is an active CAM user

extId

Displays the external id associated with the user

metadata

Any metadata added/changed/updated/deleted

createdDate

Displays the user creation date

createdBy

N/A

modifiedOn

Displays the last update date

modifiedByeditedDate

Displays the last date the user was edited

createdByUserId

Displays the user id that created the user

createdByUser

Displays the user name who last updated the entry

metadata

N/A

sourceId

Displays the database name

repositoryName

Displays the repository namethat created the user

lastChangeUserId

Displasy the user id that last changed the user

lastChangeUserId

Displasy the user id that last changed the user

camCreateDate

Displays the date in which the user was created in CAM

camCreatedBy

???

camEditedDate

Displays the last date the user was edited in cam

camEditedBy

??

extSystemId

Displays the id of the external system.

subscriberId

??

Expand
titleUser_groups

User_Groups Table

This table contains all the user group information within CAM.

Query the table by: select * from user_groups limit 100

^Use the groups Query type

Column

Description

id

Displays the row number of the entry in the user_group table

userId

Displays the user id associated to the user name. This is auto-generated by CAM.

userSystemId

Displays the user name

groupId

Displays the user id associated to the user name. This is auto-generated by CAM.

groupSystemId

Displays the group name the user is associated to.

subscriberId

Displays the tenant subscriber Id

system

Displays the external system

repositoryId

Displays the repository name

documentDbName

Displays the database name

flag

 

created_on

Displays the date the user was added to the group

created_by

modified_on

Displays the last update date

modified_by

N/A

metadata

N/A

sourceId

Displays the database name

repositoryName

Displays the repository name

...