Langchain-v3
Tables (33)
AGENT
- AGENT_ID — VARCHAR(36) — Primary key — NOT NULL
- AGENT_NAME — VARCHAR(255) — NOT NULL
- DESCRIPTION — TEXT
- CONFIGURATION_JSON — TEXT
- IS_ACTIVE — BOOLEAN — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME
AGENT_TOOLS
- AGENT_ID — VARCHAR(36) — Primary key — NOT NULL
- TOOL_ID — VARCHAR(36) — Primary key — NOT NULL
- ASSIGNED_AT — DATETIME — NOT NULL
AUTH
- USER_ID — VARCHAR(36) — Primary key — NOT NULL
- USER_LOGIN_ID — VARCHAR(100) — NOT NULL
- USER_PASSWORD — VARCHAR(255) — NOT NULL
- LAST_LOGIN_AT — DATETIME
CHAT_SESSIONS
- SESSION_ID — VARCHAR(36) — Primary key — NOT NULL
- USER_ID — VARCHAR(36) — NOT NULL
- STARTED_AT — DATETIME — NOT NULL
- ENDED_AT — DATETIME
EXECUTION_LOG
- EXECUTION_ID — VARCHAR(36) — Primary key — NOT NULL
- QUERY_ID — VARCHAR(36) — NOT NULL
- EXECUTOR_TYPE — VARCHAR(20) — NOT NULL
- TOOL_ID — VARCHAR(36)
- AGENT_ID — VARCHAR(36)
- PARENT_EXECUTION_ID — VARCHAR(36)
- INPUT_JSON — TEXT
- OUTPUT_JSON — TEXT
- AGENT_THOUGHT_PROCESS_LOG — TEXT
- EXECUTION_START_TIMESTAMP — DATETIME — NOT NULL
- EXECUTION_END_TIMESTAMP — DATETIME
- EXECUTION_DURATION_MS — INT
- STATUS — VARCHAR(20) — NOT NULL
- ERROR_MESSAGE — TEXT
PERMISSIONS
- PERMISSION_ID — VARCHAR(36) — Primary key — NOT NULL
- PERMISSION_NAME — VARCHAR(100) — NOT NULL
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME
POLICY
- POLICY_NUMBER — VARCHAR(50) — Primary key — NOT NULL
- POLICY_NAME — VARCHAR(500) — NOT NULL
- POLICY_KEYWORD_NAME — VARCHAR(1000)
- POLICY_EXPLANATION_CONTENT — TEXT
- POLICY_SUPPORT_CONTENT — TEXT
- BASIC_PLAN_CYCLE — VARCHAR(10)
- BASIC_PLAN_POLICY_WAY_NUMBER — VARCHAR(10)
- BASIC_PLAN_FOCUS_ASSESSMENT_NUMBER — VARCHAR(10)
- BASIC_PLAN_ASSESSMENT_NUMBER — VARCHAR(10)
- LARGE_CLASSIFICATION_NAME — VARCHAR(200)
- MEDIUM_CLASSIFICATION_NAME — VARCHAR(200)
- SUPERVISION_INSTITUTION_CODE — VARCHAR(20)
- SUPERVISION_INSTITUTION_CODE_NAME — VARCHAR(500)
- SUPERVISION_INSTITUTION_PERSON_IN_CHARGE_NAME — VARCHAR(200)
- OPERATION_INSTITUTION_CODE — VARCHAR(20)
- OPERATION_INSTITUTION_CODE_NAME — VARCHAR(500)
- OPERATION_INSTITUTION_PERSON_IN_CHARGE_NAME — VARCHAR(200)
- SUPPORT_SCALE_LIMIT_YES_NO — VARCHAR(1)
- SUPPORT_SCALE_COUNT — INT
- SUPPORT_ARRIVAL_SEQUENCE_YES_NO — VARCHAR(1)
- APPLICATION_YEAR_MONTH_DAY — VARCHAR(100)
- POLICY_APPLICATION_METHOD_CONTENT — TEXT
- SCREENING_METHOD_CONTENT — TEXT
- APPLICATION_URL_ADDRESS — VARCHAR(1000)
- SUBMISSION_DOCUMENT_CONTENT — TEXT
- BUSINESS_PERIOD_BEGINNING_YEAR_MONTH_DAY — VARCHAR(20)
- BUSINESS_PERIOD_END_YEAR_MONTH_DAY — VARCHAR(20)
- BUSINESS_PERIOD_ETC_CONTENT — VARCHAR(1000)
- SUPPORT_TARGET_MINIMUM_AGE — INT
- SUPPORT_TARGET_MAXIMUM_AGE — INT
- SUPPORT_TARGET_AGE_LIMIT_YES_NO — VARCHAR(1)
- EARNING_MINIMUM_AMOUNT — BIGINT
- EARNING_MAXIMUM_AMOUNT — BIGINT
- EARNING_ETC_CONTENT — VARCHAR(1000)
- ADDITIONAL_APPLICATION_QUALIFICATION_CONDITION_CONTENT — TEXT
- PARTICIPATION_PURPOSE_TARGET_CONTENT — TEXT
- ETC_MATTERS_CONTENT — TEXT
- REFERENCE_URL_ADDRESS_1 — VARCHAR(1000)
- REFERENCE_URL_ADDRESS_2 — VARCHAR(1000)
- INQUIRY_COUNT — INT
- REGISTRAR_INSTITUTION_CODE — VARCHAR(20)
- REGISTRAR_INSTITUTION_CODE_NAME — VARCHAR(500)
- REGISTRAR_UPPER_INSTITUTION_CODE — VARCHAR(20)
- REGISTRAR_UPPER_INSTITUTION_CODE_NAME — VARCHAR(500)
- REGISTRAR_HIGHEST_RANK_INSTITUTION_CODE — VARCHAR(20)
- REGISTRAR_HIGHEST_RANK_INSTITUTION_CODE_NAME — VARCHAR(500)
- FIRST_REGISTRATION_DATETIME — DATETIME
- LAST_MODIFICATION_DATETIME — DATETIME
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME
- CREATED_BY — VARCHAR(36)
- UPDATED_BY — VARCHAR(36)
- IS_ACTIVE — BOOLEAN — NOT NULL
POLICY_APPLICATION_PERIODS
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- APPLICATION_PERIOD_SECTION_CODE — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
POLICY_APPROVAL_STATUSES
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- POLICY_APPROVAL_STATUS_CODE — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
POLICY_BUSINESS_PERIODS
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- BUSINESS_PERIOD_SECTION_CODE — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
POLICY_CODES
- CODE_VALUE — VARCHAR(10) — Primary key — NOT NULL
- CODE_NAME — VARCHAR(100) — NOT NULL
- CODE_TYPE — VARCHAR(50) — NOT NULL
- SORT_ORDER — INT
- IS_ACTIVE — BOOLEAN
POLICY_EARNING_CONDITIONS
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- EARNING_CONDITION_SECTION_CODE — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
POLICY_HISTORY
- POLICY_HISTORY_ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- OPERATION_TYPE — VARCHAR(20) — NOT NULL
- CHANGED_FIELD_NAME — VARCHAR(100)
- BEFORE_VALUE — TEXT
- AFTER_VALUE — TEXT
- CHANGED_AT — DATETIME — NOT NULL
- CHANGED_BY — VARCHAR(36)
- CHANGE_REASON — TEXT
POLICY_JOBS
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- JOB_CODE — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
POLICY_MAJORS
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- POLICY_MAJOR_CODE — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
POLICY_MARRIAGE_STATUSES
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- MARRIAGE_STATUS_CODE — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
POLICY_PROVISION_INSTITUTION_GROUPS
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- PROVISION_INSTITUTION_GROUP_CODE — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
POLICY_PROVISION_METHODS
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- POLICY_PROVISION_METHOD_CODE — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
POLICY_REGIONS
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- REGION_CODE — VARCHAR(5) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
POLICY_SCHOOLS
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- SCHOOL_CODE — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
POLICY_SPECIAL_BUSINESSES
- ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_NUMBER — VARCHAR(50) — NOT NULL
- SPECIAL_BUSINESS_CODE — VARCHAR(10) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- CREATED_BY — VARCHAR(36)
PROMPT_TEMPLATE
- PROMPT_TEMPLATE_ID — VARCHAR(36) — Primary key — NOT NULL
- PROMPT_TEMPLATE_NAME — VARCHAR(255) — NOT NULL
- PROMPT_TEMPLATE_CONTENT — TEXT
- PROMPT_TEMPLATE_VERSION — VARCHAR(50)
- RELATED_TOOL_ID — VARCHAR(36)
- RELATED_AGENT_ID — VARCHAR(36)
- IS_ACTIVE — BOOLEAN
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
PROMPT_TEMPLATE_HISTORY
- PROMPT_TEMPLATE_HISTORY_ID — VARCHAR(36) — Primary key — NOT NULL
- PROMPT_TEMPLATE_ID — VARCHAR(36) — NOT NULL
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
- UPDATED_FIELD — VARCHAR(255)
- BEFORE_UPDATE — TEXT
- AFTER_UPDATE — TEXT
- UPDATED_BY — VARCHAR(36)
REFERENCE_POLICY_CODES
- REFERENCE_POLICY_CODES_ID — VARCHAR(36) — Primary key — NOT NULL
- USER_ID — VARCHAR(36) — NOT NULL
- REFERENCE_NAME — VARCHAR(255) — NOT NULL
- DESCRIPTION — TEXT
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME
REFERENCE_POLICY_CODE_MAP
- REFERENCE_POLICY_CODES_ID — VARCHAR(36) — Primary key — NOT NULL
- POLICY_CODE_VALUE — VARCHAR(10) — Primary key — NOT NULL
REGION_CODES
- CODE — VARCHAR(5) — Primary key — NOT NULL
- SIDO — VARCHAR(50) — NOT NULL
- SIGUNGU — VARCHAR(50)
ROLES
- ROLE_ID — VARCHAR(36) — Primary key — NOT NULL
- ROLE_NAME — VARCHAR(50) — NOT NULL
- DESCRIPTION — VARCHAR(255)
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME
ROLE_PERMISSIONS
- ROLE_ID — VARCHAR(36) — Primary key — NOT NULL
- PERMISSION_ID — VARCHAR(36) — Primary key — NOT NULL
- ASSIGNED_AT — DATETIME — NOT NULL
TOOL
- TOOL_ID — VARCHAR(36) — Primary key — NOT NULL
- TOOL_NAME — VARCHAR(255) — NOT NULL
- TOOL_TYPE — VARCHAR(50) — NOT NULL
- DESCRIPTION — VARCHAR(1000)
- INPUT_SCHEMA_JSON — TEXT
- OUTPUT_SCHEMA_JSON — TEXT
- TOOL_VERSION — VARCHAR(50)
- IS_ACTIVE — BOOLEAN — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME
TOOL_HISTORY
- TOOL_HISTORY_ID — VARCHAR(36) — Primary key — NOT NULL
- TOOL_ID — VARCHAR(36) — NOT NULL
- CREATED_AT — DATETIME
- UPDATED_AT — DATETIME
- UPDATED_FIELD — VARCHAR(255)
- BEFORE_UPDATE — TEXT
- AFTER_UPDATE — TEXT
- UPDATED_BY — VARCHAR(36)
USERS
- USER_ID — VARCHAR(36) — Primary key — NOT NULL
- USER_NAME — VARCHAR(100)
- EMAIL — VARCHAR(255)
- PHONE_NUMBER — VARCHAR(20)
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME
- IS_ACTIVE — BOOLEAN — NOT NULL
- DELETED_AT — DATETIME
USERS_QUERY
- QUERY_ID — VARCHAR(36) — Primary key — NOT NULL
- USER_ID — VARCHAR(36)
- SESSION_ID — VARCHAR(36)
- QUERY_TEXT — TEXT — NOT NULL
- QUERY_TIMESTAMP — DATETIME — NOT NULL
- RESPONSE_TEXT — TEXT
- RESPONSE_TIMESTAMP — DATETIME
- RESPONSE_DURATION_MS — INT
- LLM_MODEL_USED — VARCHAR(100)
USER_ROLES
- USER_ID — VARCHAR(36) — Primary key — NOT NULL
- ROLE_ID — VARCHAR(36) — Primary key — NOT NULL
- ASSIGNED_AT — DATETIME — NOT NULL