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