/

/

ER Diagram Schema Assistance

FEATURE

ER Diagram Schema Assistance

ER Diagram Schema Assistance

ER Diagram Schema Assistance

Visually Design and Optimize Your Database

Visually Design and Optimize Your Database

Visually Design and Optimize Your Database

All Databases

Manual Table

CSV Schema

DDL Script

ERD Diagram

Connector

Type

Name

Content

Manual Table

E-Commerce - Playground

Column, Column, Column, Column

Manual Table

Travel Agencies - Playground

Column, Column, Column, Column

Manual Table

Retail - Playground

Column, Column, Column, Column

Manual Table

Real Estate - Playground

Column, Column, Column, Column

Manual Table

Healthcare - Playground

Column, Column, Column, Column

Manual Table

Social Media - Playground

Column, Column, Column, Column

Manual Table

Library System - Playground

Column, Column, Column, Column

CSV Schema

Lorem Ipsum CSV

version 1.0

@totalColumns 9

/*---------------------------------------------------------------------------------------------------------------------------------------------------------------------------

|This schema is for the validation of technical environment metadata csv files according to the specification given for Lot 2 of the Scanning and Transcription Framework |

|Invitation To Tender document, Appendix D, in particular implementing the restrictions and consistency checks given on page 255. |

|The data in this file is a fairly general description of (software) tools used to process images, so in fact there are few hard and fast restrictions: |

|Most fields are allowed to be any length and may contain any combination of numerals, word characters, whitespace, hyphens, commas and full stops, any exception are noted |

|below. However, as the schema stands, each field must contain some value, it cannot be empty. | *

|This schema was used to validate test results supplied by potential suppliers |

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/

//the version number above is the version of the schema language, not the version of this particular schema file

//each line of the csv file being tested must contain 9 columns (fields)

batch_code: length(1,16) regex("^[0-9a-zA-Z]{1,16}$") //1st condition, must be between 1 and 16 characters long,

// and (implicitly multiple conditions are joined by a logical AND

// unless another boolean is provided)

// 2nd condition restricts to alphanumeric characters as specified in ITT p256

company_name: regex("[-/0-9\w\s,.]+")

image_deskew_software: regex("[-/0-9\w\s,.]+")

image_split_software: regex("[-/0-9\w\s,.]+")

image_crop_software: regex("[-/0-9\w\s,.]+")

jp2_creation_software: regex("[-/0-9\w\s,.]+")

uuid_software: regex("[-/0-9\w\s,.]+")

embed_software: regex("[-/0-9\w\s,.]+")

image_inversion_software: regex("[-/0-9\w\s,.]+")

ERD Diagram

Lorem Ipsum ERD

Connector

Lorem Ipsum MySQL Connector

Connector

Lorem Ipsum MySQL Connector

Connector Sub Table

Column, Column, Column, Column, Column, Column,

Connector Sub Table

Column, Column, Column, Column, Column, Column,

Connector Sub Table

Column, Column, Column, Column, Column, Column,

Prev

1

2

3

...

10

Next

Add Database

My Databases

Furkan ARCA

Pro Plan

🛢️ Manually Add

📝 Importing via CSV

📝 Importing via DDL Scripts

📂 Importing via ERD Diagrams

🔗 Importing via Data Connectors

Add ERD Diagram

Database Name* (Display Name)

ex. customers

Database Description

ex. store information about customers

ERD Diagram*

Drag and drop the ERD Diagram

or choose from a file.

Upload

Upload

What are ERD Diagrams?

ERD (Entity-Relationship Diagrams) are powerful tools used to visualize database design. These diagrams visually represent the tables in your database and the relationships between them. With AI2SQL, you can easily create and optimize your database schema using ERD Diagrams.

How to upload ERD Diagram to AI2SQL Database?

The working principle of ERD Diagrams is quite simple and user-friendly. Here is a step-by-step guide on how it works:

1

Create your ERD Diagram

Create your ERD Diagram

Create your ERD Diagram

Create your ERD diagram and place it in an appropriate folder.

Create your ERD diagram and place it in an appropriate folder.

Create your ERD diagram and place it in an appropriate folder.

2

Go to "My Databases"

Go to "My Databases"

Go to "My Databases"

On the My Database page, go to the Add Database section and click on the “Importing via ERD Diagram” option.

On the My Database page, go to the Add Database section and click on the “Importing via ERD Diagram” option.

On the My Database page, go to the Add Database section and click on the “Importing via ERD Diagram” option.

3

Fill in the Required Informations

Fill in the Required Informations

Fill in the Required Informations

Enter the display name and description for the ERD diagram you want to upload. Once you have completed your entries, click the Upload button.

Enter the display name and description for the ERD diagram you want to upload. Once you have completed your entries, click the Upload button.

Enter the display name and description for the ERD diagram you want to upload. Once you have completed your entries, click the Upload button.

Experience the power of AI at your fingertips!

Check out and try AI2SQL, the cutting-edge AI-powered platform for effortless natural language database querying.