Skip to content

Würth Reliability data

Jump to bottom
Jochen Steinmann edited this page Feb 22, 2017 · 2 revisions

For the reliability data from Würth Electronics, there exists a PDF document, which describes the reliability of components for various temperatures and different stress levels.

The data from this PDF-document can be stored and used from a database. The conversion from the PDF into the database is rather simple.

The database consists of two tables.

  1. the lookuptable CREATE TABLE MatchCodeMapping (matchcode varchar(32), FITtable decimal(3,1), FITcurve char, SIGMAtable decimal(3,1), SIGMAcurve char)

  2. the datatable CREATE TABLE "reliability_data" ("table" DECIMAL(3,1) NOT NULL ,"curve" CHAR NOT NULL ,"temperature" FLOAT NOT NULL ,"FIT" FLOAT,"date" DATETIME DEFAULT (CURRENT_TIMESTAMP) )

The data is stored in these tables as shown below:

  1. Lookup data: "WE-CBA","5.1","C","6.1","O"

  2. Data "5.1","A","5.69","0.75125","2016-12-01"

Clone this wiki locally