Previous Topic: ca_state_province TableNext Topic: ca_tenant_group Table


ca_tenant Table

This table lists information about a tenant.

Column

Type

Remarks

id

UUID

ID

name

STRING 255

Specifies the tenant name.

tenant_number

STRING 30

Specifies the alternate tenant identification (customer comment; no OTB use)

service_provider

INTEGER

1—Service Provider tenant

contact

SREL cnt

Specifies the primary contact for the tenant .

logo

STRING 255

Specifies the URL of the tenant logo.

description

STRING 1024

 

phone_number

STRING 255

 

fax_phone

STRING 255

 

alt_phone

STRING 255

 

location

SREL loc

Specifies the location of the tenant .

inactive

INTEGER

1—tenant deleted

version number

INTEGER

Specifies the update version of this tenant (incremented whenever tenant is saved).

tenant

UUID (SREL tenant)

Always specifies the same value as the ID

ldap_tenant_group

STRING 512

Specifies the name of the LDAP group that corresponds to this tenant.

subtenants_ok

INTEGER

1—tenant is allowed to have subtenants

fkey_group

UUID (SREL tenant_group)

Specifies the tenant group to which objects that belong to this tenant can reference. Same as the supertenant group. System-maintained (cannot be edited).

supertenant_group

UUID (SREL tenant_group)

Specifies the tenant group that includes the tenant and higher tenants in this hierarchy. Can include the service provider (if in the same hierarchy). System-maintained (cannot be edited).

subtenant_group

UUID (SREL tenant_group)

Specifies the tenant group that includes the tenant and lower tenants in this hierarchy. System-maintained (cannot be edited).

relatedtenant_group

UUID (SREL tenant_group)

Specifies the tenant group that includes all tenants in this hierarchy (includes the subtenant and supertenant groups). Can include the service provider (if in the same hierarchy). System-maintained (cannot be edited).

tenant_depth

INTEGER

Specifies the number of levels above the tenant in this hierarchy. System-maintained (cannot be edited).

parent

UUID

Specifies the tenant immediately above this tenant in the hierarchy.

creation_user

STRING 64

Specifies the user ID of contact who created this tenant.

creation_date

INTEGER

Specifies the date of tenant creation (number of seconds after 0000 hours on 01/01/1970).

last_update_user

STRING 64

Specifies the user ID of contact who last updated this tenant.

last_update_date

INTEGER

Specifies the date of last update (number of seconds after 0000 hours on 01/01/1970).

terms_of_usage

UUID REF ca_tou

Specifies the terms of usage associated with the tenant.