Now Transform Your Simple Text To Database Script

To reduce your time to create a database, write down your database name, tables and foreign key in simple text with pre-defined symbols and convert it into database script, paste that script in your development environment.

Support is now available for MSSQL, MySQL and PostgreSQL.

@  =  Database Name
#  =  Table Name
-  =  Column Name
()  =  Foreign Key

Rules:

  1. Only 1 database name (@) is allowed per file.
  2. Only 2 types are supported, int and varchar, all foreign keys will be created as int (no need to specify int for foreign key), if you need any column as int, write ‘id’ keyword anywhere in its name.
  3. All table primary keys are created automatically, so you do not need to specify primary key in each table, it is created as “tablename”_id.
  4. All foreign key tables are created automatically, for example if I write only column ord(Orders) ,  it shall do the following steps:
    – Create Orders table with foreign key as Orders_id
    – Create ord as int
    – Reference Orders_id to ord column
  5. You can also add more fields to foreign key tables.
  6. For PostgreSQL please use SQL Shell (psql) to create database on a single enter button, you should be logged in using admin. (postgres)

For new users : Just copy and paste any template in text area to see the result


@MyShoppingCart
#users
-first_name
-last_name

#vehicle
-name
-color
-no_plate

#suppliers
-name
-description

@MyShoppingCart
#users
-first_name
-last_name

#vehicle
-name
-color(colors)
-no_plate

#suppliers
-name(factory)
-description

@ShoppingManagement
#OrderDetails
-orderDate
-shipmentDate
-shipmentStatus

#Customer
-name
-location
-contact
-club_points
-totalSpent

#Employee
-name
-location
-contact_id
-salary
-comission
-oid(Orders)
-pid(Products)

#Products
-name
-type
-subtype

#Orders
-cid(Customer)
-pid(Products)
-eid(Employee)
-quantity
-totalPrice

MySql
MSSQL
PostgreSQL
Oracle (Coming Soon!)

Please enter format in first text area and click on “Convert” button


Reach me out at : txt2db@gmail.com