Table structure

Navigation:  Interfacing BREIN > Export of results > to an external SQL database >

Table structure

Previous pageReturn to chapter overviewNext page

The external database must have a suitable table with a structure exactly matching the structure of the results page of BREIN. In order to generate the proper table structure you can visit the tab "Panes" and click on the button "Generate SQL script".

In the folder of the current BREIN product, 2 text files are generated. The first named "sql_script_product_stats_checks.sql" contains the SQL script to generate a table for the BREIN statistics checks results. The second is called "sql_script_product.sql" and contains the script to generate the results table. This is identical to the text that appears in the text field below the "Generate SQL script" button.