admin

Tables (12)

admin_audit_log

  • audit_key — bigserial — Primary key — NOT NULL
  • actor_id — varchar(50) — NOT NULL
  • actor_key — bigint
  • action — varchar(50) — NOT NULL
  • target_id — varchar(100)
  • target_name — varchar(100)
  • detail — text
  • ip_address — varchar(45)
  • request_id — varchar(50)
  • reg_date — timestamp — NOT NULL

admin_info

  • admin_key — bigserial — Primary key — NOT NULL
  • admin_id — varchar(50) — NOT NULL
  • admin_nm — varchar(100) — NOT NULL
  • password — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • phone_number — varchar(20)
  • role — varchar(20) — NOT NULL
  • deleted — boolean — NOT NULL
  • admin_status — smallint — NOT NULL
  • auth_fail_cnt — smallint — NOT NULL
  • first_login — boolean — NOT NULL
  • reg_date — timestamp — NOT NULL
  • last_login_date — timestamp
  • locked_date — timestamp
  • mod_date — timestamp — NOT NULL
  • del_date — timestamp

agent_info

  • agent_key — bigserial — Primary key — NOT NULL
  • agent_nm — varchar(100) — NOT NULL
  • description — text
  • policy_key — bigint — Foreign key → policy_info.policy_key — NOT NULL
  • agent_status — varchar(20) — NOT NULL
  • last_called_date — timestamp
  • deleted — boolean — NOT NULL
  • reg_date — timestamp — NOT NULL
  • mod_date — timestamp — NOT NULL
  • del_date — timestamp

api_key

  • key_id — bigserial — Primary key — NOT NULL
  • agent_key — bigint — Foreign key → agent_info.agent_key — NOT NULL
  • api_key_hash — varchar(64) — NOT NULL
  • api_key_prefix — varchar(20) — NOT NULL
  • secret_cipher — bytea — NOT NULL
  • secret_iv — bytea — NOT NULL
  • key_version — smallint — NOT NULL
  • status — varchar(20) — NOT NULL
  • issued_at — timestamp — NOT NULL
  • expires_at — timestamp
  • last_used_at — timestamp
  • revoked_at — timestamp

guardrail_execution

  • exec_key — bigserial — Primary key — NOT NULL
  • request_id — varchar(64) — NOT NULL
  • policy_key — bigint
  • agent_key — bigint
  • status — varchar(8) — NOT NULL
  • input_blocked — boolean
  • output_blocked — boolean
  • blocked_layer — varchar(4)
  • error_reason — varchar(32)
  • model — varchar(64)
  • total_ms — int
  • llm_ms — int
  • prompt_masked — text
  • prompt_cipher — bytea
  • prompt_iv — bytea
  • key_version — smallint
  • created_at — timestamptz — NOT NULL

guardrail_finding

  • finding_key — bigserial — Primary key — NOT NULL
  • exec_key — bigint — Foreign key → guardrail_layer.exec_key — NOT NULL
  • stage — varchar(8) — Foreign key → guardrail_layer.stage — NOT NULL
  • layer_id — varchar(4) — Foreign key → guardrail_layer.layer_id — NOT NULL
  • category — varchar(48)
  • score — real
  • span_start — int
  • span_end — int
  • metadata — jsonb

guardrail_layer

  • stage — varchar(8) — Primary key — NOT NULL
  • layer_id — varchar(4) — Primary key — NOT NULL
  • exec_key — bigint — Foreign key → guardrail_execution.exec_key — NOT NULL
  • action — varchar(8)
  • status — varchar(8) — NOT NULL
  • latency_ms — int

layer_info

  • layer_key — varchar(8) — Primary key — NOT NULL
  • layer_nm — varchar(50) — NOT NULL
  • description — text
  • layer_status — varchar(20) — NOT NULL
  • use_model — boolean — NOT NULL

mail_config

  • id — smallint — Primary key — NOT NULL
  • host — varchar(255) — NOT NULL
  • port — integer — NOT NULL
  • username — varchar(255) — NOT NULL
  • from_address — varchar(255) — NOT NULL
  • cert_verify — boolean — NOT NULL
  • password_cipher — bytea — NOT NULL
  • password_iv — bytea — NOT NULL
  • password_key_version — smallint — NOT NULL
  • mod_date — timestamp

option_info

  • option_key — varchar(100) — Primary key — NOT NULL
  • option_value — varchar(500) — NOT NULL
  • mod_date — timestamp — NOT NULL

policy_info

  • policy_key — bigserial — Primary key — NOT NULL
  • policy_nm — varchar(100) — NOT NULL
  • description — text
  • policy_hash — varchar(64)
  • policy_status — varchar(20) — NOT NULL
  • deleted — boolean — NOT NULL
  • reg_date — timestamp — NOT NULL
  • mod_date — timestamp — NOT NULL
  • del_date — timestamp

policy_layer

  • direction — varchar(8) — Primary key — NOT NULL
  • policy_key — bigint — Foreign key → policy_info.policy_key — NOT NULL
  • layer_key — varchar(8) — Foreign key → layer_info.layer_key — NOT NULL
  • enabled — boolean — NOT NULL
  • action — varchar(20)
  • mode — varchar(20)
  • scan_system — boolean — NOT NULL
  • scan_user — boolean — NOT NULL
  • options — jsonb