dram

Tables (31)

active_device

  • active_device_id — TEXT — Primary key — NOT NULL
  • component_type — TEXT — NOT NULL
  • part_number — TEXT
  • vendor — TEXT
  • description — TEXT

artifact

  • artifact_id — TEXT — Primary key — NOT NULL
  • run_id — TEXT — Foreign key → test_run.run_id — NOT NULL
  • artifact_type — TEXT
  • file_name — TEXT
  • file_path — TEXT
  • file_size_kb — INTEGER
  • created_date — TEXT
  • created_by — TEXT

bom

  • bom_id — TEXT — Primary key — NOT NULL
  • bom_type — TEXT — NOT NULL
  • parent_material_id — TEXT — Foreign key → material.material_id — NOT NULL
  • child_material_id — TEXT — Foreign key → material.material_id — NOT NULL
  • quantity — REAL
  • bom_level — INTEGER
  • revision_id — TEXT — Foreign key → revision.revision_id
  • effective_date — TEXT

customer

  • customer_id — TEXT — Primary key — NOT NULL
  • customer_name — TEXT — NOT NULL
  • platform_name — TEXT
  • region — TEXT
  • tier — TEXT
  • account_manager — TEXT

device

  • device_id — TEXT — Primary key — NOT NULL
  • wafer_id — TEXT — Foreign key → wafer.wafer_id — NOT NULL
  • x_coord — INTEGER
  • y_coord — INTEGER
  • bin_code — TEXT
  • status — TEXT

issue

  • issue_id — TEXT — Primary key — NOT NULL
  • title — TEXT
  • description — TEXT
  • severity — TEXT
  • status — TEXT
  • opened_date — TEXT
  • closed_date — TEXT
  • owner — TEXT
  • root_cause — TEXT

issue_device

  • issue_id — TEXT — Foreign key → issue.issue_id — NOT NULL
  • device_id — TEXT — Foreign key → device.device_id — NOT NULL

issue_lot

  • issue_id — TEXT — Foreign key → issue.issue_id — NOT NULL
  • lot_id — TEXT — Foreign key → lot.lot_id — NOT NULL

issue_process

  • issue_id — TEXT — Foreign key → issue.issue_id — NOT NULL
  • process_id — TEXT — Foreign key → process.process_id — NOT NULL

issue_product

  • issue_id — TEXT — Foreign key → issue.issue_id — NOT NULL
  • product_id — TEXT — Foreign key → product.product_id — NOT NULL

issue_test_run

  • issue_id — TEXT — Foreign key → issue.issue_id — NOT NULL
  • run_id — TEXT — Foreign key → test_run.run_id — NOT NULL

issue_wafer

  • issue_id — TEXT — Foreign key → issue.issue_id — NOT NULL
  • wafer_id — TEXT — Foreign key → wafer.wafer_id — NOT NULL

lot

  • lot_id — TEXT — Primary key — NOT NULL
  • product_id — TEXT — Foreign key → product.product_id — NOT NULL
  • material_id — TEXT — Foreign key → material.material_id — NOT NULL
  • parent_lot_id — TEXT — Foreign key → lot.lot_id
  • lot_type — TEXT
  • quantity — INTEGER
  • start_date — TEXT
  • status — TEXT

material

  • material_id — TEXT — Primary key — NOT NULL
  • material_number — TEXT
  • product_id — TEXT — Foreign key → product.product_id — NOT NULL
  • material_type — TEXT — NOT NULL
  • description — TEXT
  • uom — TEXT
  • status — TEXT

module

  • module_id — TEXT — Primary key — NOT NULL
  • module_name — TEXT — NOT NULL
  • module_type — TEXT — NOT NULL
  • product_id — TEXT — Foreign key → product.product_id — NOT NULL
  • customer_id — TEXT — Foreign key → customer.customer_id
  • capacity — TEXT
  • rank_organization — TEXT
  • pcb_id — TEXT — Foreign key → pcb.pcb_id
  • height_mm — REAL
  • status — TEXT
  • created_date — TEXT

module_bom_active_device

  • module_active_id — TEXT — Primary key — NOT NULL
  • module_id — TEXT — Foreign key → module.module_id — NOT NULL
  • active_device_id — TEXT — Foreign key → active_device.active_device_id — NOT NULL
  • quantity — INTEGER
  • position — TEXT

