FEATURE
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
My Databases
Furkan ARCA
Pro Plan
Importing Schema via CSV
Schema Name* (Display Name)
ex. customers
CSV Schema*
00
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
ex.
id,
first_name,
last_name,
email,
created_at,
Drag and drop the CSV File
or choose from a file.
What is CSV Imports?
CSV Imports is an efficient data integration method offered by the AI2SQL platform. This feature allows users to quickly and easily import their existing data in CSV format into their databases. CSV files, which organize data in a tabular format, are widely used. With AI2SQL’s CSV Imports feature, you can directly integrate these files into your database and start your analysis immediately.
How Does It Work?
Using the CSV Imports feature is straightforward and user-friendly. Here’s a step-by-step guide on how it works:
1
2
3
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.