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