The Prospective Lynch Syndrome Database: background, design, main results and complete MySQL code

A brief description of why and for which purposes the Prospective Lynch Syndrome Database was established, the principles and design, and the main classes of results are given. Data input is assumption-free input enabling validation of paradigms used to explain the results. The design is considering cancer/age as discrete events to occur or not in a time dimension in a closed room compliant with population genetic paradigms and last centuries developing paradigms of interpreting discrete events reflecting conditional and/or co-occurring stochastic probabilities. Which may be in contrast to the paradigm that any observed event has a cause. The results may indicate that some current paradigms on carcinogenesis should be reconsidered. The complete analytic code in MySQL© syntax together with a flowchart illustrating how the different pieces of codes interrelate are included as supplementary files, enabling third parties to use or modify the code to examine prospectively observed events in their own activities when referring to this report as the source. SUPPLEMENTARY INFORMATION: The online version contains supplementary material available at 10.1186/s13053-022-00243-z.