simsimi_gpt
Tables (15)
api_keys
- api_key_id — UUID
- institution_id — UUID — NOT NULL
- api_key_hash — VARCHAR(255) — NOT NULL
- api_key_name — VARCHAR(255)
- is_active — BOOLEAN
- expires_at — TIMESTAMP
- created_at — TIMESTAMP
- last_used_at — TIMESTAMP
chat_sessions
- session_id — UUID
- user_id — UUID — NOT NULL
- model_id — UUID — NOT NULL
- session_title — VARCHAR(255)
- total_tokens_used — INTEGER
- total_cost — DECIMAL(10,4)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
groups
- group_id — UUID
- institution_id — UUID — NOT NULL
- group_name — VARCHAR(255) — NOT NULL
- group_type — VARCHAR(50)
- description — TEXT
- created_by — UUID
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
institutions
- institution_id — UUID
- institution_name — VARCHAR(255) — NOT NULL
- institution_type — VARCHAR(50)
- business_number — VARCHAR(20)
- address — TEXT
- phone — VARCHAR(20)
- email — VARCHAR(255)
- contact_person — VARCHAR(100)
- token_balance — DECIMAL(15,2)
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
llm_models
- model_id — UUID
- model_name — VARCHAR(255) — NOT NULL
- provider — VARCHAR(100)
- model_version — VARCHAR(50)
- token_cost_per_request — DECIMAL(10,6)
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
messages
- message_id — UUID
- session_id — UUID — NOT NULL
- message_type — VARCHAR(20)
- content — TEXT — NOT NULL
- tokens_used — INTEGER
- cost — DECIMAL(10,6)
- created_at — TIMESTAMP
notifications
- notification_id — UUID
- user_id — UUID — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- notification_type — VARCHAR(20)
- is_read — BOOLEAN
- created_at — TIMESTAMP
- read_at — TIMESTAMP
payments
- payment_id — UUID
- institution_id — UUID — NOT NULL
- package_id — UUID — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- payment_status — VARCHAR(20)
- payment_method — VARCHAR(50)
- payment_gateway_id — VARCHAR(255)
- created_at — TIMESTAMP
- completed_at — TIMESTAMP
system_settings
- setting_id — UUID
- setting_key — VARCHAR(255) — NOT NULL
- setting_value — TEXT
- description — TEXT
- updated_at — TIMESTAMP
templates
- template_id — UUID
- template_name — VARCHAR(255) — NOT NULL
- category — VARCHAR(50)
- prompt_template — TEXT — NOT NULL
- description — TEXT
- created_by — UUID
- institution_id — UUID
- group_id — UUID
- visibility — VARCHAR(20)
- usage_count — INTEGER
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
token_packages
- package_id — UUID
- package_name — VARCHAR(255) — NOT NULL
- token_amount — DECIMAL(15,2) — NOT NULL
- price — DECIMAL(10,2) — NOT NULL
- description — TEXT
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
token_transactions
- transaction_id — UUID
- institution_id — UUID — NOT NULL
- transaction_type — VARCHAR(20)
- amount — DECIMAL(15,2) — NOT NULL
- balance_before — DECIMAL(15,2) — NOT NULL
- balance_after — DECIMAL(15,2) — NOT NULL
- description — TEXT
- created_by — UUID
- created_at — TIMESTAMP
usage_statistics
- stat_id — UUID
- stat_date — DATE — NOT NULL
- user_id — UUID
- institution_id — UUID
- group_id — UUID
- model_id — UUID
- total_requests — INTEGER
- total_tokens — DECIMAL(15,2)
- total_cost — DECIMAL(10,4)
- created_at — TIMESTAMP
user_template_favorites
- favorite_id — UUID
- user_id — UUID — NOT NULL
- template_id — UUID — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(user_id, — template_id)
users
- user_id — UUID
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- user_type — VARCHAR(20)
- institution_id — UUID
- group_id — UUID
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- last_login_at — TIMESTAMP