The fragmentation of obstetric information across electronic health record modules, device repositories, and laboratory systems, as it is common in hospitals, hinders both intrapartum care and reproducible research. In this work, we present a practical blueprint for transforming heterogeneous peripartum records into computable, queryable assets by designing and prototyping a unified peripartum relational database with natural-language-to-SQL (NL2SQL) capabilities at the Obstetrics Clinic of Udine University Hospital. Requirements were co-defined with clinicians and formalized as an Entity-Relationship diagram, from which the logical schema and SQL implementation of the database were then derived. The latter integrates heterogeneous sources to connect maternal anamnestic and longitudinal history, current-pregnancy findings, intrapartum course, and delivery and neonatal outcomes. The NL2SQL layer enables clinicians to pose natural-language queries to the system, lowering barriers to audit and exploratory analysis.

翻译：产科信息分散在电子健康记录模块、设备存储库和实验室系统中——这种医院普遍存在的现象——既阻碍了产时护理，也影响了可重复性研究。本研究通过为乌迪内大学医院产科诊所设计和开发一个具备自然语言转SQL（NL2SQL）功能的统一围产期关系型数据库，提出了将异构围产期记录转化为可计算、可查询资源的实用方案。我们与临床医生共同确定了需求，并将其形式化为实体关系图，进而推导出数据库的逻辑模式与SQL实现。该数据库整合了异构数据源，将产妇既往史与纵向病史、当前妊娠检查结果、产时过程以及分娩和新生儿结局相互关联。NL2SQL功能层使临床医生能够向系统提出自然语言查询，显著降低了审计与探索性分析的门槛。