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