OpenFire

Tables (22)

auth

  • id — TEXT
  • email — TEXT
  • password — TEXT
  • active — BOOLEAN

channel

  • id — TEXT
  • user_id — TEXT
  • type — TEXT
  • name — TEXT
  • description — TEXT
  • data — JSON
  • meta — JSON
  • access_control — JSON
  • created_at — BIGINT
  • updated_at — BIGINT

chat

  • id — TEXT
  • user_id — TEXT
  • title — TEXT
  • chat — JSON
  • created_at — BIGINT
  • updated_at — BIGINT
  • share_id — TEXT
  • archived — BOOLEAN
  • pinned — BOOLEAN
  • meta — JSON
  • folder_id — TEXT

document

  • id — TEXT
  • collection_name — TEXT
  • name — TEXT
  • title — TEXT — NOT NULL
  • filename — TEXT — NOT NULL
  • content — TEXT
  • user_id — TEXT — NOT NULL
  • timestamp — BIGINT — NOT NULL
  • created_at — BIGINT
  • updated_at — BIGINT

feedback

  • id — TEXT
  • user_id — TEXT
  • version — BIGINT
  • type — TEXT
  • data — JSON
  • meta — JSON
  • snapshot — JSON
  • created_at — BIGINT
  • updated_at — BIGINT

file

  • id — TEXT
  • user_id — TEXT
  • hash — TEXT
  • filename — TEXT
  • path — TEXT
  • data — JSON
  • meta — JSON
  • access_control — JSON
  • created_at — BIGINT
  • updated_at — BIGINT

folder

  • id — TEXT
  • parent_id — TEXT
  • user_id — TEXT
  • name — TEXT
  • items — JSON
  • meta — JSON
  • is_expanded — BOOLEAN
  • created_at — BIGINT
  • updated_at — BIGINT

function

  • id — TEXT
  • user_id — TEXT
  • name — TEXT
  • type — TEXT
  • content — TEXT
  • meta — JSON
  • valves — JSON
  • is_active — BOOLEAN
  • is_global — BOOLEAN
  • created_at — BIGINT
  • updated_at — BIGINT

group

  • id — TEXT
  • user_id — TEXT
  • name — TEXT
  • description — TEXT
  • data — JSON
  • meta — JSON
  • permissions — JSON
  • user_ids — JSON
  • created_at — BIGINT
  • updated_at — BIGINT

knowledge

  • id — TEXT
  • user_id — TEXT
  • name — TEXT
  • description — TEXT
  • data — JSON
  • meta — JSON
  • access_control — JSON
  • created_at — BIGINT
  • updated_at — BIGINT

memory

  • id — TEXT
  • user_id — TEXT
  • content — TEXT
  • created_at — BIGINT
  • updated_at — BIGINT

message

  • id — TEXT
  • user_id — TEXT
  • channel_id — TEXT
  • parent_id — TEXT
  • content — TEXT
  • data — JSON
  • meta — JSON
  • created_at — BIGINT
  • updated_at — BIGINT

message_reaction

  • id — TEXT
  • user_id — TEXT
  • message_id — TEXT
  • name — TEXT
  • created_at — BIGINT

migrate_history

  • id — SERIAL
  • name — VARCHAR(255) — NOT NULL
  • migrated_at — TIMESTAMP

model

  • id — TEXT
  • user_id — TEXT
  • base_model_id — TEXT
  • name — TEXT
  • params — JSON
  • meta — JSON
  • access_control — JSON
  • is_active — BOOLEAN
  • created_at — BIGINT
  • updated_at — BIGINT

payment_log

  • id — TEXT
  • user_id — TEXT
  • subscription_id — TEXT
  • amount_cents — INTEGER
  • currency — TEXT
  • status — TEXT
  • paid_at — TIMESTAMP
  • payment_method — TEXT
  • raw_response — JSON

plan

  • id — TEXT
  • name — TEXT
  • description — TEXT
  • price_cents — INTEGER
  • currency — TEXT
  • is_active — BOOLEAN
  • features — JSON

prompt

  • command — TEXT
  • user_id — TEXT
  • title — TEXT
  • content — TEXT
  • timestamp — BIGINT
  • access_control — JSON

subscription

  • id — TEXT
  • user_id — TEXT
  • plan_id — TEXT
  • start_date — TIMESTAMP
  • end_date — TIMESTAMP
  • is_active — BOOLEAN
  • payment_provider — TEXT
  • provider_subscription_id — TEXT
  • metadata — JSON

tag

  • id — TEXT — Primary key — NOT NULL
  • user_id — TEXT — Primary key — NOT NULL
  • name — TEXT
  • meta — JSON

tool

  • id — TEXT
  • user_id — TEXT
  • name — TEXT
  • content — TEXT
  • specs — JSON
  • meta — JSON
  • valves — JSON
  • access_control — JSON
  • created_at — BIGINT
  • updated_at — BIGINT

user

  • id — TEXT
  • name — TEXT
  • email — TEXT
  • role — TEXT
  • profile_image_url — TEXT
  • last_active_at — BIGINT
  • updated_at — BIGINT
  • created_at — BIGINT
  • api_key — TEXT
  • settings — JSON
  • info — JSON
  • oauth_sub — TEXT