module_bom_dram

  • module_dram_id — TEXT — Primary key — NOT NULL
  • module_id — TEXT — Foreign key → module.module_id — NOT NULL
  • material_id — TEXT — Foreign key → material.material_id — NOT NULL
  • quantity — INTEGER
  • position — TEXT

module_bom_pcb

  • module_pcb_id — TEXT — Primary key — NOT NULL
  • module_id — TEXT — Foreign key → module.module_id — NOT NULL
  • pcb_id — TEXT — Foreign key → pcb.pcb_id — NOT NULL
  • quantity — INTEGER

pcb

  • pcb_id — TEXT — Primary key — NOT NULL
  • pcb_name — TEXT — NOT NULL
  • layer_count — INTEGER
  • form_factor — TEXT
  • vendor — TEXT
  • revision — TEXT
  • description — TEXT

process

  • process_id — TEXT — Primary key — NOT NULL
  • process_name — TEXT — NOT NULL
  • process_type — TEXT — NOT NULL
  • route_id — TEXT
  • step_seq — INTEGER
  • description — TEXT
  • standard_duration_min — INTEGER

process_record

  • record_id — TEXT — Primary key — NOT NULL
  • lot_id — TEXT — Foreign key → lot.lot_id — NOT NULL
  • wafer_id — TEXT — Foreign key → wafer.wafer_id
  • process_id — TEXT — Foreign key → process.process_id — NOT NULL
  • equipment_id — TEXT
  • recipe_id — TEXT
  • parameters_json — TEXT
  • start_time — TEXT
  • end_time — TEXT
  • operator — TEXT

product

  • product_id — TEXT — Primary key — NOT NULL
  • product_name — TEXT — NOT NULL
  • product_family — TEXT — NOT NULL
  • density — TEXT — NOT NULL
  • speed_grade — TEXT
  • package_type — TEXT
  • process_node — TEXT
  • status — TEXT
  • created_date — TEXT

revision

  • revision_id — TEXT — Primary key — NOT NULL
  • revision_no — TEXT
  • baseline_name — TEXT
  • effective_date — TEXT
  • status — TEXT
  • description — TEXT

revision_product

  • revision_id — TEXT — Foreign key → revision.revision_id — NOT NULL
  • product_id — TEXT — Foreign key → product.product_id — NOT NULL

revision_specification

  • revision_id — TEXT — Foreign key → revision.revision_id — NOT NULL
  • spec_id — TEXT — Foreign key → specification.spec_id — NOT NULL

specification

  • spec_id — TEXT — Primary key — NOT NULL
  • product_id — TEXT — Foreign key → product.product_id — NOT NULL
  • spec_name — TEXT — NOT NULL
  • category — TEXT
  • target_value — REAL
  • min_value — REAL
  • max_value — REAL
  • unit — TEXT

test_definition

  • test_def_id — TEXT — Primary key — NOT NULL
  • test_name — TEXT — NOT NULL
  • test_program — TEXT
  • spec_id — TEXT — Foreign key → specification.spec_id
  • test_type — TEXT
  • description — TEXT

test_environment

  • env_id — TEXT — Primary key — NOT NULL
  • system_name — TEXT
  • bios_version — TEXT
  • temperature — TEXT
  • speed_grade — TEXT
  • voltage — REAL
  • description — TEXT

test_result

  • result_id — TEXT — Primary key — NOT NULL
  • run_id — TEXT — Foreign key → test_run.run_id — NOT NULL
  • result_type — TEXT
  • measured_value — REAL
  • margin_value — REAL
  • fail_bit_count — INTEGER
  • bin_code — TEXT
  • comment — TEXT

test_run

  • run_id — TEXT — Primary key — NOT NULL
  • test_def_id — TEXT — Foreign key → test_definition.test_def_id — NOT NULL
  • env_id — TEXT — Foreign key → test_environment.env_id — NOT NULL
  • lot_id — TEXT — Foreign key → lot.lot_id — NOT NULL
  • wafer_id — TEXT — Foreign key → wafer.wafer_id
  • device_id — TEXT — Foreign key → device.device_id
  • run_date — TEXT
  • operator — TEXT
  • status — TEXT

wafer

  • wafer_id — TEXT — Primary key — NOT NULL
  • lot_id — TEXT — Foreign key → lot.lot_id — NOT NULL
  • wafer_seq — INTEGER
  • slot_no — INTEGER
  • status — TEXT