users


Description

Users created by the learning site.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
companyId uuid 2147483647 null
companies.id users_companyId_fkeyC

The ID of the learning site
id uuid 2147483647 null
assignmentSubmissions.userId assignmentSubmissions_userId_fkeyC
awards.userId awards_userId_fkeyC
certificates.userId certificates_userId_fkeyC
courseActions.userId courseActions_userId_fkeyC
learningPathActions.userId learningPathActions_userId_fkeyC
ltiAttempts.userId ltiAttempts_userId_fkeyC
onboardingSurveyResponses.userId onboardingSurveyResponses_userId_fkeyC
quizAttemptResponses.userId quizAttemptResponses_userId_fkeyC
quizAttempts.userId quizAttempts_userId_fkeyC
scormAttemptResponses.userId scormAttemptResponses_userId_fkeyC
scormAttempts.userId scormAttempts_userId_fkeyC
testimonials.userId testimonials_userId_fkeyC
userBundles.userId userBundles_userId_fkeyC
userCourseProgresses.userId userCourseProgresses_userId_fkeyC
userCourses.userId userCourses_userId_fkeyC
userLearningPaths.userId userLearningPaths_userId_fkeyC
userLicenses.userId userLicenses_userId_fkeyC
waitlists.userId waitlists_userId_fkeyC

Unique Identifier of the User
firstName varchar 255 √ null

The first name of the User
lastName varchar 255 √ null

The last name of the User
role varchar 255 √ null

The role of the User
externalCustomerId varchar 255 √ null

The ID of the External Customer associated with the User
email varchar 255 √ null

The email of the User
address1 varchar 255 √ null

The address1 of the User
address2 varchar 255 √ null

The address2 of the User
city varchar 255 √ null

The city of the User
state varchar 255 √ null

The state of the User
zipCode varchar 16 √ null

The zip code of the User
shippingName varchar 255 √ null

The shipping name of the User
clientId uuid 2147483647 √ null
clients.id users_clientId_fkeyC

The ID of the Client associated with the User
ref1 varchar 255 √ null

The ref1 of the User
ref2 varchar 255 √ null

The ref2 of the User
ref3 varchar 255 √ null

The ref3 of the User
ref4 varchar 255 √ null

The ref4 of the User
ref5 varchar 255 √ null

The ref5 of the User
ref6 varchar 255 √ null

The ref6 of the User
ref7 varchar 255 √ null

The ref7 of the User
ref8 varchar 255 √ null

The ref8 of the User
ref9 varchar 255 √ null

The ref9 of the User
ref10 varchar 255 √ null

The ref10 of the User
stripeCustomerId varchar 16 √ null

The ID of the Stripe Customer associated with the User
sfAccountId varchar 18 √ null

The ID of the Sf Account associated with the User
sfContactId varchar 18 √ null

The ID of the Sf Contact associated with the User
createdAt timestamp 29,6 √ null

The date and time the User was created
lastActiveAt timestamp 29,6 √ null

The date and time the User was created
disabled bool 1 false

Indicates if the User has been disabled
updatedAt timestamp 29,6 √ null
country text 2147483647 √ null
telephone text 2147483647 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc id
users_clientId_idx Performance Asc clientId

Relationships

Close relationships within degrees of separation