platomix-gmetry-etl/sqls/etl_sql_column/init.sql

INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'CHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'VARCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'LONGVARCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'BINARY');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'VARBINARY');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'LONGVARBINARY');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'BLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'CLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'NCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'NVARCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'LONGNVARCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'NCLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'ARRAY');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 0, 'DATE');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 0, 'TIME');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 0, 'TIMESTAMP');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 0, 'DATETIME');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'BIT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 0, 'TINYINT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 0, 'SMALLINT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 0, 'INTEGER');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 0, 'BOOLEAN');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 0, 'BIGINT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('FLOAT', 0, 'FLOAT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 0, 'REAL');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 0, 'DOUBLE');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 0, 'DECIMAL');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'CHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'VARCHAR2');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 1, 'NUMBER');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 1, 'DATE');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('FLOAT', 1, 'FLOAT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'CLOB RAW');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'VARCHAR2 CLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 1, 'NUMBER(19,0)');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 1, 'NUMBER(7,0)');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 1, 'NUMBER(5,0)');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('BOOLEAN', 1, 'NUMBER(3,0)');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('FLOAT', 4, 'Float32');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 4, 'Float64');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 4, 'Int32');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 4, 'Int8');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 4, 'Int16');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 4, 'UInt8');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 4, 'UInit16');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 4, 'UInut32');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 4, 'Int64');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 4, 'Int128');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 4, 'Inte256');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 4, 'UInit64');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 4, 'UInit128');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 4, 'UInit256');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 4, 'String');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 4, 'Decimal');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 4, 'Decimal32');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 4, 'Decimal64');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 4, 'Decimal128');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 4, 'DateTime');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 4, 'DATE');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 4, 'DATE32');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 4, 'DateTime64');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 4, 'JSON');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 4, 'UUID');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 4, 'fixedString');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'TEXT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'ARRAY');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'BINARY');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'BLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'CHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'CLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'LONGNVARCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'LONGVARBINARY');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'LONGVARCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'NCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'NCLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'NVARCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'TEXT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'VARBINARY');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'VARCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'UUID');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'XML');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 3, 'JSON');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 3, 'BIT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 3, 'BOOLEAN');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 3, 'INT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 3, 'INTEGER');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 3, 'SMALLINT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 3, 'TINYINT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 3, 'int2');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 3, 'int4');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 3, 'int8');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 3, 'BIGINT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 3, 'double precision');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 3, 'DOUBLE');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 3, 'REAL');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 3, 'DECIMAL');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('FLOAT', 3, 'FLOAT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 3, 'DATETIME');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 3, 'DATE');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 3, 'TIME');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 3, 'TIMESTAMP');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 5, 'varchar');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 5, 'char');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 5, 'text');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 5, 'character varying');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 5, 'varchar2');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 5, 'nvarchar2');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 5, 'nvarchar');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 5, 'character');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 5, 'longtext');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 5, 'mediumtext');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 5, 'tinytext');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 5, 'decimal');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 5, 'numeric');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 5, 'number');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 5, 'fixed');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 5, 'double');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('FLOAT', 5, 'real');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 5, 'double precision');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 5, 'bigserial');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('FLOAT', 5, 'float');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('FLOAT', 5, 'smallserial');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('FLOAT', 5, 'serial');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 5, 'date');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 5, 'timestamp');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 5, 'int8');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 5, 'bigint');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 5, 'int');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 5, 'int4');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 5, 'tinyint');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 5, 'int1');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 5, 'smallint');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 5, 'middleint');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 5, 'mediumint');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 5, 'int3');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 5, 'integer');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 5, 'Float8');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 5, 'int2');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 6, 'INT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 6, 'SMALLINT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 6, 'TINYINT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 6, 'INTEGER');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 6, 'PLS_INTEGER');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 6, 'NUMERIC');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 6, 'DECIMAL');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('FLOAT', 6, 'FLOAT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 6, 'DOUBLE');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 6, 'TIMESTAMP');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 6, 'DATE');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 6, 'TIME');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 6, 'BIGINT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 6, 'VARCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 6, 'TEXT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 6, 'CHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'LONGTEXT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 2, 'char');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 2, 'varchar');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 2, 'text');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 2, 'nchar');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 2, 'nvarchar');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 2, 'ntext');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 2, 'uniqueidentifier');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 2, 'xml');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 2, 'bigint');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 2, 'decimal');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 2, 'money');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 2, 'smallmoney');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 2, 'numeric');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 2, 'int');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 2, 'smallint');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 2, 'tinyint');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 2, 'float');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('FLOAT', 2, 'real');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 2, 'time');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 2, 'date');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 2, 'datetime2');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 2, 'datetimeoffset');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 2, 'datetime');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 2, 'smalldatetime');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 3, 'NUMERIC');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 3, 'smallserial');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 3, 'serial');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 3, 'bigserial');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 2, 'bit');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 2, 'binary');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 2, 'varbinary');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'CLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'NCLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'BLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'RAW');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'BFILE');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'ROWID');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'NROWID');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'nvarchar2');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 1, 'real');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('LONG', 1, 'long');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'nchar');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 1, 'integer');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 1, 'decimal');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 1, 'UROWID');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'LONGBLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 0, 'INT UNSIGNED');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 0, 'INT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 0, 'MEDIUMTEXT');