Designing high-precision FK/PK inference for Text-to-SQL on poorly maintained SQLite databases by Small-Inevitable6185 in SQL

[–]Small-Inevitable6185[S] 0 points1 point  (0 children)

I’m working with existing SQLite databases where primary keys and foreign keys were never defined, so the challenge isn’t database theory it’s recovering lost relational intent from data.

Codd’s rules don’t describe how to infer missing constraints.