tenants


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
invoices.tenant_id FKld79gsqsmww43uddpxajoxts0 R
support_tickets.tenant_id FK9quarmxtby8e03c66wxdec57h R
tenant_ai_quotas.tenant_id FKe37btlv3vivlwr4jtkt6p2gsp R
tenant_ai_usage_periods.tenant_id FK1jemr8kep1xm5gnq07brgls2o R
tenant_payment_methods.tenant_id FK23e8q1rwjrj0uohiv3jseai5a R
tenant_subscriptions.tenant_id FKbpmvmu3al4jtfo7sldlc5k4rh R
cognito_app_client_id VARCHAR 255 √ null
cognito_pool_id VARCHAR 255 √ null
cognito_region VARCHAR 255 √ null
created_at DATETIME 26 null
created_by VARCHAR 255 √ null
database_name VARCHAR 255 null
name VARCHAR 255 null
status enum('ACTIVE', 'SUSPENDED', 'TRIAL') 9 null
subdomain VARCHAR 255 null
updated_at DATETIME 26 null
updated_by VARCHAR 255 √ null
npi VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UK1ipt5tmyu3wy4kg3cjeyf1tjo Must be unique Asc npi
UK3oxudk5skrixdpwx3jdqb0e71 Must be unique Asc database_name
UK4moql6miwoh3w0drxa2gmjbll Must be unique Asc name
UKowdadmekvhjx3lk2yt24s9pyw Must be unique Asc subdomain

Relationships

Close relationships within degrees of separation