users

31435777 rows


Description

User created by the learning site

Columns

Column Type Size Nulls Auto Default Children Parents Comments
companyid varchar 36 √ null
companies.id users_companyid_fkey R

The ID of the learning site
id varchar 36 null
assignmentsubmissions.userid assignmentsubmissions_userid_fkey R
awards.userid n_awards_userid_fkey R
certificates.userid certificates_userid_fkey1 R
comments.userid comments_userid_fkey R
competencyassessmentattempts.userid competencyassessmentattempts_userid_fkey1 R
competencyassessmentresponses.userid competencyassessmentresponses_userid_fkey1 R
courseactions.userid courseactions_userid_fkey R
learningpathactions.userid learningpathactions_userid_fkey R
ltiattempts.userid ltiattempts_userid_fkey R
onboardingsurveyresponses.userid onboardingsurveyresponses_userid_fkey R
purchases.userid purchases_userid_fkey R
quizattemptresponses.userid quizattemptresponses_userid_fkey R
quizattempts.userid quizattempts_userid_fkey R
redemptioncodes.redeemedbyuserid redemptioncodes_redeemedbyuserid_fkey R
registrationcoderedemptions.redeemedbyuserid registrationcoderedemptions_redeemedbyuserid_fkey R
scormattemptresponses.userid scormattemptresponses_userid_fkey R
scormattempts.userid scormattempts_userid_fkey R
sectioncompletions.userid sectioncompletions_userid_fkey R
subscriptionpurchases.userid subscriptionpurchases_userid_fkey R
testimonials.userid testimonials_userid_fkey R
userattendedmeetings.userid userattendedmeetings_userid_fkey R
userbundles.userid userbundles_userid_fkey R
usercourseprogresses.userid usercourseprogresses_userid_fkey R
usercourses.userid usercourses_userid_fkey1 R
userlearningpaths.userid userlearningpaths_userid_fkey R
userlicenses.userid userlicenses_userid_fkey R
waitlists.userid waitlists_userid_fkey R
actions.userid actions_userid_fkey R
assignmentsubmissions.userid assignmentsubmissions_userid_fkey R
awards.userid n_awards_userid_fkey R
certificates.userid certificates_userid_fkey1 R
comments.userid comments_userid_fkey R
competencyassessmentattempts.userid competencyassessmentattempts_userid_fkey1 R
competencyassessmentresponses.userid competencyassessmentresponses_userid_fkey1 R
courseactions.userid courseactions_userid_fkey R
learningpathactions.userid learningpathactions_userid_fkey R
ltiattempts.userid ltiattempts_userid_fkey R
onboardingsurveyresponses.userid onboardingsurveyresponses_userid_fkey R
purchases.userid purchases_userid_fkey R
quizattemptresponses.userid quizattemptresponses_userid_fkey R
quizattempts.userid quizattempts_userid_fkey R
redemptioncodes.redeemedbyuserid redemptioncodes_redeemedbyuserid_fkey R
registrationcoderedemptions.redeemedbyuserid registrationcoderedemptions_redeemedbyuserid_fkey R
scormattemptresponses.userid scormattemptresponses_userid_fkey R
scormattempts.userid scormattempts_userid_fkey R
sectioncompletions.userid sectioncompletions_userid_fkey R
subscriptionpurchases.userid subscriptionpurchases_userid_fkey R
testimonials.userid testimonials_userid_fkey R
userattendedmeetings.userid userattendedmeetings_userid_fkey R
userbundles.userid userbundles_userid_fkey R
usercourseprogresses.userid usercourseprogresses_userid_fkey R
usercourses.userid usercourses_userid_fkey1 R
userlearningpaths.userid userlearningpaths_userid_fkey R
userlicenses.userid userlicenses_userid_fkey R
usertopicprogresses.userid usertopicprogresses_userid_fkey R
views.userid views_userid_fkey R
viewtimes.userid viewtimes_userid_fkey R
waitlists.userid waitlists_userid_fkey R

Unique Identifier of the User
firstname varchar 255 √ null

The firstname of the User
lastname varchar 255 √ null

The lastname of the User
externalcustomerid varchar 255 √ null

The externalcustomerid of 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 zipcode of the User
shippingname varchar 255 √ null

The shippingname of the User
clientid varchar 36 √ null
clients.id users_clientid_fkey R

The clientid of 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
stripecustomerid varchar 36 √ null

The stripecustomerid of the User
createdat timestamp 29,6 √ ('now'::text)::timestamp with time zone

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

The date and time the User was created
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
disabled bool 1 √ false

The disabled of the User
country varchar 255 √ null

The country of the User
updatedat timestamp 29,6 √ ('now'::text)::timestamp with time zone

The date and time the User was created
balance float8 17,17 √ null
sfcontactid varchar 18 √ null
sfaccountid varchar 18 √ null
telephone varchar 65535 √ null
role varchar 65535 √ null
statusgroup varchar 256 √ null
statusgroupupdatedat timestamp 29,6 √ null

Relationships

Close relationships within degrees of separation