CREATE TABLE agenda_items(
  node_id TEXT,
  meeting_node_id TEXT,
  parent_item_node_id TEXT,
  item_number TEXT,
  sequence_number INT,
  title TEXT,
  body_text TEXT,
  scheduling_only INT
);

CREATE TABLE assertion_evidence(
  assertion_id TEXT,
  source_revision_id TEXT,
  locator_json TEXT,
  supporting_text TEXT
);

CREATE TABLE assertions(
  id TEXT,
  subject_node_id TEXT,
  predicate TEXT,
  object_node_id TEXT,
  value_json TEXT,
  extraction_method TEXT,
  parser_version TEXT,
  confidence REAL,
  review_state TEXT,
  created_at TEXT
);

CREATE TABLE assessment_references(
  id TEXT,
  procedure_node_id TEXT,
  document_node_id TEXT,
  iqwig_project_id TEXT,
  assessment_node_id TEXT,
  resolution_state TEXT,
  source_revision_id TEXT
);

CREATE TABLE assessments(
  id TEXT,
  title TEXT,
  drug_inn TEXT,
  drug_brand TEXT,
  indication TEXT,
  therapeutic_area TEXT,
  department TEXT,
  publication_date TEXT,
  assessment_type TEXT
);

CREATE TABLE case_assessments(
  procedure_node_id TEXT,
  assessment_node_id TEXT,
  resolution_method TEXT,
  confidence REAL,
  review_state TEXT
);

CREATE TABLE case_decisions(
  procedure_node_id TEXT,
  decision_node_id TEXT,
  association_type TEXT,
  sequence_number INT
);

CREATE TABLE cases(
  node_id TEXT,
  gba_procedure_id TEXT,
  procedure_number TEXT,
  procedure_series TEXT,
  procedure_type TEXT,
  status_code TEXT,
  status_raw TEXT,
  start_date TEXT,
  hearing_status TEXT,
  scheduled_hearing_date TEXT,
  medicine_label TEXT,
  indication_label TEXT,
  brand TEXT,
  therapeutic_area TEXT,
  manufacturer TEXT
);

CREATE TABLE coverage_reports(
  run_id TEXT,
  coverage_scope TEXT,
  coverage_state TEXT,
  expected_procedure_count INT,
  ingested_procedure_count INT,
  expected_decision_count INT,
  ingested_decision_count INT,
  published_transcript_count INT,
  ingested_transcript_count INT,
  meeting_count INT,
  agenda_count INT,
  catalog_link_count INT,
  archive_policy_document_count INT,
  excluded_metadata_link_count INT,
  excluded_by_reason_json
);

CREATE TABLE decision_result_coverage(
  decision_node_id TEXT,
  document_node_id TEXT,
  source_revision_id TEXT,
  coverage_state TEXT,
  expected_result_count INT,
  resolved_result_count INT,
  unresolved_result_count INT
);

CREATE TABLE decision_results(
  id TEXT,
  decision_node_id TEXT,
  document_node_id TEXT,
  source_revision_id TEXT,
  sequence_number INT,
  patient_group_code TEXT,
  patient_group_text TEXT,
  comparator_text TEXT,
  benefit_extent_code TEXT,
  benefit_extent_text TEXT,
  certainty_code TEXT,
  certainty_text TEXT,
  final_result_text TEXT,
  resolution_state TEXT,
  patient_group_locator_json TEXT,
  comparator_locator_json TEXT,
  result_locator_json TEXT,
  parser_version TEXT,
  review_state TEXT
);

CREATE TABLE decision_targets(
  decision_node_id TEXT,
  target_node_id TEXT,
  target_type TEXT,
  source_relation TEXT
);

CREATE TABLE decisions(
  node_id TEXT,
  gba_decision_id TEXT,
  action_type TEXT,
  decision_date TEXT,
  effective_date TEXT,
  effective_text TEXT,
  legal_status TEXT,
  committee TEXT
);

CREATE TABLE directives(
  node_id TEXT,
  gba_directive_id TEXT,
  gba_annex_id TEXT,
  official_title TEXT,
  canonical_url TEXT
);

CREATE TABLE document_owners(
  document_node_id TEXT,
  owner_node_id TEXT,
  ownership_type TEXT
);

CREATE TABLE document_states(
  document_node_id TEXT,
  declared_owner_type TEXT,
  declared_owner_id TEXT,
  source_revision_id TEXT,
  fetch_state TEXT,
  parse_state TEXT,
  ownership_state TEXT
);

