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