|
id
INTEGER
|
24528 |
|
iadc_material_id
INTEGER
|
2654 → iadc_discovered_materials |
|
spec_type
VARCHAR
|
spare_part |
|
key
VARCHAR
|
667099 |
|
value
TEXT
|
VALVE, GATE 3/4 IN 150 PSI BRONZE | MFR: GRI | P/N: 667099 | MFG#: 04/03/80 |
|
key_normalized
VARCHAR
|
667099 |
|
value_normalized
VARCHAR
|
valve, gate 3/4 in 150 psi bronze | mfr: gri | p/n: 667099 | mfg#: 04/03/80 |
|
value_numeric
DOUBLE_PRECISION
|
null |
|
unit
VARCHAR
|
EA |
|
created_at
TIMESTAMP
|
2026-06-03T05:55:21.421622 |
|
source_page
INTEGER
|
null |
|
source_context
TEXT
|
part_number: 667099 | description: VALVE, GATE 3/4 IN 150 PSI BRONZE | manufacturer: GRI | mfg_part_number: 04/03/80 | qty_on_hand: 3 | uom: EA |