clients

292724 rows


Description

Client created by the learning site

Columns

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

The ID of the learning site
id varchar 36 null
awards.clientid n_awards_clientid_fkey R
clientcourses.clientid clientcourses_clientid_fkey1 R
clienttags.clientid clienttags_clientid_fkey R
comments.clientid comments_clientid_fkey R
courses.clientid n_courses_clientid_fkey R
creditactions.clientid creditactions_clientid_fkey R
creditbatches.clientid creditbatches_clientid_fkey R
forums.clientid forums_clientid_fkey1 R
licensecourses.clientid licensecourses_clientid_fkey1 R
licenses.clientid n_licenses_clientid_fkey R
onboardingsurveys.clientid onboardingsurveys_clientid_fkey1 R
users.clientid users_clientid_fkey R
visits_backup_20240122.clientid visits_backup_20240122_clientid_fkey R
awards.clientid n_awards_clientid_fkey R
clientcourses.clientid clientcourses_clientid_fkey1 R
clienttags.clientid clienttags_clientid_fkey R
comments.clientid comments_clientid_fkey R
courses.clientid n_courses_clientid_fkey R
creditactions.clientid creditactions_clientid_fkey R
creditbatches.clientid creditbatches_clientid_fkey R
forums.clientid forums_clientid_fkey1 R
licensecourses.clientid licensecourses_clientid_fkey1 R
licenses.clientid n_licenses_clientid_fkey R
onboardingsurveys.clientid onboardingsurveys_clientid_fkey1 R
users.clientid users_clientid_fkey R
views.clientid views_new_id_clientid_fkey R
viewtimes.clientid viewtimes_clientid_fkey R
visits.clientid visits_clientid_fkey1 R

Unique Identifier of the Client
name varchar 255 √ null

The name of the Client
slug varchar 255 √ null

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

The date and time the Client was created
deleted bool 1 √ true
disabled bool 1 √ true
createdat timestamp 29,6 √ null
currentbalance float8 17,17 √ null
startingbalance float8 17,17 √ null
sku varchar 65535 √ null
statusgroup varchar 256 √ null
statusgroupupdatedat timestamp 29,6 √ null

Relationships

Close relationships within degrees of separation