firethorn

changeset 4293:a0341ca72077 2.1.35-stv-issue-1182

Undo changes to pgsql_tap_schema.sql
author Stelios <stv@roe.ac.uk>
date Fri Mar 06 00:51:33 2020 +0200 (11 months ago)
parents 822a5b9c622b
children 7b4b6bf2b113
files firethorn-webapp/src/main/webapp/WEB-INF/data/pgsql_tap_schema.sql
line diff
     1.1 --- a/firethorn-webapp/src/main/webapp/WEB-INF/data/pgsql_tap_schema.sql	Fri Mar 06 00:45:12 2020 +0200
     1.2 +++ b/firethorn-webapp/src/main/webapp/WEB-INF/data/pgsql_tap_schema.sql	Fri Mar 06 00:51:33 2020 +0200
     1.3 @@ -10,39 +10,39 @@
     1.4  INSERT INTO "TAP_SCHEMA"."tables" ("schema_name", "table_name", "table_type", "description", "utype", "ft_table_id") VALUES ('TAP_SCHEMA', 'TAP_SCHEMA.columns', 'table', 'List of columns of all tables listed in TAP_SCHEMA.TABLES and published in this TAP service.', NULL,0);
     1.5  INSERT INTO "TAP_SCHEMA"."tables" ("schema_name", "table_name", "table_type", "description", "utype", "ft_table_id") VALUES ('TAP_SCHEMA', 'TAP_SCHEMA.keys', 'table', 'List all foreign keys but provides just the tables linked by the foreign key. To know which columns of these tables are linked, see in TAP_SCHEMA.key_columns using the key_id.', NULL,0);
     1.6  INSERT INTO "TAP_SCHEMA"."tables" ("schema_name", "table_name", "table_type", "description", "utype", "ft_table_id") VALUES ('TAP_SCHEMA', 'TAP_SCHEMA.key_columns', 'table', 'List all foreign keys but provides just the columns linked by the foreign key. To know the table of these columns, see in TAP_SCHEMA.keys using the key_id.', NULL,0);
     1.7 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id") VALUES ('TAP_SCHEMA.schemas', 'schema_name', 'schema name, possibly qualified', '', '', '', 'char', -1, 256, 1, 0, 1, 0);
     1.8 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id") VALUES ('TAP_SCHEMA.schemas', 'description', 'brief description of schema', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
     1.9 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.schemas', 'utype', 'UTYPE if schema corresponds to a data model', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.10 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'schema_name', 'the schema name from TAP_SCHEMA.schemas', '', '', '', 'char', -1, 256, 1, 0, 1, 0);
    1.11 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'table_name', 'table name as it should be used in queries', '', '', '', 'char', -1, 256, 1, 0, 1, 0);
    1.12 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'table_type', 'one of: table, view', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.13 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'description', 'brief description of table', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.14 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'utype', 'UTYPE if table corresponds to a data model', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.15 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'table_name', 'table name from TAP_SCHEMA.tables', '', '', '', 'char', -1, 256, 1, 0, 1, 0);
    1.16 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'column_name', 'column name', '', '', '', 'char', -1, 256, 1, 0, 1, 0);
    1.17 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'description', 'brief description of column', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.18 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'unit', 'unit in VO standard format', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.19 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'ucd', 'UCD of column if any', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.20 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'utype', 'UTYPE of column if any', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.21 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'datatype', 'ADQL datatype as in section 2.5', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.22 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', '"size"', 'length of variable length datatypes', '', '', '', 'int', -1, 256, 0, 0, 1, 0);
    1.23 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'arraysize', 'length of variable length datatypes', '', '', '', 'int', -1, 256, 0, 0, 1, 0);
    1.24 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'principal', 'a principal column; 1 means true, 0 means false', '', '', '', 'int', -1, 256, 0, 0, 1, 0);
    1.25 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'indexed', 'an indexed column; 1 means true, 0 means false', '', '', '', 'int', -1, 256, 0, 0, 1, 0);
    1.26 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'std', 'a standard column; 1 means true, 0 means false', '', '', '', 'int', -1, 256, 0, 0, 1, 0);
    1.27 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'key_id', 'unique key identifier', '', '', '', 'char', -1, 256, 1, 0, 1, 0);
    1.28 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'from_table', 'fully qualified table name', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.29 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'target_table', 'fully qualified table name', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.30 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'description', 'description of this key', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.31 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'utype', 'utype of this key', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.32 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.key_columns', 'key_id', 'unique key identifier', '', '', '', 'char', -1, 256, 1, 0, 1, 0);
    1.33 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.key_columns', 'from_column', 'key column name in the from_table', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.34 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.key_columns', 'target_column', 'key column name in the target_table', '', '', '', 'char', -1, 256, 0, 0, 1, 0);
    1.35 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.schemas', 'ts_schema_id', 'ts_schema_id', '', '', '', 'int', -1, 256, 0, 0, 1, 0);
    1.36 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'ts_column_id', 'ts_column_id', '', '', '', 'int', -1, 256, 0, 0, 1, 0);
    1.37 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'ts_table_id', 'ts_table_id', '', '', '', 'int', -1, 256, 0, 0, 1, 0);
    1.38 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'ts_key_id', 'ts_key_id', '', '', '', 'int', -1, 256, 0, 0, 1, 0);
    1.39 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.key_columns', 'ts_key_column_id', 'ts_key_column_id', '', '', '', 'int', -1, 256, 0, 0, 1, 0);
    1.40 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.schemas', 'ft_schema_id', 'ft_schema_id', '', '', '', 'int', -1, 256, 0, 0, 0, 0);
    1.41 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'ft_table_id', 'ft_table_id', '', '', '', 'int', -1, 256, 0, 0, 0, 0);
    1.42 -INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'ft_column_id', 'ft_column_id', '', '', '', 'int', -1, 256, 0, 0, 0, 0);
    1.43 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id") VALUES ('TAP_SCHEMA.schemas', 'schema_name', 'schema name, possibly qualified', '', '', '', 'char', -1, -1, 1, 0, 1, 0);
    1.44 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id") VALUES ('TAP_SCHEMA.schemas', 'description', 'brief description of schema', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.45 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.schemas', 'utype', 'UTYPE if schema corresponds to a data model', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.46 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'schema_name', 'the schema name from TAP_SCHEMA.schemas', '', '', '', 'char', -1, -1, 1, 0, 1, 0);
    1.47 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'table_name', 'table name as it should be used in queries', '', '', '', 'char', -1, -1, 1, 0, 1, 0);
    1.48 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'table_type', 'one of: table, view', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.49 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'description', 'brief description of table', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.50 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'utype', 'UTYPE if table corresponds to a data model', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.51 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'table_name', 'table name from TAP_SCHEMA.tables', '', '', '', 'char', -1, -1, 1, 0, 1, 0);
    1.52 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'column_name', 'column name', '', '', '', 'char', -1, -1, 1, 0, 1, 0);
    1.53 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'description', 'brief description of column', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.54 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'unit', 'unit in VO standard format', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.55 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'ucd', 'UCD of column if any', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.56 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'utype', 'UTYPE of column if any', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.57 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'datatype', 'ADQL datatype as in section 2.5', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.58 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', '"size"', 'length of variable length datatypes', '', '', '', 'int', -1, -1, 0, 0, 1, 0);
    1.59 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'arraysize', 'length of variable length datatypes', '', '', '', 'int', -1, -1, 0, 0, 1, 0);
    1.60 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'principal', 'a principal column; 1 means true, 0 means false', '', '', '', 'int', -1, -1, 0, 0, 1, 0);
    1.61 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'indexed', 'an indexed column; 1 means true, 0 means false', '', '', '', 'int', -1, -1, 0, 0, 1, 0);
    1.62 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'std', 'a standard column; 1 means true, 0 means false', '', '', '', 'int', -1, -1, 0, 0, 1, 0);
    1.63 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'key_id', 'unique key identifier', '', '', '', 'char', -1, -1, 1, 0, 1, 0);
    1.64 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'from_table', 'fully qualified table name', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.65 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'target_table', 'fully qualified table name', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.66 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'description', 'description of this key', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.67 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'utype', 'utype of this key', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.68 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.key_columns', 'key_id', 'unique key identifier', '', '', '', 'char', -1, -1, 1, 0, 1, 0);
    1.69 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.key_columns', 'from_column', 'key column name in the from_table', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.70 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.key_columns', 'target_column', 'key column name in the target_table', '', '', '', 'char', -1, -1, 0, 0, 1, 0);
    1.71 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.schemas', 'ts_schema_id', 'ts_schema_id', '', '', '', 'int', -1, -1, 0, 0, 1, 0);
    1.72 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'ts_column_id', 'ts_column_id', '', '', '', 'int', -1, -1, 0, 0, 1, 0);
    1.73 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'ts_table_id', 'ts_table_id', '', '', '', 'int', -1, -1, 0, 0, 1, 0);
    1.74 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.keys', 'ts_key_id', 'ts_key_id', '', '', '', 'int', -1, -1, 0, 0, 1, 0);
    1.75 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.key_columns', 'ts_key_column_id', 'ts_key_column_id', '', '', '', 'int', -1, -1, 0, 0, 1, 0);
    1.76 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.schemas', 'ft_schema_id', 'ft_schema_id', '', '', '', 'int', -1, -1, 0, 0, 0, 0);
    1.77 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.tables', 'ft_table_id', 'ft_table_id', '', '', '', 'int', -1, -1, 0, 0, 0, 0);
    1.78 +INSERT INTO "TAP_SCHEMA"."columns" ("table_name", "column_name", "description", "unit", "ucd", "utype", "datatype", "size", "arraysize", "principal", "indexed", "std", "ft_column_id")  VALUES ('TAP_SCHEMA.columns', 'ft_column_id', 'ft_column_id', '', '', '', 'int', -1, -1, 0, 0, 0, 0);