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