CREATE TABLE documents(
  node_id TEXT,
  source_id TEXT,
  document_type TEXT,
  language TEXT,
  publication_date TEXT,
  page_count INT
);

CREATE TABLE edge_evidence(
  edge_id TEXT,
  source_revision_id TEXT,
  locator_json TEXT,
  supporting_text TEXT,
  extraction_method TEXT,
  parser_version TEXT,
  review_state TEXT
);

CREATE TABLE edges(
  id TEXT,
  source_node_id TEXT,
  relation_type TEXT,
  target_node_id TEXT,
  valid_from TEXT,
  valid_to TEXT,
  properties_json TEXT,
  confidence REAL,
  review_state TEXT,
  publication_state TEXT,
  created_at TEXT
);

CREATE TABLE endpoint_assessments(
  id INT,
  assessment_id TEXT,
  fragestellung_id TEXT,
  endpoint_name TEXT,
  endpoint_category TEXT,
  endpoint_level TEXT,
  nebenwirkungen_schweregrad TEXT,
  result_direction TEXT,
  statistically_significant INT,
  effect_measure TEXT,
  effect_point_estimate REAL,
  effect_ci_lower REAL,
  effect_ci_upper REAL,
  effect_p_value TEXT,
  verzerrungspotenzial TEXT,
  wahrscheinlichkeit TEXT,
  effect_extent TEXT,
  excluded_from_gesamtschau INT,
  effect_modifier TEXT,
  instrument TEXT,
  iqwig_comment TEXT
);

CREATE TABLE entities(
  id TEXT,
  node_type TEXT,
  label TEXT,
  description TEXT,
  review_state TEXT,
  publication_state TEXT,
  modules,
  connection_count
);

CREATE TABLE field_evidence(
  node_id TEXT,
  field_name TEXT,
  value_json TEXT,
  source_revision_id TEXT,
  locator_json TEXT,
  supporting_text TEXT,
  extraction_method TEXT,
  parser_version TEXT,
  confidence REAL,
  review_state TEXT
);

CREATE TABLE fragestellungen(
  id INT,
  assessment_id TEXT,
  fragestellung_number INT,
  subgroup_definition TEXT,
  subgroup_definition_de TEXT,
  population_size INT,
  zvt TEXT,
  zvt_de TEXT,
  zvt_manufacturer_proposed TEXT,
  zvt_contested INT,
  "benefit_ausmaß" TEXT,
  benefit_wahrscheinlichkeit TEXT,
  "benefit_ausmaß_de" TEXT,
  iqwig_reasoning_summary TEXT,
  gba_confirmed INT,
  gba_modified_rating TEXT,
  raw_result_text TEXT,
  fragestellung_id TEXT,
  population TEXT,
  pu_agrees_with_zvt INT,
  pu_zvt_deviation TEXT,
  zvt_has_multiple_options INT,
  zvt_is_individualized_therapy INT,
  pu_selected_comparator TEXT,
  no_suitable_data INT,
  evidence_type TEXT,
  iqwig_conclusion_verbatim TEXT,
  rating_reasoning TEXT,
  pu_benefit_claim TEXT
);

CREATE TABLE hearing_document_sections(
  id TEXT,
  procedure_node_id TEXT,
  hearing_node_id TEXT,
  document_node_id TEXT,
  source_revision_id TEXT,
  section_type TEXT,
  page_start INT,
  page_end INT,
  locator_json TEXT,
  supporting_text TEXT
);

CREATE TABLE hearings(
  node_id TEXT,
  procedure_node_id TEXT,
  hearing_date TEXT
);

CREATE TABLE identifiers(
  node_id TEXT,
  namespace TEXT,
  value TEXT,
  is_primary INT
);

CREATE TABLE included_studies(
  id INT,
  assessment_id TEXT,
  fragestellung_id TEXT,
  study_name TEXT,
  study_design TEXT,
  study_design_detail TEXT,
  is_direct_comparison INT,
  n_relevant_subpopulation INT,
  data_cutoff_date TEXT,
  median_follow_up_months REAL,
  crossover_rate REAL,
  crossover_adjustment_method TEXT,
  indirect_comparison_method TEXT,
  iqwig_concerns TEXT
);

CREATE TABLE lifecycle_links(
  id TEXT,
  source_node_id TEXT,
  target_node_id TEXT,
  relation_type TEXT,
  target_url TEXT,
  target_label TEXT,
  source_revision_id TEXT,
  resolution_state TEXT,
  locator_json TEXT,
  supporting_text TEXT
);

