app_tenant

0 rows


Description

Totara Tenant information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_tenant_id_seq'::regclass)
app_context.tenantid Defined in XML R
app_report_builder.tenantid Defined in XML R
app_totara_api_client.tenant_id Defined in XML R
app_totara_dashboard.tenantid Defined in XML R
app_totara_oauth2_client_provider.tenant_id Defined in XML R
app_user.tenantid Defined in XML R
name varchar 1333 ''::character varying
idnumber varchar 100 ''::character varying
description text 2147483647 null
descriptionformat int2 5 1
suspended int2 5 0
categoryid int8 19 null
app_course_categories.id Defined in XML R
cohortid int8 19 null
app_cohort.id Defined in XML R
timecreated int8 19 null
usercreated int8 19 null
app_user.id Defined in XML R

Indexes

Constraint Name Type Sort Column(s)
app_tena_id_pk Primary key Asc id
app_tena_cat_uix Must be unique Asc categoryid
app_tena_coh_uix Must be unique Asc cohortid
app_tena_idn_uix Must be unique Asc idnumber
app_tena_use_ix Performance Asc usercreated

Relationships

Close relationships within degrees of separation