DROP TABLE IF EXISTS `dl_source_document`;
|
CREATE TABLE `dl_source_document` (
|
`source_id` varchar(128) NOT NULL,
|
`source_title` varchar(512) NOT NULL,
|
`source_url_or_path` varchar(512) NOT NULL,
|
`source_type` varchar(64) NOT NULL,
|
`publish_time` varchar(64) DEFAULT NULL,
|
`available_time` varchar(64) DEFAULT NULL,
|
`raw_text_hash` char(64) NOT NULL,
|
`source_reliability` varchar(64) NOT NULL,
|
`archive_status` varchar(64) NOT NULL,
|
PRIMARY KEY (`source_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_case_import_batch`;
|
CREATE TABLE `dl_case_import_batch` (
|
`import_batch_id` varchar(96) NOT NULL,
|
`source_name` varchar(128) NOT NULL,
|
`source_kind` varchar(64) NOT NULL,
|
`source_document_path` varchar(512) NOT NULL,
|
`source_hash` char(64) NOT NULL,
|
`case_count` int NOT NULL,
|
`data_dir` varchar(512) NOT NULL,
|
`imported_at` datetime NOT NULL,
|
`note` varchar(512) DEFAULT NULL,
|
PRIMARY KEY (`import_batch_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_case_record`;
|
CREATE TABLE `dl_case_record` (
|
`case_id` varchar(96) NOT NULL,
|
`import_batch_id` varchar(96) NOT NULL,
|
`case_order` int NOT NULL,
|
`case_title` varchar(512) NOT NULL,
|
`case_family` varchar(96) NOT NULL,
|
`case_level` varchar(32) NOT NULL,
|
`current_status` varchar(64) NOT NULL,
|
`case_body_md` longtext NOT NULL,
|
`case_body_hash` char(64) NOT NULL,
|
`local_body_path` varchar(512) NOT NULL,
|
`source_document_path` varchar(512) NOT NULL,
|
`source_section_heading` varchar(512) NOT NULL,
|
`created_at` datetime NOT NULL,
|
`updated_at` datetime NOT NULL,
|
PRIMARY KEY (`case_id`),
|
KEY `idx_dl_case_batch` (`import_batch_id`),
|
KEY `idx_dl_case_family` (`case_family`),
|
KEY `idx_dl_case_level` (`case_level`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_darkline_hypothesis`;
|
CREATE TABLE `dl_darkline_hypothesis` (
|
`darkline_hypothesis_id` varchar(96) NOT NULL,
|
`case_id` varchar(96) NOT NULL,
|
`hypothesis_title` varchar(512) NOT NULL,
|
`darkline_level` varchar(32) NOT NULL,
|
`hypothesis_family` varchar(96) NOT NULL,
|
`hypothesis_status` varchar(64) NOT NULL,
|
`source_case_body_hash` char(64) NOT NULL,
|
`created_at` datetime NOT NULL,
|
`updated_at` datetime NOT NULL,
|
PRIMARY KEY (`darkline_hypothesis_id`),
|
KEY `idx_dl_hypothesis_case` (`case_id`),
|
KEY `idx_dl_hypothesis_level` (`darkline_level`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_case_reasoning_step`;
|
CREATE TABLE `dl_case_reasoning_step` (
|
`reasoning_step_id` varchar(128) NOT NULL,
|
`case_id` varchar(96) NOT NULL,
|
`darkline_hypothesis_id` varchar(96) NOT NULL,
|
`step_order` int NOT NULL,
|
`step_type` varchar(64) NOT NULL,
|
`section_heading` varchar(512) DEFAULT NULL,
|
`step_text` longtext NOT NULL,
|
`extraction_rule` varchar(128) NOT NULL,
|
`archive_batch_id` varchar(96) NOT NULL,
|
PRIMARY KEY (`reasoning_step_id`),
|
KEY `idx_reason_case` (`case_id`),
|
KEY `idx_reason_type` (`step_type`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_expected_line`;
|
CREATE TABLE `dl_expected_line` (
|
`expected_line_id` varchar(128) NOT NULL,
|
`darkline_hypothesis_id` varchar(96) NOT NULL,
|
`case_id` varchar(96) NOT NULL,
|
`expected_line_type` varchar(64) NOT NULL,
|
`expected_event` longtext NOT NULL,
|
`expected_timing` varchar(128) DEFAULT NULL,
|
`expected_direction` varchar(64) NOT NULL,
|
`observed_flag` tinyint NOT NULL,
|
`observed_event_node_id` varchar(128) DEFAULT NULL,
|
`validation_status` varchar(64) NOT NULL,
|
`source_reasoning_step_id` varchar(128) DEFAULT NULL,
|
`archive_batch_id` varchar(96) NOT NULL,
|
PRIMARY KEY (`expected_line_id`),
|
KEY `idx_expected_case` (`case_id`),
|
KEY `idx_expected_hypothesis` (`darkline_hypothesis_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_event_node`;
|
CREATE TABLE `dl_event_node` (
|
`event_node_id` varchar(128) NOT NULL,
|
`darkline_hypothesis_id` varchar(96) NOT NULL,
|
`case_id` varchar(96) NOT NULL,
|
`event_title` varchar(512) NOT NULL,
|
`event_date` varchar(64) DEFAULT NULL,
|
`available_time` varchar(64) DEFAULT NULL,
|
`actor_list` text,
|
`target_list` text,
|
`event_type` varchar(96) NOT NULL,
|
`event_level` varchar(32) NOT NULL,
|
`source_id` varchar(128) NOT NULL,
|
`node_status` varchar(64) NOT NULL,
|
`source_reasoning_step_id` varchar(128) DEFAULT NULL,
|
`archive_batch_id` varchar(96) NOT NULL,
|
PRIMARY KEY (`event_node_id`),
|
KEY `idx_event_case` (`case_id`),
|
KEY `idx_event_hypothesis` (`darkline_hypothesis_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_evidence`;
|
CREATE TABLE `dl_evidence` (
|
`evidence_id` varchar(128) NOT NULL,
|
`source_id` varchar(128) NOT NULL,
|
`case_id` varchar(96) NOT NULL,
|
`raw_excerpt` longtext NOT NULL,
|
`evidence_type` varchar(96) NOT NULL,
|
`evidence_strength` varchar(64) NOT NULL,
|
`extracted_time` datetime NOT NULL,
|
`evidence_hash` char(64) NOT NULL,
|
`source_reasoning_step_id` varchar(128) DEFAULT NULL,
|
`archive_batch_id` varchar(96) NOT NULL,
|
PRIMARY KEY (`evidence_id`),
|
KEY `idx_evidence_case` (`case_id`),
|
KEY `idx_evidence_type` (`evidence_type`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_evidence_node_link`;
|
CREATE TABLE `dl_evidence_node_link` (
|
`evidence_node_link_id` varchar(160) NOT NULL,
|
`evidence_id` varchar(128) NOT NULL,
|
`event_node_id` varchar(128) DEFAULT NULL,
|
`darkline_hypothesis_id` varchar(96) NOT NULL,
|
`expected_line_id` varchar(128) DEFAULT NULL,
|
`link_role` varchar(64) NOT NULL,
|
`archive_batch_id` varchar(96) NOT NULL,
|
PRIMARY KEY (`evidence_node_link_id`),
|
KEY `idx_link_evidence` (`evidence_id`),
|
KEY `idx_link_event` (`event_node_id`),
|
KEY `idx_link_hypothesis` (`darkline_hypothesis_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_impact_target`;
|
CREATE TABLE `dl_impact_target` (
|
`impact_target_id` varchar(128) NOT NULL,
|
`darkline_hypothesis_id` varchar(96) NOT NULL,
|
`case_id` varchar(96) NOT NULL,
|
`target_type` varchar(64) NOT NULL,
|
`target_id` varchar(96) NOT NULL,
|
`target_name` varchar(256) DEFAULT NULL,
|
`expected_impact_direction` varchar(64) NOT NULL,
|
`expected_window` varchar(128) DEFAULT NULL,
|
`archive_batch_id` varchar(96) NOT NULL,
|
PRIMARY KEY (`impact_target_id`),
|
KEY `idx_target_case` (`case_id`),
|
KEY `idx_target_hypothesis` (`darkline_hypothesis_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_manifestation_bridge`;
|
CREATE TABLE `dl_manifestation_bridge` (
|
`bridge_id` varchar(128) NOT NULL,
|
`darkline_hypothesis_id` varchar(96) NOT NULL,
|
`case_id` varchar(96) NOT NULL,
|
`expected_line_id` varchar(128) DEFAULT NULL,
|
`impact_target_id` varchar(128) DEFAULT NULL,
|
`output_layer` varchar(96) NOT NULL,
|
`manifestation_time` varchar(64) DEFAULT NULL,
|
`manifestation_value` longtext NOT NULL,
|
`control_group_id` varchar(128) DEFAULT NULL,
|
`support_status` varchar(64) NOT NULL,
|
`source_reasoning_step_id` varchar(128) DEFAULT NULL,
|
`archive_batch_id` varchar(96) NOT NULL,
|
PRIMARY KEY (`bridge_id`),
|
KEY `idx_bridge_case` (`case_id`),
|
KEY `idx_bridge_hypothesis` (`darkline_hypothesis_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_alternative_explanation`;
|
CREATE TABLE `dl_alternative_explanation` (
|
`alternative_id` varchar(128) NOT NULL,
|
`darkline_hypothesis_id` varchar(96) NOT NULL,
|
`case_id` varchar(96) NOT NULL,
|
`bridge_id` varchar(128) DEFAULT NULL,
|
`alternative_type` varchar(96) NOT NULL,
|
`explanation` longtext NOT NULL,
|
`strength` varchar(64) NOT NULL,
|
`current_status` varchar(64) NOT NULL,
|
`source_reasoning_step_id` varchar(128) DEFAULT NULL,
|
`archive_batch_id` varchar(96) NOT NULL,
|
PRIMARY KEY (`alternative_id`),
|
KEY `idx_alt_case` (`case_id`),
|
KEY `idx_alt_hypothesis` (`darkline_hypothesis_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
DROP TABLE IF EXISTS `dl_chain_state`;
|
CREATE TABLE `dl_chain_state` (
|
`state_record_id` varchar(128) NOT NULL,
|
`darkline_hypothesis_id` varchar(96) NOT NULL,
|
`case_id` varchar(96) NOT NULL,
|
`chain_clarity_status` varchar(64) NOT NULL,
|
`reality_confirmation_status` varchar(64) NOT NULL,
|
`market_manifestation_status` varchar(64) NOT NULL,
|
`validation_readout_status` varchar(64) NOT NULL,
|
`current_consumption_level` varchar(64) NOT NULL,
|
`state_record_time` datetime NOT NULL,
|
`note` varchar(512) DEFAULT NULL,
|
PRIMARY KEY (`state_record_id`),
|
KEY `idx_dl_chain_case` (`case_id`),
|
KEY `idx_dl_chain_hypothesis` (`darkline_hypothesis_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
