ㅎㄹㅇ

Tables (21)

A_AUDIT_LOG

  • audit_id — UUID
  • company_id — UUID
  • actor_user_id — UUID

A_COMPANY

  • company_id — UUID
  • tenant_id — UUID — Foreign key → A_TENANT.tenant_id
  • company_name — VARCHAR(255)

A_TENANT

  • tenant_id — UUID
  • tenant_name — VARCHAR(255)

A_USER_ACCOUNT

  • user_id — UUID
  • company_id — UUID — Foreign key → A_COMPANY.company_id
  • email — VARCHAR(255)
  • role_code — VARCHAR(50)

B_DICTIONARY_RULE

  • dictionary_rule_id — UUID
  • metric_id — VARCHAR(100) — Foreign key → B_METRIC_MASTER.metric_id

B_ISSUE_MASTER

  • issue_id — VARCHAR(100)
  • issue_name — VARCHAR(255)

B_METRIC_MASTER

  • metric_id — VARCHAR(100)
  • issue_id — VARCHAR(100) — Foreign key → B_ISSUE_MASTER.issue_id

C_EVIDENCE_CHUNK

  • chunk_id — UUID
  • version_id — UUID — Foreign key → C_SOURCE_DOCUMENT_VERSION.version_id

C_EXTRACTION_JOB

  • extraction_job_id — UUID
  • version_id — UUID — Foreign key → C_SOURCE_DOCUMENT_VERSION.version_id

C_SOURCE_DOCUMENT

  • source_document_id — UUID
  • company_id — UUID — Foreign key → A_COMPANY.company_id

C_SOURCE_DOCUMENT_VERSION

  • version_id — UUID
  • source_document_id — UUID — Foreign key → C_SOURCE_DOCUMENT.source_document_id

D_FACT_CANDIDATE

  • fact_candidate_id — UUID
  • company_id — UUID — Foreign key → A_COMPANY.company_id
  • metric_id — VARCHAR(100) — Foreign key → B_METRIC_MASTER.metric_id
  • chunk_id — UUID — Foreign key → C_EVIDENCE_CHUNK.chunk_id

D_KPI_FACT

  • kpi_fact_id — UUID
  • fact_candidate_id — UUID — Foreign key → D_FACT_CANDIDATE.fact_candidate_id

D_SCORE_COMPONENT

  • score_component_id — UUID
  • company_id — UUID — Foreign key → A_COMPANY.company_id
  • issue_id — VARCHAR(100) — Foreign key → B_ISSUE_MASTER.issue_id
  • kpi_fact_id — UUID — Foreign key → D_KPI_FACT.kpi_fact_id
  • chunk_id — UUID — Foreign key → C_EVIDENCE_CHUNK.chunk_id
  • score_version_id — UUID — Foreign key → D_SCORE_VERSION.score_version_id

D_SCORE_VERSION

  • score_version_id — UUID

E_MODEL_REGISTRY

  • model_id — UUID

E_NARRATIVE_REFERENCE

  • reference_id — UUID
  • section_id — UUID — Foreign key → E_REPORT_SECTION_DRAFT.section_id
  • kpi_fact_id — UUID — Foreign key → D_KPI_FACT.kpi_fact_id
  • chunk_id — UUID — Foreign key → C_EVIDENCE_CHUNK.chunk_id

E_PROMPT_TEMPLATE

  • prompt_template_id — UUID

E_PROMPT_TEMPLATE_VERSION

  • version_id — UUID
  • prompt_template_id — UUID — Foreign key → E_PROMPT_TEMPLATE.prompt_template_id

E_REPORT_RUN

  • report_run_id — UUID
  • company_id — UUID — Foreign key → A_COMPANY.company_id
  • model_id — UUID — Foreign key → E_MODEL_REGISTRY.model_id
  • score_version_id — UUID — Foreign key → D_SCORE_VERSION.score_version_id

E_REPORT_SECTION_DRAFT

  • section_id — UUID
  • report_run_id — UUID — Foreign key → E_REPORT_RUN.report_run_id