# Fileset [Kinzoku-spreadsheet-columns-0.6.xlsx](https://mdr.nims.go.jp/filesets/d17f80de-4419-4743-a480-828f4bd4d7be/download) ## Creator [Asahiko Matsuda](https://orcid.org/0000-0001-5989-027X), [Masahiko Demura](https://orcid.org/0000-0002-7308-3041), Masayoshi Yamazaki, [Takuya Kadohira](https://orcid.org/0000-0003-0569-1309), [Toshihiro Ashino](https://orcid.org/0009-0002-9592-8516), [Yoshiyuki Furuya](https://orcid.org/0000-0002-3039-5280), [Kota Sawada](https://orcid.org/0000-0001-7780-1648), Nobutaka Nishikawa ## Rights Excel data is available under CC BY-NC 4.0. STAM-M paper is available under CC BY 4.0.[Creative Commons BY-NC Attribution-NonCommercial 4.0 International](https://creativecommons.org/licenses/by-nc/4.0/) ## Other metadata [Supplemental data to 'A unified model for metallic materials reliability data and its application in NIMS Metallic Materials Database (Kinzoku)'](https://mdr.nims.go.jp/datasets/1fdb3913-67e7-4f57-aa76-f1ae7fc16538) ## Fulltext Sheet1 TSV file Column name Note PK FK (table:Column name) Example/Description Data type Unit datasource.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Datasource ID required PK D-NIMS-CDS-1 text Datasource required text Organization required Datasource creator or publisher text Datasheet Name required text Datasheet No required numeric Datasheet Rev Datasheet revision code text Year Datasource published year integer Title E English title text Title J Japanese title text Remark text material.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID required PK M-D-NIMS-CDS-1-STBA22-MBB text Material text Datasource ID required datasource:Datasource ID text Datasource text Datasheet Name text Datasheet No numeric Datasheet Rev text Symbol of Grade SB410 text Nominal Composition 0.16C-0.80Mn text Material Standard JIS G 3103 text Material Category Carbon steel text Remark text composition.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID required PK material:Material ID text Series text Analysis text C numeric mass% Si numeric mass% Mn numeric mass% P numeric mass% S numeric mass% Ni numeric mass% Cr numeric mass% Mo numeric mass% W numeric mass% Cu numeric mass% B numeric mass% Al sol. numeric mass% Al insol. numeric mass% Al Total numeric mass% N sol. numeric mass% N insol. numeric mass% N Total numeric mass% Ti+Zr numeric mass% Ti numeric mass% Zr numeric mass% V numeric mass% Nb+Ta numeric mass% Nb numeric mass% Ta numeric mass% Fe numeric mass% Co numeric mass% Zn numeric mass% Sn numeric mass% Mg numeric mass% Ca numeric mass% As numeric mass% Sb numeric mass% Y numeric mass% Hf numeric mass% Ru numeric mass% Re numeric mass% La numeric mass% Ce numeric mass% H numeric mass% O numeric mass% N2 numeric mass% O2 numeric mass% Creq numeric mass% Nieq numeric mass% Ceq numeric mass% Pcm numeric % Remark text piece.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID material:Material ID text Piece ID required PK P-M-NIMS-CDS-1-STBA22-MBB text Piece text Reference Code text Welding ID welding:Welding ID W-NIMS-SDS-2-EBW-d text Zone Base metal text Crack Propagation Zone text Surface Finish text Expose Type text Expose Environment text Expose Temperature numeric °C Expose Time numeric h Remark process.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID required PK material:Material ID text Reference Code text Thickness numeric mm Type of Melting Vacuum induction melting text Furnace Capacity text t Deoxidation Process Al-Si-killed text Ingot Size [ t ] numeric t Ingot Size [ mm ] numeric mm Melting Weight numeric kg Pouring Weight numeric kg Test Block numeric kg Inoculation Yes/No text Casting Process Vacuum investment casting text Reduction Ratio [ % ] numeric % Product Form Plate, Bar text Product Size Thickness numeric mm Product Size Width numeric mm Product Size Diameter numeric mm Product Size Length numeric mm Processing Hot forging and hot rolling → Solution treatment : 1253K, 0.5h → Water quenching text Non-metallic Inclusions numeric % Non-metallic Inclusions dA numeric % Non-metallic Inclusions dB numeric % Non-metallic Inclusions dC numeric % Non-metallic Inclusions dB+dC numeric % Ferrite Grain Size Number numeric Austenite Grain Size Number numeric Alpha Grain Size T numeric um Beta Grain Size T numeric um Alpha Grain Size L numeric um Beta Grain Size L numeric um Grain Size Number numeric Grain Size numeric um Remark heattreatment.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Piece ID required PK text Reference Code text Heat Treatment 1 Type solution treatment text Heat Treatment 1 Temperature numeric C Heat Treatment 1 Time 1 numeric h Heat Treatment 1 Time 2 numeric h Heat Treatment 1 Cooling Condition Air cooling text Heat Treatment 1 Quench Bath Temperature numeric C Heat Treatment 1 Performed at text Heat Treatment 2 Type text Heat Treatment 2 Temperature numeric C Heat Treatment 2 Time 1 numeric h Heat Treatment 2 Time 2 numeric h Heat Treatment 2 Cooling Condition text Heat Treatment 2 Quench Bath Temperature numeric C Heat Treatment 2 Performed at text Heat Treatment 3 Type text Heat Treatment 3 Temperature numeric C Heat Treatment 3 Time 1 numeric h Heat Treatment 3 Time 2 numeric h Heat Treatment 3 Cooling Condition text Heat Treatment 3 Quench Bath Temperature numeric C Heat Treatment 3 Performed at text Heat Treatment 4 Type text Heat Treatment 4 Temperature numeric C Heat Treatment 4 Time 1 numeric h Heat Treatment 4 Time 2 numeric h Heat Treatment 4 Cooling Condition text Heat Treatment 4 Quench Bath Temperature numeric C Heat Treatment 4 Performed at text Heat Treatment 5 Type text Heat Treatment 5 Temperature numeric C Heat Treatment 5 Time 1 numeric h Heat Treatment 5 Time 2 numeric h Heat Treatment 5 Cooling Condition text Heat Treatment 5 Quench Bath Temperature numeric C Heat Treatment 5 Performed at text Remark tensiletest.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Test ID required PK text Test Standard JIS Z 2277 text Type of Test text Loading condition text Testing speed text Test Environment text Specimen text Specimen Dimension text Exchange Point text % Strain Rate numeric mm/sec Strain Rate 1 (1/sec) numeric 1/s Strain Rate 2 (1/sec) numeric 1/s Crosshead separation rate 1 (mm/min) numeric mm/min Crosshead separation rate 2 (mm/min) numeric mm/min Diameter numeric Thickness numeric Gauge Length numeric Parallel Length numeric Gauge Length Ratio numeric Notch Existence text Collar Existence text Remark tensileproperty.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID text Material text Piece ID required piece:Piece ID text Reference Code text Test ID tensiletest:Test ID T-T-NIMS-SDS-1-1 text Test Temperature Note: RT is stored as 25 C numeric C Yield Strength numeric MPa Upper Yield Stress numeric MPa Lower yield stress numeric MPa 0.2% Proof Stress numeric MPa Tensile Strength numeric MPa True Fracture Stress numeric MPa Elongation numeric % Reduction of Area numeric % Fractured Position Fractureed near the gauge mark projection text Stress-Strain Curve Graph file path text Remark creeptest.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Test ID PK text Test Standard JIS Z 2277 text Test Method text Test Environment text Sampling text Specimen text Diameter numeric Thickness numeric Gauge Length numeric Parallel Length numeric Gauge Length Ratio numeric Notch Existence text Collar Existence text Remark creepproperty.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID text Material text Piece ID piece:Piece ID text Test ID creeptest:Test ID T-C-NIMS-CDS-CR-1 text Test Temperature Note: RT is stored as 25 °C numeric C Test Stress numeric MPa Time to Rupture numeric h Test Elapsed Time Elapsed time for non-ruptured test numeric h Elongation numeric % Reduction of Area numeric % Fracture Location Fractured beyond the gauge mark projection text Instantaneous Strain numeric % Time to 0.10% Total Strain numeric h Time to 0.15% Total Strain numeric h Time to 0.20% Total Strain numeric h Time to 0.25% Total Strain numeric h Time to 0.5% Total Strain numeric h Time to 1.0% Total Strain numeric h Time to 2.0% Total Strain numeric h Time to 5.0% Total Strain numeric h Minimum Creep Rate numeric %/h Time to Loading numeric min Steady State Creep Rate numeric %/h Primary Creep Strain numeric % Time to Secondary Creep Start numeric h Secondary Creep Strain numeric h Time to Tertiary Creep Start numeric h Tertiary Creep Strain numeric % Creep Curve Graph file path text Count of Interruption text Remark stressrelaxation.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID text Material text Piece ID required piece:Piece ID P-M-NIMS-CDS-42-SUS316HP-AaD text Test Temparature numeric C Total Strain numeric % Initial Stress numeric MPa Time numeric h Residual Stress numeric MPa Test Duration numeric h Test Standard text Remark mechanicalproperty.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID text Material text Piece ID required piece:Piece ID P-M-NIMS-SDS-1-Ti5Al25SnELI-I-IR text Vickers Hardness Hv 98N numeric Vickers Hardness Hv 196N numeric Vickers Hardness Hv 294N numeric Brinell Hardness numeric Rockwell Hardness (HRB) numeric Rockwell Hardness (HRC) numeric Charpy impact test standard text Charpy impact type of test text Charpy impact testing machine text Charpy impact test environment text Charpy Impact Test Temperature numeric K Charpy impact test specimen text Charpy Impact Value numeric J/cm2 Charpy Absorbed Energy numeric J Fracture Toughness Test Standard text Fracture Toughness Type of Test text Fracture Toughness Testing Machine text Fracture Toughness Pre-cracking numeric mm Fracture Toughness Load Condition text Fracture Toughness Testing Speed text Fracture Toughness Test Environment text Fracture Toughness Test Temperature numeric K Fracture Toughness Test Specimen text KIC numeric MPa(m)1/2 KQ numeric MPa(m)1/2 KQ(J) numeric MPa(m)1/2 KIC(J) numeric MPa(m)1/2 Fracture Toughness numeric MPa(m)1/2 Bend Test Standard text Bend Test Condition text Bend Test text Remark elasticmodulustest.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Test ID required PK T-EM-NIMS-FDS-83 text Test Standard text Test Method Ultrasonic pluse method text Transducer JIS B5C6.3N at 5 MHz with 6.3 mm dia. text Setting of Specimen and Transducer text Specimen text Specimen Size 15 dia. 12 length text Test Environment Room temperature, laboratory air text Calculation of Young's Modulus Equation text Calculation of Shear Modulus Equation text Calculation of Poisson's Ratio Equation text Remark elasticmodulus.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID M-NIMS-FDS-1-S25C-A text Material S25C (0.25C) text Piece ID required piece:Piece ID P-M-NIMS-FDS-1-S25C-A text Test ID text Density numeric g/cm2 Young's Modulus numeric kN/mm2 Shear Modulus numeric kN/mm2 Poisson's Ratio numeric kN/mm2 Remark fatiguetest.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Test ID required PK T-F-NIMS-SDS-1-UNI-1 text Test Standard text Type of test Uniaxial text Testing Machine Servo hydraulic type, 50 kN text Loading Condition Load control text Loading Condition Details Zero mean strain text Loading Condition Name Reversed tension-compression text Stress Ratio numeric Type of test Waveform Incremental step test text Waveform Triangular text Test Environment text Strain Rate numeric Strain Rate Tension Going numeric Strain Rate Compression Going numeric Strain Holdtime numeric Class of Test Temperature text Test Temperature numeric C Frequency numeric Hz Crack Propagation Zone Butt welded joint, Weld metal text Sampling Outside text Condition of Specimen Heat treated text Specimen Butt welded joint text Specimen Dimension text Stress Concentration Factor Kt text Surface Finish As carburized text Measuring Devices of Crack Length text Current Density numeric mA/cm2 Remark fatigueproperty_lc.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID M-NIMS-SDS-1-Ti5Al25SnELI text Material Ti-5Al-2.5Sn ELI alloy text Piece ID required piece:Piece ID P-M-NIMS-SDS-1-Ti5Al25SnELI-F text Type of Property High Cycle Fatigue Property text Test ID fatiguetest:Test ID T-F-NIMS-SDS-1-UNI-1 text Test Temperature numeric C Stress Concentration Factor Specimen (Kt) text No numeric Stress Amplitude numeric MPa Stress Range numeric MPa Total Strain Amplitude numeric Number of Cycles to Failure bigint Number of Cycles Elapsed bigint Remark fatigueproperty_fs.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID M-NIMS-FDS-1-S25C-A text Material S25C (0.25C) text Piece ID required piece:Piece ID P-M-NIMS-FDS-1-S25C-A text Type of Property text Test ID fatiguetest:Test ID text Stress Ratio numeric Test Temperature numeric C Frequency numeric Hz Stress Concentration Factor Specimen (Kt) text Cycle bigint Rotating Bending numeric MPa Reversed Torsion numeric MPa Reversed Tension Compression numeric MPa Repeated Zero Tension numeric MPa Uniaxial numeric MPa Remark fatigueproperty_sc_ist.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID M-NIMS-SDS-27-Alloy625 text Material Alloy 625 text Piece ID required piece:Piece ID P-M-NIMS-SDS-27-Alloy625-F text Type of Property Low Cycle Fatigue Property text Test ID fatiguetest:Test ID T-F-NIMS-SDS-27-UNI-1 text Strain Rate numeric Test Temperature numeric C No numeric Total Strain Amplitude numeric % Plastic Strain Amplitude numeric % Stress Amplitude numeric MPa Number of Blocks to Failure bigint Remark fatigueproperty_sc_cat.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID M-W-NIMS-SDS-2-EBW-d-WJ text Material text Piece ID required piece:Piece ID P-M-W-NIMS-SDS-2-EBW-d-WJ-F text Type of Property Low Cycle Fatigue Property text Test ID fatiguetest:Test ID T-F-NIMS-SDS-2-UNI-3 text Waveform text Strain Rate numeric Test Temperature numeric C No numeric Total Strain Amplitude numeric % Plastic Strain Amplitude numeric % Total Strain Range numeric % Plastic Strain Range numeric % Number of Cycles to Failure (N25) bigint Number of Cycles to Failure bigint Number of Cycles Elapsed bigint Stress Amplitude numeric MPa Stress Range numeric MPa Maximum Stress numeric MPa Stress end of Hold numeric MPa Remark Stress end of Tensile Hold numeric MPa Stress end of Compressive Hold numeric MPa fatigueproperty_fcp.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Material ID M-NIMS-SDS-9-Alloy718 text Material Alloy 718 (1318 K ST) text Piece ID required piece:Piece ID P-M-NIMS-SDS-9-Alloy718-F text Type of Property text Test ID fatiguetest:Test ID T-F-NIMS-SDS-9-UNI-1 text Stress Ratio numeric Test Temperature numeric C Frequency numeric Hz No numeric Cycle numeric Fatigue Crack Length numeric mm Increment of Fatigue Crack Length numeric mm Load Range numeric kN Range of Stress Intensity Factor numeric MN/m3/2 Fatigue Crack Propagation Rate numeric m/cycle Remark welding.tsv Column name Note PK FK (table:Column name) Example/Description Data type Unit Welding ID required PK W-NIMS-SDS-2-TIG-a text WJ Reference Code text Series work text BM1 Piece ID piece:Piece ID P-M-NIMS-SDS-2-Alloy718 text BM2 Piece ID piece:Piece ID text WM Piece ID piece:Piece ID text FM Piece ID piece:Piece ID text DM Piece ID piece:Piece ID text Welding Method TIG (Tungusten Inert Gas Weld) text Welding Method Type TIG text Shape of Welded Joint text Fabricator text Edge Preparation text Gouging text Pass Sequence text Weld Length text Plate Size text Welding Consumable text Welding Rod text Welding Material text Shielding Gas text Welding Position text Welding Current 1-2 layer 90A 3-5 layer 95A text Welding Speed text Welding Voltage text Welding Power Source text Heat Input text Preheating text Redrying of Rod text Redrying of Welding Consumable text Interpass Temperature text Post Weld Heat Treatment text Holding Temperature numeric C Holding Time numeric s Toe Radius numeric mm Toe Radius Arithmetic Mean numeric mm Toe Radius Standard Deviation numeric mm Frank Angle numeric deg Frank Angle Arithmetic Mean numeric deg Frank Angle Standard Deviation numeric deg Bead Height numeric mm Bead Height Arithmetic Mean numeric mm Bead Height Standard Deviation numeric mm Bead Width numeric mm Bead Width Arithmetic Mean numeric mm Bead Width Standard Deviation numeric mm Mismatch numeric mm Mismatch Arithmetic Mean numeric mm Mismatch Standard Deviation numeric mm Leg Length numeric mm Leg Length Arithmetic Mean numeric mm Leg Length Standard Deviation numeric mm Angular Distortion numeric mm/m Angular Distortion Arithmetic Mean numeric mm/m Angular Distortion Standard Deviation numeric mm/m Remark