CREATE TABLE meeting_agendas(
  id TEXT,
  meeting_node_id TEXT,
  canonical_key TEXT,
  label TEXT,
  source_id TEXT,
  source_revision_id TEXT,
  document_node_id TEXT,
  fetch_state TEXT,
  parse_state TEXT
);

CREATE TABLE meeting_attachment_status(
  meeting_node_id TEXT,
  attachment_state TEXT,
  source_id TEXT,
  source_revision_id TEXT,
  request_url TEXT,
  http_status INT,
  attempt_count INT,
  fetch_state TEXT,
  parse_state TEXT,
  details_json TEXT
);

CREATE TABLE meetings(
  node_id TEXT,
  meeting_date TEXT,
  printed_meeting_number TEXT,
  is_written_procedure INT
);

CREATE TABLE methodological_disputes(
  id INT,
  assessment_id TEXT,
  fragestellung_id TEXT,
  dispute_type TEXT,
  pu_position TEXT,
  iqwig_position TEXT,
  iqwig_prevails INT,
  impact_on_rating TEXT
);

CREATE TABLE node_evidence(
  node_id TEXT,
  source_revision_id TEXT,
  evidence_role TEXT,
  locator_json TEXT,
  supporting_text TEXT,
  parser_version TEXT,
  review_state TEXT
);

CREATE TABLE participations(
  node_id TEXT,
  event_node_id TEXT,
  person_node_id TEXT,
  represented_organization_node_id TEXT,
  role_label TEXT
);

CREATE TABLE passages(
  id INT,
  document_node_id TEXT,
  source_revision_id TEXT,
  page_start INT,
  page_end INT,
  section_label TEXT,
  text TEXT,
  text_sha256 TEXT
);

CREATE TABLE procedure_coverage(
  gba_procedure_id TEXT,
  procedure_node_id TEXT,
  bundle_state TEXT,
  expected_decision_count INT,
  ingested_decision_count INT,
  discovered_document_count INT,
  ingested_document_count INT,
  published_transcript_count INT,
  ingested_transcript_count INT,
  coverage_state TEXT,
  details_json TEXT
);

CREATE TABLE public_database_metadata (key TEXT PRIMARY KEY,value TEXT NOT NULL);

CREATE TABLE recordings(
  node_id TEXT,
  meeting_node_id TEXT,
  movingimage_video_id TEXT,
  public_url TEXT,
  duration_ms INT,
  is_stub INT
);

CREATE TABLE rejected_evidence(
  id INT,
  assessment_id TEXT,
  fragestellung_id TEXT,
  study_name TEXT,
  rejection_reason TEXT,
  indirect_comparison_method TEXT,
  rejection_detail TEXT
);

CREATE TABLE source_revisions(
  id TEXT,
  source_id TEXT,
  retrieved_at TEXT,
  sha256 TEXT,
  media_type TEXT,
  byte_size INT,
  http_status INT,
  fetch_state TEXT,
  parse_state TEXT
);

CREATE TABLE sources(
  id TEXT,
  publisher TEXT,
  source_kind TEXT,
  canonical_key TEXT,
  canonical_url TEXT,
  first_seen_at TEXT,
  last_seen_at TEXT
);

CREATE TABLE speaker_turns(
  node_id TEXT,
  hearing_node_id TEXT,
  document_node_id TEXT,
  participation_node_id TEXT,
  sequence_number INT,
  speaker_label TEXT,
  represented_as TEXT,
  text TEXT,
  page_start INT,
  page_end INT
);

CREATE TABLE summaries(
  id TEXT,
  node_id TEXT,
  summary_type TEXT,
  language TEXT,
  summary_text TEXT,
  model TEXT,
  prompt_version TEXT,
  source_set_sha256 TEXT,
  generated_at TEXT,
  review_state TEXT,
  publication_state TEXT
);

CREATE TABLE summary_claim_checks(
  summary_id TEXT,
  claim_index INT,
  check_type TEXT,
  result TEXT,
  checker TEXT,
  checked_at TEXT,
  details_json TEXT
);

CREATE TABLE summary_claim_evidence(
  summary_id TEXT,
  claim_index INT,
  evidence_index INT,
  source_revision_id TEXT,
  locator_json TEXT,
  supporting_text TEXT
);

CREATE TABLE summary_claims(
  summary_id TEXT,
  claim_index INT,
  claim_text TEXT
);

CREATE TABLE transcript_coverage(
  document_node_id TEXT,
  hearing_node_id TEXT,
  coverage_state TEXT,
  speaker_turn_count INT,
  candidate_header_count INT,
  unparsed_header_count INT
);