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