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