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