learningpaths

58635 rows


Description

Learning Path created by the learning site

Columns

Column Type Size Nulls Auto Default Children Parents Comments
accessdays int4 10 √ null

The accessday of the Learning Path
asset varchar 255 √ null

The asset of the Learning Path
certificatetemplateblockid varchar 36 √ null

The certificatetemplateblockid of the Learning Path
companyid varchar 36 √ null
companies.id n_learningpaths_companyid_fkey R

The ID of the learning site
confirmationblockid varchar 36 √ null

The confirmationblockid of the Learning Path
contenttype varchar 255 √ null

The contenttype of the Learning Path
createdat timestamp 29,6 √ null

The date and time the Learning Path was created
deleted bool 1 √ false

The deleted of the Learning Path
detailasset varchar 255 √ null

The detailasset of the Learning Path
enddate timestamp 29,6 √ null

The date and time the Learning Path was created
enrollmentenddate timestamp 29,6 √ null

The date and time the Learning Path was created
enrollmentstartdate timestamp 29,6 √ null

The date and time the Learning Path was created
freewithregistration bool 1 √ false

The freewithregistration of the Learning Path
heroasset varchar 255 √ null

The heroasset of the Learning Path
id varchar 36 null
certificates.learningpathid certificates_learningpathid_fkey1 R
learningpathactions.learningpathid learningpathactions_learningpathid_fkey1 R
learningpathtags.learningpathid learningpathtags_learningpathid_fkey R
milestones.learningpathid n_milestones_learningpathid_fkey R
userlearningpaths.learningpathid userlearningpaths_learningpathid_fkey R
certificates.learningpathid certificates_learningpathid_fkey1 R
learningpathactions.learningpathid learningpathactions_learningpathid_fkey1 R
learningpathtags.learningpathid learningpathtags_learningpathid_fkey R
milestones.learningpathid n_milestones_learningpathid_fkey R
userlearningpaths.learningpathid userlearningpaths_learningpathid_fkey R

Unique Identifier of the Learning Path
layoutid varchar 36 √ null

The layoutid of the Learning Path
longdescription varchar 65535 √ null

The longdescription of the Learning Path
metadescription varchar 65535 √ null

The metadescription of the Learning Path
metatitle varchar 255 √ null

The metatitle of the Learning Path
name varchar 255 √ null

The name of the Learning Path
priceincents int4 10 √ null

The priceincent of the Learning Path
ribbon varchar 36 √ null

The ribbon of the Learning Path
shortdescription varchar 65535 √ null

The shortdescription of the Learning Path
sku varchar 255 √ null

The sku of the Learning Path
slug varchar 255 √ null

The slug of the Learning Path
startdate timestamp 29,6 √ null

The date and time the Learning Path was created
status varchar 255 √ null

The status of the Learning Path
suggestedretailpriceincents int4 10 √ null

The suggestedretailpriceincent of the Learning Path
updatedat timestamp 29,6 √ ('now'::text)::timestamp with time zone

The date and time the Learning Path was created
statusgroup varchar 256 √ null
statusgroupupdatedat timestamp 29,6 √ null

Relationships

Close relationships within degrees of separation