You won't be able to see the exact SQL needed to build a database anywhere in the core as it is created dynamically. Anyway, you can see some table definitions that are quite easy to read here. Those correspond to v1.7.4 and should be a useful starting point.
Welcome to the Q&A site for Question2Answer.
If you have a question about Q2A, please ask here, in English.
To report a bug, please create a new issue on Github or ask a question here with the bug tag.
If you just want to try Q2A, please use the demo site.
July 25th, 2023: Q2A 1.8.8 released!