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

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', 6, 'CHARACTER');
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, 'VARCHAR2');

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, 'LONGVARCHAR');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 6, 'BLOB');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('STRING', 6, 'CLOB');

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, 'INT');
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, 'SMALLINT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 6, 'BYTE');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 6, 'BIT');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('INTEGER', 6, 'BYTE');

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 ('DOUBLE', 6, 'DOUBLE');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DOUBLE', 6, 'DOUBLE PRECISION');

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 ('FLOAT', 6, 'REAL');

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 ('DECIMAL', 6, 'DEC');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DECIMAL', 6, 'NUMBER');

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 ('DATE', 6, 'TIMESTAMP');
INSERT INTO `digital_operation`.`etl_sql_column` (sql_column_type, ds_type, column_type)
VALUES ('DATE', 6, 'TIME WIT TIME ZONE');