AIVLE_BIG

Tables (24)

access_request

  • request_id — BIGINT
  • requester_user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • company_name — VARCHAR(200) — NOT NULL
  • org_code — VARCHAR(80)
  • requested_role_code — VARCHAR(40) — NOT NULL
  • message — TEXT
  • status — VARCHAR(20) — NOT NULL
  • decided_by — BIGINT
  • decided_at — DATETIME
  • decision_note — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

app_user

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • display_name — VARCHAR(120) — NOT NULL
  • phone — VARCHAR(40)
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

assessment

  • assessment_id — BIGINT
  • anchor_company_id — BIGINT — NOT NULL
  • supplier_company_id — BIGINT — NOT NULL
  • template_version_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • period_start — DATE
  • period_end — DATE
  • status — VARCHAR(30) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

assessment_item_response

  • response_id — BIGINT
  • assessment_id — BIGINT — NOT NULL
  • item_id — BIGINT — NOT NULL
  • responded_by — BIGINT — NOT NULL
  • response_text — TEXT
  • response_status — VARCHAR(20) — NOT NULL
  • submitted_at — DATETIME
  • updated_at — DATETIME — NOT NULL

assessment_status_log

  • log_id — BIGINT
  • assessment_id — BIGINT — NOT NULL
  • from_status — VARCHAR(30)
  • to_status — VARCHAR(30) — NOT NULL
  • reason — VARCHAR(255)
  • changed_by — BIGINT — NOT NULL
  • changed_at — DATETIME — NOT NULL

audit_log

  • audit_id — BIGINT
  • actor_user_id — BIGINT
  • company_id — BIGINT
  • assessment_id — BIGINT
  • action — VARCHAR(80) — NOT NULL
  • target_type — VARCHAR(80)
  • target_id — BIGINT
  • ip_addr — VARCHAR(80)
  • user_agent — VARCHAR(255)
  • detail — TEXT
  • created_at — DATETIME — NOT NULL

company

  • company_id — BIGINT
  • company_type — VARCHAR(20) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • biz_reg_no — VARCHAR(40)
  • org_code — VARCHAR(80)
  • industry_id — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

data_package

  • package_id — BIGINT
  • assessment_id — BIGINT — NOT NULL
  • package_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • storage_provider — VARCHAR(20) — NOT NULL
  • storage_bucket — VARCHAR(255)
  • storage_key — VARCHAR(800) — NOT NULL
  • generated_by — BIGINT — NOT NULL
  • generated_at — DATETIME — NOT NULL

diagnostic_item

  • item_id — BIGINT
  • template_version_id — BIGINT — NOT NULL
  • item_code — VARCHAR(80) — NOT NULL
  • item_type — VARCHAR(20) — NOT NULL
  • domain — VARCHAR(10) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • sort_order — INT — NOT NULL
  • is_required — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

evidence_file

  • file_id — BIGINT
  • assessment_id — BIGINT — NOT NULL
  • uploader_user_id — BIGINT — NOT NULL
  • company_id — BIGINT — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_type — VARCHAR(40) — NOT NULL
  • storage_provider — VARCHAR(20) — NOT NULL
  • storage_bucket — VARCHAR(255)
  • storage_key — VARCHAR(800) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • checksum_sha256 — VARCHAR(80)
  • upload_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

evidence_item_link

  • link_id — BIGINT
  • file_id — BIGINT — NOT NULL
  • item_id — BIGINT — NOT NULL
  • linked_by — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

indicator_def

  • indicator_def_id — BIGINT
  • item_id — BIGINT — NOT NULL
  • indicator_code — VARCHAR(80) — NOT NULL
  • unit — VARCHAR(40)
  • formula — TEXT
  • agg_method — VARCHAR(20)
  • input_field_hint — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

indicator_result

  • indicator_result_id — BIGINT
  • assessment_id — BIGINT — NOT NULL
  • indicator_def_id — BIGINT — NOT NULL
  • value_num — DECIMAL(18,6)
  • value_text — VARCHAR(255)
  • unit — VARCHAR(40)
  • source_file_id — BIGINT
  • calc_method — VARCHAR(40)
  • calc_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

indicator_revision

  • revision_id — BIGINT
  • indicator_result_id — BIGINT — NOT NULL
  • revised_by — BIGINT — NOT NULL
  • old_value_num — DECIMAL(18,6)
  • old_value_text — VARCHAR(255)
  • new_value_num — DECIMAL(18,6)
  • new_value_text — VARCHAR(255)
  • reason — VARCHAR(255) — NOT NULL
  • revised_at — DATETIME — NOT NULL

industry

  • industry_id — BIGINT
  • industry_code — VARCHAR(40) — NOT NULL
  • industry_name — VARCHAR(120) — NOT NULL

item_review

  • item_review_id — BIGINT
  • review_task_id — BIGINT — NOT NULL
  • item_id — BIGINT — NOT NULL
  • decision — VARCHAR(20) — NOT NULL
  • comment — TEXT — EXT NUL
  • decided_by — BIGINT
  • decided_at — DATETIME

membership

  • membership_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • company_id — BIGINT — NOT NULL
  • title — VARCHAR(120)
  • dept — VARCHAR(120)
  • is_primary — TINYINT(1) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

parsed_field

  • parsed_field_id — BIGINT
  • file_id — BIGINT — NOT NULL
  • field_key — VARCHAR(120) — NOT NULL
  • field_value — VARCHAR(500)
  • confidence — DECIMAL(5,2)
  • page_no — INT
  • bbox_text — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

report

  • report_id — BIGINT
  • assessment_id — BIGINT — NOT NULL
  • report_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • storage_provider — VARCHAR(20) — NOT NULL
  • storage_bucket — VARCHAR(255)
  • storage_key — VARCHAR(800) — NOT NULL
  • generated_by — BIGINT — NOT NULL
  • generated_at — DATETIME — NOT NULL

review_task

  • review_task_id — BIGINT
  • assessment_id — BIGINT — NOT NULL
  • assigned_to — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • due_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

role

  • role_id — BIGINT
  • role_code — VARCHAR(40) — NOT NULL
  • role_name — VARCHAR(80) — NOT NULL

template_version

  • template_version_id — BIGINT
  • template_name — VARCHAR(200) — NOT NULL
  • industry_id — BIGINT — NOT NULL
  • version_no — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL

user_role_assignment

  • assignment_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • company_id — BIGINT
  • assessment_id — BIGINT
  • role_id — BIGINT — NOT NULL
  • granted_by — BIGINT
  • granted_at — DATETIME — NOT NULL
  • note — VARCHAR(255)

validation_result

  • validation_id — BIGINT
  • assessment_id — BIGINT — NOT NULL
  • item_id — BIGINT — NOT NULL
  • file_id — BIGINT
  • rule_code — VARCHAR(80) — NOT NULL
  • severity — VARCHAR(10) — NOT NULL
  • message — VARCHAR(500) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • detected_at — DATETIME — NOT NULL
  • resolved_by — BIGINT
  • resolved_at — DATETIME