companies

3054 rows


Description

Company created by the learning site

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 36 null
assignmentsubmissions.companyid assignmentsubmissions_companyid_fkey R
awards.companyid n_awards_companyid_fkey R
bundles.companyid bundles_companyid_fkey1 R
bundletags.companyid bundletags_companyid_fkey R
certificatefields.companyid certificatefields_companyid_fkey R
certificatefieldsblocks.companyid certificatefieldsblocks_companyid_fkey R
certificates.companyid certificates_companyid_fkey1 R
clientcourses.companyid clientcourses_companyid_fkey1 R
clients.companyid clients_companyid_fkey1 R
clienttags.companyid clienttags_companyid_fkey R
comments.companyid comments_companyid_fkey R
competencyassessmentattempts.companyid competencyassessmentattempts_companyid_fkey1 R
competencyassessmentresponses.companyid competencyassessmentresponses_companyid_fkey1 R
competencyassessments.companyid competencyassessments_companyid_fkey1 R
courseactions.companyid n_courseactions_companyid_fkey R
coursecustomfields.companyid coursecustomfields_companyid_fkey R
coursegroupcustomfields.companyid coursegroupcustomfields_companyid_fkey R
coursegroups.companyid coursegroups_companyid_fkey R
coursegrouptags.companyid coursegrouptags_companyid_fkey R
courses.companyid n_courses_companyid_fkey R
coursetags.companyid n_coursetags_companyid_fkey R
creditactions.companyid creditactions_companyid_fkey R
creditbatches.companyid creditbatches_companyid_fkey R
discountgroups.companyid discountgroups_companyid_fkey1 R
discountgrouptags.companyid discountgrouptags_companyid_fkey R
forums.companyid forums_companyid_fkey1 R
learningpathactions.companyid n_learningpathactions_companyid_fkey R
learningpaths.companyid n_learningpaths_companyid_fkey R
learningpathtags.companyid learningpathtags_companyid_fkey R
lessons.companyid lessons_companyid_fkey1 R
licensecourses.companyid licensecourses_companyid_fkey1 R
licenses.companyid n_licenses_companyid_fkey R
locations.companyid locations_companyid_fkey R
ltiattempts.companyid n_ltiattempts_companyid_fkey R
meetings.companyid meetings_companyid_fkey R
milestonecourses.companyid n_milestonecourses_companyid_fkey R
milestones.companyid n_milestones_companyid_fkey R
onboardingsurveyresponses.companyid onboardingsurveyresponses_companyid_fkey1 R
onboardingsurveys.companyid onboardingsurveys_companyid_fkey1 R
pickablegroups.companyid pickablegroups_companyid_fkey1 R
pickablegrouptags.companyid pickablegrouptags_companyid_fkey R
products.companyid products_companyid_fkey1 R
producttags.companyid producttags_companyid_fkey R
purchases.companyid purchases_companyid_fkey1 R
questionchoices.companyid questionchoices_companyid_fkey R
questions.companyid questions_companyid_fkey R
quizattemptresponses.companyid quizattemptresponses_companyid_fkey1 R
quizattempts.companyid quizattempts_companyid_fkey R
redemptioncodes.companyid redemptioncodes_companyid_fkey R
registrationcoderedemptions.companyid registrationcoderedemptions_companyid_fkey R
registrationcodes.companyid registrationcodes_companyid_fkey R
scormattemptresponses.companyid scormattemptresponses_companyid_fkey1 R
scormattempts.companyid scormattempts_companyid_fkey1 R
sectioncompletions.companyid sectioncompletions_companyid_fkey R
sections.companyid sections_companyid_fkey1 R
subscriptionpurchases.companyid subscriptionpurchases_companyid_fkey1 R
tags.companyid tags_companyid_fkey R
testimonials.companyid testimonials_companyid_fkey1 R
topics.companyid topics_companyid_fkey R
userattendedmeetings.companyid userattendedmeetings_companyid_fkey R
userbundles.companyid userbundles_companyid_fkey1 R
usercourseprogresses.companyid usercourseprogresses_companyid_fkey1 R
usercourses.companyid usercourses_companyid_fkey1 R
userlicenses.companyid userlicenses_companyid_fkey R
users.companyid users_companyid_fkey R
visits_backup_20240122.companyid visits_backup_20240122_companyid_fkey R
waitlists.companyid waitlists_companyid_fkey R
actions.companyid actions_companyid_fkey R
assignmentsubmissions.companyid assignmentsubmissions_companyid_fkey R
awards.companyid n_awards_companyid_fkey R
awardtypes.companyid awardtypes_companyid_fkey R
bundles.companyid bundles_companyid_fkey1 R
bundletags.companyid bundletags_companyid_fkey R
certificatefields.companyid certificatefields_companyid_fkey R
certificatefieldsblocks.companyid certificatefieldsblocks_companyid_fkey R
certificates.companyid certificates_companyid_fkey1 R
clientcourses.companyid clientcourses_companyid_fkey1 R
clients.companyid clients_companyid_fkey1 R
clienttags.companyid clienttags_companyid_fkey R
comments.companyid comments_companyid_fkey R
competencyassessmentattempts.companyid competencyassessmentattempts_companyid_fkey1 R
competencyassessmentresponses.companyid competencyassessmentresponses_companyid_fkey1 R
competencyassessments.companyid competencyassessments_companyid_fkey1 R
courseactions.companyid n_courseactions_companyid_fkey R
coursecertificates.companyid coursecertificates_companyid_fkey1 R
coursecustomfields.companyid coursecustomfields_companyid_fkey R
coursegroupcustomfields.companyid coursegroupcustomfields_companyid_fkey R
coursegroups.companyid coursegroups_companyid_fkey R
coursegrouptags.companyid coursegrouptags_companyid_fkey R
courseinstructormessages.companyid courseinstructormessages_companyid_fkey1 R
courses.companyid n_courses_companyid_fkey R
coursetags.companyid n_coursetags_companyid_fkey R
creditactions.companyid creditactions_companyid_fkey R
creditbatches.companyid creditbatches_companyid_fkey R
discountgroups.companyid discountgroups_companyid_fkey1 R
discountgrouptags.companyid discountgrouptags_companyid_fkey R
emailactivity.companyid n_emailactivity_companyid_fkey R
emailcaptures.companyid emailcaptures_companyid_fkey1 R
forums.companyid forums_companyid_fkey1 R
learningpathactions.companyid n_learningpathactions_companyid_fkey R
learningpaths.companyid n_learningpaths_companyid_fkey R
learningpathtags.companyid learningpathtags_companyid_fkey R
lessons.companyid lessons_companyid_fkey1 R
licensecourses.companyid licensecourses_companyid_fkey1 R
licenses.companyid n_licenses_companyid_fkey R
locations.companyid locations_companyid_fkey R
ltiattempts.companyid n_ltiattempts_companyid_fkey R
meetings.companyid meetings_companyid_fkey R
milestonecourses.companyid n_milestonecourses_companyid_fkey R
milestones.companyid n_milestones_companyid_fkey R
newslettersignups.companyid newslettersignups_companyid_fkey1 R
onboardingsurveyresponses.companyid onboardingsurveyresponses_companyid_fkey1 R
onboardingsurveys.companyid onboardingsurveys_companyid_fkey1 R
pickablegroups.companyid pickablegroups_companyid_fkey1 R
pickablegrouptags.companyid pickablegrouptags_companyid_fkey R
products.companyid products_companyid_fkey1 R
producttags.companyid producttags_companyid_fkey R
purchases.companyid purchases_companyid_fkey1 R
questionchoices.companyid questionchoices_companyid_fkey R
questions.companyid questions_companyid_fkey R
quizattemptresponses.companyid quizattemptresponses_companyid_fkey1 R
quizattempts.companyid quizattempts_companyid_fkey R
redemptioncoderedeems.companyid redemptioncoderedeems_companyid_fkey1 R
redemptioncodes.companyid redemptioncodes_companyid_fkey R
registrationcoderedemptions.companyid registrationcoderedemptions_companyid_fkey R
registrationcodes.companyid registrationcodes_companyid_fkey R
registrations.companyid registrations_companyid_fkey1 R
scormattemptresponses.companyid scormattemptresponses_companyid_fkey1 R
scormattempts.companyid scormattempts_companyid_fkey1 R
sectioncompletions.companyid sectioncompletions_companyid_fkey R
sections.companyid sections_companyid_fkey1 R
sessions.companyid sessions_companyid_fkey1 R
subscriptioncancels.companyid subscriptioncancels_companyid_fkey1 R
subscriptionpurchases.companyid subscriptionpurchases_companyid_fkey1 R
tags.companyid tags_companyid_fkey R
testimonials.companyid testimonials_companyid_fkey1 R
topics.companyid topics_companyid_fkey R
userattendedmeetings.companyid userattendedmeetings_companyid_fkey R
userbundles.companyid userbundles_companyid_fkey1 R
usercourseprogresses.companyid usercourseprogresses_companyid_fkey1 R
usercourses.companyid usercourses_companyid_fkey1 R
userlicenses.companyid userlicenses_companyid_fkey R
users.companyid users_companyid_fkey R
usertopicprogresses.companyid usertopicprogresses_companyid_fkey R
views.companyid views_new_id_companyid_fkey R
viewtimes.companyid viewtimes_companyid_fkey R
visits.companyid visits_companyid_fkey1 R
waitlists.companyid waitlists_companyid_fkey R

Unique Identifier of the Company
name varchar 255 √ null

The name of the Company
customhost varchar 255 √ null

The customhost of the Company
subdomain varchar 255 √ null

The subdomain of the Company
organizationid varchar 36 √ null
organizations.id n_companies_organizationid_fkey R

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

The date and time the Company was created
rdbgroup varchar 255 √ null
statusgroup varchar 256 √ null
statusgroupupdatedat timestamp 29,6 √ null

Relationships

Close relationships within degrees of separation