dbg_pj
Tables (15)
agent_meta
- id — INTEGER — Primary key — NOT NULL
- agent_key — VARCHAR(64) — NOT NULL
- name — VARCHAR(128) — NOT NULL
- llm_id — INTEGER — Foreign key → llm_meta.id
- status_code — VARCHAR(20)
agent_sub_agent_mappings
- id — INTEGER — Primary key — NOT NULL
- parent_agent_id — INTEGER — Foreign key → agent_meta.id — NOT NULL
- sub_agent_id — INTEGER — Foreign key → agent_meta.id — NOT NULL
- priority — INTEGER
agent_tool_mappings
- id — INTEGER — Primary key — NOT NULL
- agent_id — INTEGER — Foreign key → agent_meta.id — NOT NULL
- tool_id — INTEGER — Foreign key → tool_meta.id — NOT NULL
- priority — INTEGER
companies
- company_code — VARCHAR(32) — Primary key — NOT NULL
- company_name — VARCHAR(128) — NOT NULL
- is_active — CHAR(1)
departments
- dept_code — VARCHAR(32) — Primary key — NOT NULL
- company_code — VARCHAR(32) — Foreign key → companies.company_code — NOT NULL
- dept_name — VARCHAR(128) — NOT NULL
- parent_dept_code — VARCHAR(32)
- dept_level — INTEGER
dept_gov_mapping
- company_code — VARCHAR(32) — Primary key — NOT NULL
- dept_code — VARCHAR(32) — Foreign key → departments.dept_code — NOT NULL
- group_id — VARCHAR(32) — Foreign key → gov_standard_groups.group_id
gov_group_orch_map
- group_id — VARCHAR(32) — Foreign key → gov_standard_groups.group_id — NOT NULL
- orch_id — INTEGER — Foreign key → orch_master.id — NOT NULL
- is_enabled — CHAR(1)
gov_standard_groups
- group_id — VARCHAR(32) — Primary key — NOT NULL
- group_name — VARCHAR(128) — NOT NULL
llm_meta
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR(64) — NOT NULL
- full_name — VARCHAR(128)
- status_code — VARCHAR(20)
orch_master
- id — INTEGER — Primary key — NOT NULL
- orch_key — VARCHAR(64) — NOT NULL
- name — VARCHAR(128) — NOT NULL
- strategy_type — VARCHAR(32)
- status_code — VARCHAR(20)
orch_step_configs
- id — INTEGER — Primary key — NOT NULL
- orch_id — INTEGER — Foreign key → orch_master.id — NOT NULL
- agent_id — INTEGER — Foreign key → agent_meta.id — NOT NULL
- step_order — INTEGER — NOT NULL
tool_meta
- id — INTEGER — Primary key — NOT NULL
- tool_key — VARCHAR(64) — NOT NULL
- name — VARCHAR(128) — NOT NULL
- status_code — VARCHAR(20)
user_gov_exception
- employee_id — VARCHAR(32) — Foreign key → users.employee_id — NOT NULL
- exception_group_id — VARCHAR(32) — Foreign key → gov_standard_groups.group_id
user_hr_profile
- employee_id — VARCHAR(32) — Foreign key → users.employee_id — NOT NULL
- company_code — VARCHAR(32) — Foreign key → companies.company_code — NOT NULL
- dept_code — VARCHAR(32) — Foreign key → departments.dept_code — NOT NULL
- username — VARCHAR(128)
- email — VARCHAR(128)
users
- employee_id — VARCHAR(32) — Primary key — NOT NULL
- password_hash — VARCHAR(256)
- role — VARCHAR(20)
- auth_version — INTEGER
- is_locked — CHAR(1)
- status_code — VARCHAR(20)