DEVELOPMENT OF A WEB APPLICATION FOR VISUAL DESIGN OF A DATA SCHEME WITH THE POSSIBILITY OF UPLOADING A SCRIPT FOR CREATION OF TABLES

Prohorov E. V., Dorofeev A. S.

The article is devoted to the issue of developing a web application for designing a data schema with the ability to generate and download an SQL script to create data tables of the selected DBMS and SQL language dialect. The architecture of the web application, the technology stack for its implementation are considered, and the general interface of the system is presented. The planned inclusion of a subsystem for setting the correspondence of table creation operators and setting attribute characteristics using the theory of translators and setting grammar and rules for a specific SQL dialect will expand the capabilities of the created application.

Keywords:data schema, relational database, SQL, script generation, web application, PosgreSQL, Node.js, React.js.