a!port
Tables (10)
Tool (tool)
- tool_id — Primary key — NOT NULL
- name
- description
Tool_agent (Untitled)
- tool_id — Foreign key → Tool.tool_id — NOT NULL
- agent_id — Foreign key → agent.agent_id — NOT NULL
agent
- agent_id — Primary key — NOT NULL
- name — VARCHAR(150) — NOT NULL
- description — TEXT
- version — VARCHAR(20) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- agent_type — VARCHAR(30) — NOT NULL
- size_type — VARCHAR(30) — NOT NULL
- tags — JSONB
- config_json — JSONB
- owner_employee_id — UUID — Foreign key
- registered_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- model_type
- cost_per_call
agent_category
- id — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- domain — VARCHAR(50) — NOT NULL
- description — TEXT
agent_category_map
- map_id — UUID — Primary key
- agent_id — UUID — Foreign key — NOT NULL
- category_id — Foreign key → agent_category.id — NOT NULL
department
- department_id — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP — NOT NULL
employee
- employee_id — UUID — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password
- position — VARCHAR(100)
- role — VARCHAR(50) — NOT NULL
- department_id — UUID — Foreign key
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
subscription
- subscription_id — Primary key — NOT NULL
- agent_id — UUID — Foreign key — NOT NULL
- approved_by — UUID
- status — VARCHAR(30) — NOT NULL
- call_limit — INT
- token_limit — BIGINT
- requested_at — TIMESTAMP — NOT NULL
- approved_at — TIMESTAMP
- expires_at — TIMESTAMP
- department_id — Foreign key → department.department_id — NOT NULL
transaction
- tx_id — Primary key — NOT NULL
- wallet_id — UUID — Foreign key — NOT NULL
- agent_id — UUID
- employee_id — UUID
- subscription_id — UUID
- tx_type — VARCHAR(30) — NOT NULL
- points_delta — BIGINT — NOT NULL
- call_count — INT — NOT NULL
- token_count — BIGINT — NOT NULL
- kafka_topic — VARCHAR(200)
- kafka_partition — INT
- kafka_offset — BIGINT
- occurred_at — TIMESTAMP — NOT NULL
wallet
- wallet_id — Primary key — NOT NULL
- department_id — UUID — Foreign key — NOT NULL
- total_points — BIGINT — NOT NULL
- remaining_points — BIGINT — NOT NULL
- alert_threshold — BIGINT — NOT NULL
- updated_at — TIMESTAMP — NOT NULL