|
id
INTEGER
|
31486 |
|
iadc_material_id
INTEGER
|
2654 → iadc_discovered_materials |
|
spec_type
VARCHAR
|
spare_part |
|
key
VARCHAR
|
665417 |
|
value
TEXT
|
VALVE, GLOBE 1 IN BRONZE 150 LB FLANGE | MFR: STK | P/N: 665417 | MFG#: B-40-1 |
|
key_normalized
VARCHAR
|
665417 |
|
value_normalized
VARCHAR
|
valve, globe 1 in bronze 150 lb flange | mfr: stk | p/n: 665417 | mfg#: b-40-1 |
|
value_numeric
DOUBLE_PRECISION
|
null |
|
unit
VARCHAR
|
EA |
|
created_at
TIMESTAMP
|
2026-06-03T05:55:21.428981 |
|
source_page
INTEGER
|
null |
|
source_context
TEXT
|
part_number: 665417 | description: VALVE, GLOBE 1 IN BRONZE 150 LB FLANGE | manufacturer: STK | mfg_part_number: B-40-1 | qty_on_hand: 4 | uom: EA |