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