Edit #2654 — iadc_discovered_materials

id

INTEGER · required

Auto-generated

vessel_id

INTEGER · required

vessel_document_id

INTEGER

category

VARCHAR(150)

subcategory

VARCHAR(150)

name

VARCHAR(200) · required

description

TEXT

attributes

JSON

{"spare_parts_count": 13055, "total_inventory_value": 0, "total_qty_on_hand": 106142, "spare_part_manufacturers": "11X, 3CO, 3M, 3MEL, 3MOF, 3MS, 3MTD, AAF, AAN, AAS, AB, ABB, ABBA, ABBC, ABBF, ABBL, ABCO, ABCS, ABIN, ABR, ABU, ACCU, ACE, ACF, ACG, ACH, ACI, ACMA, ACO, ACP, ACSI, ADD, ADE, ADF, ADK, ADM, ADOT, ADV, ADVC, ADY, AEE, AEES, AEFA, AEGC, AEL, AEMC, AER, AETC, AEU, AFI, AGAA, AGAS, AGC, AGI, AGL, AGR, AHC, AHF, AHLS, AHN, AIF, AIM, AIO, AIRP, AKAA, AKG, AKM, ALAP, ALAT, ALCA, ALE, ALLW, ALPG, ALQ, ALTD, AMD, AME, AMER, AMI, AMIF, AMII, AMJC, AMN, AMO, AMQ, AMRM, AMT, AMTC, AMY, ANB, ANI, ANO, ANPP, ANRF, ANTS, AOC, AOIC, APCT, APO, APP, APQ, AQE, AQF, AQO, AQTR, AQU, AQV, ARC, ARCW, ARD, ARK, ARM, ARMI, ARO, ARS, ARU, ARVI, ARX, AS, ASA, ASCO, ASD, ASDR, ASH, ASL, ASPR, ASTH, ATBA, ATE, ATF, ATK, ATOS, ATR, ATRI, ATU, ATY, AUC, AUE, AUH, AUN, AUSPV, AVAY, AVP, AWB, AWCI, AXIO, AXR, AXT, AYB, BAA, BACO, BAD, BAE, BAGG, BAH, BAK, BAM, BAN, BAR, BB, BBX, BCC, BCO, BDAC, BDL, BDR, BDSG, BDYV, BECN, BEDV, BEM, BENT, BEP, BER, BERE, BET, BEVI, BEZ, BGTL, BHAG, BHP, BIC, BIRT, BJ, BJON, BKA, BKC, BKL, BLDM, BLF, BME, BMI, BML, BMN, BND, BNTT, BOA, BOCG, BODI, BOI, BOL, BOLT, BOM, BONM, BONP, BOOP, BOW, BPS, BRAU, BRCI, BRI, BRK, BROS, BRR, BRT, BRW, BRYP, BRZ, BSMDO, BSMP, BSRH, BSW, BSY, BUB, BUE, BUL, BUS, BUSA, BUX, BVC, BWV, BYI, BYRN, BYS, BYT, BZP, BZR, B_BE, B_D, B_V, B_W, CA, CAC, CAII, CAK, CAM, CAMM, CAO, CAR, CARA, CARD, CAS, CATH, CAUK, CAVG, CBB, CC, CCCO, CCF, CCJ, CCY, CEMB, CENG, CEO, CEP, CES, CEV, CFD, CFX, CGI, CH, CHF, CHH, CHI, CHLL, CHM, CHMT, CHNN, CHYN, CIGW, CISP, CIW, CLA, CLIF, CLIP, CLS, CLSF, CMG, CMK, CMPT, CNAV, CNF, COAX, COB, COBT, COC, COF, COG, COH, COI, COK, COLS, COMP, COMPR, COMR, CONQ, CORN, CP, CQC, CR, CRA, CRC, CRCO, CREE, CRM, CRNC, CRNL, CRO, CROI, CRPI, CRSR, CRT, CRTC, CRYS, CSR, CSTA, CTE, CTH, CTIL, CTS, CUT, CVC, CWE, CWSI, CYLE, CYS, CZT, DAD, DANM, DAVV, DAYL, DBL, DBS, DCC, DCE, DCL, DCN, DCO, DCR, DEEP, DEIF, DELL, DEM, DEMA, DETR, DEU, DEV, DEW, DFP, DFS, DGO, DGP, DHF, DHN, DIEQ, DII, DIKVLV, DINC, DIT, DIX, DKC, DKS, DLB, DLJ, DLS, DMM, DMW, DNC, DNF, DNH, DNN, DOA, DOD, DOE, DOL, DOO, DORM, DOW, DPN, DPO, DPSL, DRAT, DRE, DREG, DRI, DRK, DRM, DROG, DRPS, DRSI, DRUC, DSUD, DTN, DTS, DTT, DTX, DUNL, DURA, DWC, DWY, DYD, DYM, DYMA, DYQ, E, EAG, EAT, EBEC, EBMP, EBRO, ECK, EFH, EGD, EHI, EKL, ELEA, ELEC, ELRI, ELS, ELSI, EMB, EMBR, EMD, EMPM, EMR, EMS, EMT, ENE, ENH, ENR, ENRM, ENTL, EOP, EP, EPIM, ERI, ERR, ESAB, ESE, ESN, ETI, EUC, EVAC, EVP, EVR, EVT, EWM, EWTR, EX, EXI, EXLO, EXPO, EXT, EYS, EZIH, FAF, FAG, FAH, FAI, FAST, FCS, FCW, FEC, FEF, FERS, FESH, FHFG, FHI, FIB, FIND, FIP, FIS, FISI, FJT, FKJ, FKOG, FKS, FLOT, FLT, FLTL, FLW, FLX, FLXO, FLY, FMCP, FMR, FNT, FO, FOO, FPE, FPI, FPS, FPT, FRA, FRD, FRH, FRI, FRO, FRY, FRYM, FS, FUA, FUC, FUGR, FUJC, FVEL, FWG, FYDB, FYT, GAI, GAK, GAO, GAR, GAT, GB, GBR, GCII, GCR, GD, GDE, GDL, GDW, GE, GEO, GEP, GEW, GIBB, GIE, GIG, GIL, GLBLRS, GLM, GLMC, GLOM, GNC, GOJ, GP, GPH, GPV, GRA, GRB, GRC, GRF, GRH, GRI, GRR, GRTT, GRU, GSC, GSF, GSHY, GTSI, GUN, GVL, GWS, GWW, HAHY, HAL, HAMC, HANL, HAO, HAS, HAWK, HBEG, HBNR, HBUF, HBWT, HCH, HCK, HDCO, HDE, HDF, HDHO, HDI, HDL, HDR, HEH, HEIN, HELP, HEMO, HENG, HESS, HF, HFI, HFSON, HGN, HGUY, HHO, HHSS, HIA, HISI, HISS, HITE, HJET, HJW, HKP, HLF, HLIT, HLP, HLT, HLV, HME, HMMF, HMO, HMW, HNH, HNW, HOB, HOF, HOI, HOK, HOL, HOU, HP, HPBC, HPC, HPN, HPS, HPX, HRY, HS, HSCO, HSEC, HSK, HSL, HSNE, HST, HSTR, HTC, HTD, HTG, HTO, HUB, HUC, HUU, HWCH, HWD, HWEH, HWY, HYA, HYF, HYQ, HYS, HYT, HYTG, HYX, I, IAL, IAT, IBM, ICEQU, IDSA, IEN, IFME, IGI, IGL, IITC, IKG, ILI, ILS, IMI, IMP, IMPP, IMSL, INA, INOR, INR, INTF, INTP, IPD, IPH, IPP, IPSO, IQ, IR, IRCL, IRON, ISC, ISCA, ISD, ISOX, ITAG, ITAL, ITB, ITE, ITET, ITN, ITS, ITSL, ITT, IVO, IVS, IVT, J, J _ J, J-B, JABR, JAES, JBL, JBP, JBS, JEL, JELE, JET, JHC, JHN, JKSA, JKSI, JNE, JNO, JOKW, JON, JOWA, JRC, JSE, JTE, JUS, JVC, KAC, KAI, KAME, KATE, KEET, KEL, KEO, KEY, KGT, KHS, KIC, KIT, KITI, KKV, KLAW, KLN, KML, KMP, KMY, KNEX, KNFN, KNL, KOC, KOCK, KOH, KOMAT, KON, KOP, KRIWAN, KRM, KSB, KSI, KSN, KSR, KST, KSUN, KTN, KTRC, KUKA, KUL, KUT, KYL, K_LR, K_N, K_W, LABL, LAGA, LAL, LAPR, LAPS, LAW, LCL, LCN, LDE, LDI, LDT, LED, LEGR, LEO, LER, LETI, LEV, LEW, LFES, LGY, LHI, LHR, LHRM, LIII, LIN, LIS, LIST, LITO, LJ, LKE, LLAB, LLL, LMA, LMB, LMD, LMG, LMI, LMMA, LMTH, LNIE, LOC, LOH, LOIP, LONN, LOS, LOV, LPS, LREL, LSA, LSW, LTEK, LTF, LTH, LUF, LUM, LUN, LUP, LYS, M, MAEI, MAGV, MAH, MAJ, MALN, MAND, MANH, MAR, MASU, MCC, MCDC, MCE, MCGL, MCIC, MCK, MCM, MCSI, MCSX, MCU, MCX, MD, MEAW, MEB, MEDC, MEE, MEGG, MENO, MENT, MEP, MEPR, MERS, MEST, METO, METS, MEW, MEX, MFS, MFX, MGA, MGI, MGN, MGNL, MGO, MGR, MGWE, MHA, MHWT, MICS, MIF, MIM, MITA, MK, MKA, MKK, MKO, MKS, MKSN, MKU, MLK, MLM, MLRE, MLRS, MLT, MMED, MMI, MMIS, MMSI, MNE, MNG, MNS, MOG, MOLX, MONT, MOOR, MOR, MOSL, MOT, MPF, MRA, MRDL, MRK, MRL, MRN, MRTP, MSA, MSB, MSF, MSH, MSS, MT, MTA, MTAU, MTG, MTIN, MTN, MTPL, MTR, MTSS, MUE, MUX, MVC, MVW, MWK, MWPC, MXO, MYM, MYO, M_MI, NAGM, NAI, NAL, NAN, NAPC, NAU, NBC, NBR, NDC, NE, NERA, NESC, NEU, NGA, NHN, NIA, NIB, NKI, NLCK, NLS, NMA, NMR, NNC, NOA, NOBL, NOE, NOKJ, NOL, NON, NOR, NOT, NOV, NPC, NPG, NPT, NRT, NSKC, NSL, NSSL, NSZ, NTN, NTSS, NTX, NUC, NUCA, NUP, NUS, NVI, NWW, OBSE, OBSV, ODSH, OET, OFC, OFI, OGR, OHM, OIH, OILT, OKI, OLDF, OLM, OMG, OML, OMR, OMTX, OPA, OPT, OR0343, OR0483, OR1993, OR2059, OR2244, OR2732, OR3570, OR3925, ORA, ORGA, OSE, OSHS, OSK, OSO, OSP, OSR, OSSC, OST, OSTR, OTB, OTE, OTI, OUTR, OW, OXI, OZI, PAL, PAN, PANA, PANT, PAPH, PAS, PAU, PAY, PBP, PBR, PCD, PCG, PCL, PDC, PDH, PDN, PDP, PDT, PEHA, PELT, PETC, PETZ, PFI, PFPI, PGAS, PGS, PH, PHC, PHF, PHL, PHNX, PHO, PHOO, PINI, PIRT, PIS, PK, PKS, PLCO, PLK, PLT, PN, PNA, PNG, POF, POWE, POWL, POWP, PPA, PPG, PPN, PPR, PQO, PRCH, PRDO, PREG, PREL, PRK, PRL, PRM, PRO, PROC, PRPR, PRV, PRW, PRZ, PSL, PTA, PTD, PTS, PUG, PUL, PULS, PUS, PWGS, PWW, PWX, PXC, PYG, PYO, P_F, RAD, RADO, RAL, RAR, RBBV, RBO, RBP, RCIN, RCP, RCR, RCY, RDM, RDV, RED, REDI, REEL, REGA, RELC, RESM, RFC, RGD, RGL, RGLV, RGTL, RH, RHPS, RHW, RIA, RICH, RID, RIL, RLP, RMS, RNT, ROB, ROBE, ROCL, ROJ, ROK, ROM, ROTO, ROX, ROXT, RPSM, RROA, RRS, RSC1, RSME, RST, RTF, RTKT, RTL, RTS, RTT, RUSC, RVC, RW, RWCOUP, RXR, RXT, RYLE, RYTC, R_S, S, SABR, SAFE, SAFW, SAM, SAN, SANA, SANL, SAO, SAV, SBEH, SCAB, SCAF, SCGR, SCHF, SCHL, SCHN, SCLR, SCT, SC_E, SDAS, SDI, SDK, SDPT, SDV, SDX, SE, SEA, SEAU, SECL, SEIM, SEMC, SEO, SEPL, SEUR, SF, SFF, SFFR, SFM, SFS, SFT, SGE, SGG, SGH, SGI, SGM, SGMI, SHA, SHC, SHG, SHL, SHRP, SHUK, SHV, SIBA, SIGD, SIK, SIKA, SIKC, SIMN, SIN, SIND, SING, SINS, SIR, SKA, SKD, SKF, SKG, SKP, SKT, SKUM, SKYW, SLA, SLC, SLK, SLR, SLS, SMET, SMK, SMM, SMP, SMSG, SMV, SMY, SNA, SNAPRT, SNK, SNL, SNMD, SNO, SNR, SNST, SNU, SNY, SOC, SOCO, SOL, SOO, SOSI, SOTR, SOW, SPAR, SPEE, SPGR, SPMA, SPQ, SPTI, SPTR, SPV, SPY, SQAD, SQD, SRAS, SRE, SRG, SRH, SRIENG, SRVT, SRX, SSAS, SSC, SSCC, SSL, SSML, SSN, SSR, SST, SS_S, ST, STAH, STAI, STBL, STEA, STII, STIM, STK, STML, STNE, STOC, STR, STRB, STSM, STVI, STY, STYR, SUBX, SUCO, SUFL, SUHM, SUL, SUNB, SUND, SUNO, SURE, SVF, SVRM, SW, SWA, SWE, SWI, SWL, SWO, SWR, SWTE, SYL, SYN, SYRX, S_S, TAA, TAPF, TAS, TAYTC, TBG, TCL, TDV, TDYN, TEA, TEC, TEE, TEKT, TEL, TEM, TES, TESS, TEVA, TFC, TFF, TFO, TGNS, THE, THEM, TIF, TIL, TIM, TING, TISS, TKR, TLA, TLN, TM, TMC, TMQ, TNE, TNH, TNT, TO, TOAE, TOB, TOFT, TOG, TOM, TOPN, TPL, TPU, TRAF, TRAN, TRC, TRCO, TRDT, TREL, TRIO, TRK, TRMC, TSA, TSAS, TSH, TSM, TSST, TT, TTO, TTY, TUA, TUB, TUT, TVG, TWC, TWY, TXI, TYC, TYCO, TYR, TYRO, TYT, T_B, T_C, T_S, UAI, UCC, UIF, ULTS, UNA, UNBR, UNG, UNK, UNKA, UNM, UNN, UNP, USAC, USBT, USE, USFI, USKO, USPC, USS, UTC, UTR, UTX, UWL, UWO, VALF, VAR, VBBC, VCIG, VCT, VEG, VEI, VEL, VEM, VGA, VGI, VHP, VHS, VIC, VIG, VIKA, VKC, VKR, VLE, VLGP, VLL, VLS, VMCI, VNB, VNC, VOL, VOSH, VPRD, VRTX, VRV, VRY, VUL, VVAL, VVC, VVI, W40, WAB, WAFI, WAN, WASS, WBC, WBD, WCY, WDD, WDI, WDM, WEC, WELD, WELE, WEN, WFH, WHIG, WHKT, WHO, WHS, WIA, WICH, WIHE, WIL, WINL, WIP, WKC, WKS, WLL, WLM, WLN, WLT, WLZ, WME, WMK, WML, WMSC, WNE, WNS, WOA, WOD, WODC, WOO, WOOS, WOR, WRA, WRD, WRG, WRP, WTAP, WTD, WTN, WTR, WTS, WTT, WTY, WWD, WWE, WWI, WWS, WYKO, W_O, YAE, YAK, YIC, YJP, YLE, YOK, YORK, YRK, YST, YUA, ZIN, ZIPSP, ZLL, ZNDR, ZPL, ZWA"}

remarks

TEXT

verification_status

VARCHAR(19) · required

is_active

BOOLEAN · required

created_at

TIMESTAMP · required

updated_at

TIMESTAMP · required

promoted_material_id

INTEGER

source_pages

JSON

source_type

VARCHAR(20)

raw_text

TEXT

make

VARCHAR(200)

model

VARCHAR(200)

Edit row #2654 in iadc_discovered_materials