## Top-Level Statements by Type

Standalone top-level SQL statements by type excluding nested statements that appear inside other statements (CREATE TABLE or INSERT inside CREATE PROCEDURE i.e.):

| Statement Type | Count | Conversion | Complexity | Lines | Need Conversion | Automated | Manual
--- | --- | --- | --- | --- | --- | --- | --- | ---
1 | Table | 1 | Check: 1 ! (1/1) | Undefined: 1 | 8 | 4 | 50.0% | 4 | 100.0% | 0 | 0.0%

Total: 1 distinct statement type, 1 occurrence.

## All SQL Statements

Note that some statements can be nested within others (CREATE TABLE or INSERT inside CREATE PROCEDURE i.e. so issues, lines and other metrics cannot be summed):

| Statement | Description | Count | Conversion | Complexity | Lines | Need Conversion | Automated | Manual
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATE TABLE | Create table | 1 | Check: 1 ! (1/1) | Undefined: 1 | 8 | 4 | 50.0% | 4 | 100.0% | 0 | 0.0%

Total: 1 distinct statement, 1 occurrence.

CREATE TABLE statements details:

| Details | Description | Count | Conversion | Complexity
--- | --- | --- | --- | --- | ---
1 | NOT NULL | NOT NULL constraint ※ | 1 | No Need: 1 ✓ |
2 | NULL | NULL constraint ※ | 4 | No Need: 4 ✓ |
3 | PRIMARY KEY | Primary key constraint | 1 | No Need: 1 ✓ |

## Data Types

All built-in data types:

| Source Data Type | Description | Count | Conversion | Complexity
--- | --- | --- | --- | --- | ---
1 | DATETIME | Date and time with fraction | 1 | Check: 1 ! | Undefined: 1
2 | INTEGER | Integer number | 2 | No Need: 2 ✓ |
3 | VARCHAR | Variable-length string | 2 | No Need: 2 ✓ |

Total: 3 distinct data types, 5 occurrences.

Built-in data type details:

| Source Data Type | Count
--- | --- | ---
1 | VARCHAR(<=255) | 2

Total: 1 distinct data type specification, 2 occurrences.

## Conversion Issues

Conversion issues that require review:

| Issue | Description | Count
--- | --- | --- | ---
1 | DATETIME | Date and time with fraction | 1

Total: 1 distinct conversion issue, 1 occurrence.