Query

ontos.db — tenants

SQL

CREATE TABLE tenants  (
  id VARCHAR(50) NOT NULL,
  name VARCHAR(255) NOT NULL,
  description TEXT,
  license_tier JSON,
  status JSON NOT NULL,
  primary_contact_email VARCHAR(255),
  organization VARCHAR(255),
  admin_user_ids JSON,
  settings JSON,
  usage_limits JSON,
  current_usage JSON,
  subscription_id VARCHAR(255),
  subscription_expires_at JSON,
  created_at JSON NOT NULL,
  updated_at JSON NOT NULL,
  last_active_at JSON,
  deleted BOOLEAN,
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(50) ✓ Rename | Drop
name VARCHAR(255) Rename | Drop
description TEXT ✓ Rename | Drop
license_tier JSON ✓ Rename | Drop
status JSON Rename | Drop
primary_contact_email VARCHAR(255) ✓ Rename | Drop
organization VARCHAR(255) ✓ Rename | Drop
admin_user_ids JSON ✓ Rename | Drop
settings JSON ✓ Rename | Drop
usage_limits JSON ✓ Rename | Drop
current_usage JSON ✓ Rename | Drop
subscription_id VARCHAR(255) ✓ Rename | Drop
subscription_expires_at JSON ✓ Rename | Drop
created_at JSON Rename | Drop
updated_at JSON Rename | Drop
last_active_at JSON ✓ Rename | Drop
deleted BOOLEAN ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_tenants_1 id ✓ SQL
-- no sql found --
 Drop