tasplatform

Tables (16)

admin_config (app_config)

  • config_id — TINYINT — Primary key — NOT NULL
  • setting_type
  • server_url
  • model_id
  • api_key
  • api_route
  • response_timeout
  • cf_service_name

attachments

  • document_id — BIGINT — Primary key — NOT NULL
  • request_id — BIGINT — Foreign key → cases.request_id — NOT NULL
  • thread_id — BIGINT
  • doc_name — VARCHAR(255)
  • doc_path — VARCHAR(255)
  • content_type — VARCHAR(255)
  • file_size — BIGINT
  • uploaded_by — VARCHAR(255)
  • uploaded_at — VARCHAR(255)
  • uploaded_ms — BIGINT
  • fetched_at — VARCHAR(255)

cases

  • request_id — BIGINT — Primary key — NOT NULL
  • request_id_formatted — VARCHAR(255)
  • subject — VARCHAR(255)
  • status — VARCHAR(255)
  • priority — VARCHAR(255)
  • category — VARCHAR(255)
  • party_name — VARCHAR(255)
  • party_site_number — VARCHAR(255)
  • created_on — VARCHAR(255)
  • created_on_ms — BIGINT
  • last_updated — VARCHAR(255)
  • last_updated_ms — BIGINT
  • first_seen_at — VARCHAR(255)
  • CREATE — TABLE — NOT NULL
  • team_id — CHAR(36) — Foreign key → teams.team_id — NOT NULL

chat_rooms

  • chat_room_id — CHAR(36) — Primary key — NOT NULL
  • owner_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200)
  • message_count — INT — NOT NULL
  • last_message_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • text_save_path
  • agent_profile_id
  • context_summary

inspection

  • inspection_id — BIGINT — Primary key — NOT NULL
  • month — VARCHAR(7) — NOT NULL
  • title — VARCHAR(255)
  • status — VARCHAR(255)
  • created_at — VARCHAR(255)
  • updated_at — VARCHAR(255)
  • team_id — CHAR(36) — Foreign key → teams.team_id — NOT NULL

instance_counts

  • inspection_id — BIGINT — Foreign key → inspection.inspection_id — NOT NULL
  • bank_dev — DECIMAL(18,2)
  • bank_prod — DECIMAL(18,2)
  • bank_dr — DECIMAL(18,2)
  • central_dev — DECIMAL(18,2)
  • central_prod — DECIMAL(18,2)
  • central_dr — DECIMAL(18,2)
  • shared_dev — DECIMAL(18,2)
  • shared_prod — DECIMAL(18,2)
  • shared_dr — DECIMAL(18,2)
  • container_bank_prod — DECIMAL(18,2)
  • container_bank_total — DECIMAL(18,2)
  • container_bank_dev — DECIMAL(18,2)
  • conatiner_central_total — DECIMAL(18,2)
  • container_central_prod — DECIMAL(18,2)
  • container_central_dev — DECIMAL(18,2)
  • saved_at — VARCHAR(255)

llm_model (Untitled)

  • llm_id — Primary key — NOT NULL
  • connection_name
  • model_id
  • api_path
  • auth_type
  • api_key
  • token_url
  • client_id
  • auth_user_name
  • auth_passwd
  • chat_api_path
  • max_output_token
  • temperature
  • system_prompt
  • using — boolean
  • allow_for_user — boolean
  • llm_tls_auth_omission — boolean
  • keycloak_tls_auth_omission — boolean

message_attachments

  • attachment_id — CHAR(36) — Primary key — NOT NULL
  • message_id — CHAR(36) — Foreign key → messages.message_id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • mime_type — VARCHAR(100)
  • byte_size — BIGINT
  • storage_key — VARCHAR(512) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

message_feedback

  • feedback_id — CHAR(36) — Primary key — NOT NULL
  • message_id — CHAR(36) — Foreign key → messages.message_id — NOT NULL
  • user_id — CHAR(36) — NOT NULL
  • rating — TINYINT — NOT NULL
  • comment — TEXT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

message_tool_calls (Untitled2)

  • tool_call_id — Primary key — NOT NULL
  • message_id — CHAR(36) — Foreign key → messages.message_id — NOT NULL
  • turn_id
  • tool_name
  • arguments
  • side_effect
  • status
  • approved_by
  • approved_at
  • run_id
  • created_at
  • finished_at
  • error_message

messages

  • message_id — CHAR(36) — Primary key — NOT NULL
  • chat_room_id — CHAR(36) — Foreign key → chat_rooms.chat_room_id — NOT NULL
  • sender_user_id — CHAR(36)
  • role — VARCHAR(16) — NOT NULL
  • content — MEDIUMTEXT
  • status — VARCHAR(16) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • turn_id
  • is_visible
  • stop_reason

report_picks

  • pick_id — BIGINT — Primary key — NOT NULL
  • inspection_id — BIGINT — Foreign key → inspection.inspection_id — NOT NULL
  • kind — VARCHAR(255) — NOT NULL
  • ref — VARCHAR(255) — NOT NULL
  • ord — INT

team_members

  • user_id — CHAR(36) — Primary key — NOT NULL
  • team_id — CHAR(36) — Foreign key → teams.team_id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • joined_at — DATETIME(6) — NOT NULL

teams

  • team_id — CHAR(36) — Primary key — NOT NULL
  • team_name — VARCHAR(100) — NOT NULL
  • owner_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • deleted_at — DATETIME(6)

threads

  • thread_id — BIGINT — Primary key — NOT NULL
  • request_id — BIGINT — Foreign key → cases.request_id — NOT NULL
  • author_unit — VARCHAR(255)
  • author_unit_id — BIGINT
  • is_ours — INT
  • res_date_ms — BIGINT
  • res_date_val — VARCHAR(255)
  • body_html — TEXT
  • body_text — TEXT
  • fetched_at — VARCHAR(255)

users

  • user_id — CHAR(36) — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • password_hash (password) — VARCHAR(255) — NOT NULL
  • last_login — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL