Extract PDF Tables to SQLite

I have a collection of PDFs whose tables combine normal text with embedded images, so simple copy-and-paste will not do. Your task is to pull every table out of each file, run OCR where the cells are only images, and populate a custom-designed SQLite database. We will agree on the schema up front so the final .sqlite file lines up with my downstream reporting tools.

Accuracy is key: numbers must keep their formatting, column order must stay intact, and any footnotes that belong to a row need to be captured in a linked field rather than discarded. Whether you prefer Python with Camelot, Tabula-py, pdfplumber, Tesseract, or another extraction stack is up to you—as long as the workflow is reproducible.

Once all conversions are complete, send me the finished database along with the script or notebook you used so I can rerun the process when new PDFs arrive.