"> "> ."> ]>

˙˙

-- last modification date of the UML model &cr; GO COMMIT

UNKNOWN TAP metadata mode Model = -- Generating TAP-tableset metadata-like VOTables for model and DB vendor . Opening file

The unique, primary key column on this table. This column stores the name of the object type from the data model stored in the row. This column is a foreign key pointing to the containing object in

&cr; This column is a foreign key pointing to the referenced object in

Model = -- Generating TAP-tableset metadata-like VOTables for model and DB vendor . Opening file

TAP_SCHEMA The schema containing the TAP metadata tables. TAP_SCHEMA TAP_SCHEMA.schemas BASE_TABLE The TAP metadata table containing all schemas. TAP_SCHEMA TAP_SCHEMA.tables BASE_TABLE The TAP metadata table containing all tables. TAP_SCHEMA TAP_SCHEMA.columns BASE_TABLE The TAP metadata table containing all columns.

The unique, primary key column on this table.

TBD

BIGINT

This column stores the name of the object type from the data model stored in the row.

TBD

VARCHAR

This column is a foreign key pointing to the containing object in

TBD

BIGINT

TBD

&cr; [This column is a foreign key pointing to the referenced object in

TBD

long

Model = -- Generating TAP-tap_schema like metadata for model and DB vendor . Opening file

&cr;&cr;

Opening file

-- TAP_SCHEMA definition

&cr;&cr; -- tables and column inserts per objecttype&cr;&cr;

DROP TABLE TAP_SCHEMA.key_columns; DROP TABLE TAP_SCHEMA.keys; DROP TABLE TAP_SCHEMA.columns; DROP TABLE TAP_SCHEMA.tables; DROP TABLE TAP_SCHEMA.schemas; DROP SCHEMA TAP_SCHEMA;

BIGINT IDENTITY NOT NULL SERIAL8 NUMERIC(18) CREATE SCHEMA TAP_SCHEMA;

CREATE TABLE TAP_SCHEMA.schemas ( schema_name varchar(128) not null, description

, utype varchar(128) ); CREATE TABLE TAP_SCHEMA.tables ( schema_name varchar(128) not null, table_name varchar(128) not null, table_type varchar(16), description

, utype varchar(128) ); CREATE TABLE TAP_SCHEMA.columns ( id

, column_name varchar(128) not null, table_name varchar(128) not null, description

, unit varchar(64), ucd varchar(64), utype varchar(128), datatype varchar(64), size varchar(16), "primary" char(1), -- assume T or F indexed char(1), -- assume T or F std char(1), -- assume T or F rank integer ); CREATE TABLE TAP_SCHEMA.keys ( key_id varchar(128) not null, from_table varchar(128) not null, target_table varchar(128) not null, utype varchar(128), description

); CREATE TABLE TAP_SCHEMA.key_columns ( id

, key_id varchar(128) not null, from_column varchar(128) not null, target_column varchar(128) not null );

INSERT INTO TAP_SCHEMA.schemas (schema_name,description, utype) VALUES('TAP_SCHEMA','the schema containing the TAP metadata tables',null); INSERT INTO TAP_SCHEMA.schemas (schema_name,description, utype) VALUES('

','the schema containing the data model tables and views metadata tables',null); INSERT INTO TAP_SCHEMA.tables (schema_name,table_name,table_type,description,utype)VALUES('TAP_SCHEMA','TAP_SCHEMA.schemas','base_table','the table storing metadata about the different schemas in this TAP service',null); INSERT INTO TAP_SCHEMA.tables (schema_name,table_name,table_type,description,utype)VALUES('TAP_SCHEMA','TAP_SCHEMA.tables','base_table','the table storing metadata about the tables in this TAP service',null); INSERT INTO TAP_SCHEMA.tables (schema_name,table_name,table_type,description,utype)VALUES('TAP_SCHEMA','TAP_SCHEMA.columns','base_table','the table storing metadata about the columns in this TAP service',null); INSERT INTO TAP_SCHEMA.tables (schema_name,table_name,table_type,description,utype)VALUES('TAP_SCHEMA','TAP_SCHEMA.keys','base_table','the table storing metadata about the foreign keys in this TAP service',null); INSERT INTO TAP_SCHEMA.tables (schema_name,table_name,table_type,description,utype)VALUES('TAP_SCHEMA','TAP_SCHEMA.key_columns','base_table','the table storing metadata about the foreign key columns in this TAP service',null);

schema_name

TAP_SCHEMA.schemas

This column stores the name of the schema

VARCHAR

description

TAP_SCHEMA.schemas

This column stores the description of the schema

VARCHAR

utype

TAP_SCHEMA.schemas

This column stores the utype of the schema

VARCHAR

schema_name

TAP_SCHEMA.tables

This column stores the name of the schema the table represented by this row belongs to.

VARCHAR

table_name

TAP_SCHEMA.tables

This column stores the name of the table represented by the row.

VARCHAR

table_type

TAP_SCHEMA.tables

This column stores the type of the table represented by the row.

VARCHAR

description

TAP_SCHEMA.tables

This column stores the description of the table represented by the row.

VARCHAR

utype

TAP_SCHEMA.tables

This column stores the Utype of the table represented by the row.

VARCHAR

column_name

TAP_SCHEMA.columns

This column stores the name of the column represented by this row.

VARCHAR

table_name

TAP_SCHEMA.columns

This column stores the fully qualified name of the table the column represented by this row belongs to.

VARCHAR

description

TAP_SCHEMA.columns

This column stores the description of the column represented by this row.

VARCHAR

unit

TAP_SCHEMA.columns

This column stores the unit of the column represented by this row.

CLOB

ucd

TAP_SCHEMA.columns

This column stores the UCD of the column represented by this row.

VARCHAR

utype

TAP_SCHEMA.columns

This column stores the description of the column represented by this row.

VARCHAR

datatype

TAP_SCHEMA.columns

This column stores the datatype of the column represented by this row.

VARCHAR

size

TAP_SCHEMA.columns

This column stores the size of the column represented by this row.

INTEGER

primary

TAP_SCHEMA.columns

This column stores whether the column represented by this row is primary.

VARCHAR

indexed

TAP_SCHEMA.columns

This column stores whether the column represented by this row is the first column in an index.

VARCHAR

std

TAP_SCHEMA.columns

This column stores whether the column represented by this row is standard.

VARCHAR

rank

TAP_SCHEMA.columns

This column stores the rank of the column represented by this row.

INTEGER

key_id

TAP_SCHEMA.keys

This column stores the id of the foreign key represented by this row belongs to.

VARCHAR

from_table

TAP_SCHEMA.keys

This column stores the name of the table from which the foreign key points to the target table.

VARCHAR

target_table

TAP_SCHEMA.keys

This column stores the name of the table that is the target of this foreign key.

VARCHAR

utype

TAP_SCHEMA.keys

This column stores the Utype of the foreign key represented by the row.

VARCHAR

description

TAP_SCHEMA.keys

This column stores the description of the table represented by the row.

CLOB

key_id

TAP_SCHEMA.key_columns

This column stores the id of the foreign key in keys to which this key_columns belongs to.

VARCHAR

from_column

TAP_SCHEMA.key_columns

This column stores the name of a column that is doing the pointing.

VARCHAR

target_column

TAP_SCHEMA.key_columns

This column stores the name of the target column.

VARCHAR

INSERT INTO TAP_SCHEMA.tables(schema_name, table_name,table_type,description,utype) values( '

' , '

' , 'view' , '' , '' );

The unique, primary key column on this table.

TBD

BIGINT

This column stores the name of the object type from the data model stored in the row.

TBD

VARCHAR

This column is a foreign key pointing to the containing object in

TBD

BIGINT

TBD

&cr;

TBD

long

INSERT INTO TAP_SCHEMA.Columns(column_name,table_name,description,unit,ucd,utype,datatype,size,"primary",indexed,std,rank) values( '' , '

' , '' , null'' , null'' , null'' , '' , '' , '' , '' , '' , '');&cr;

INSERT INTO TAP_SCHEMA.keys(key_id,from_table, target_table,utype,description)values( '' , '

' , '

' , null'' , '');&cr;

INSERT INTO TAP_SCHEMA.key_columns(key_id,from_column, target_column)values( '' , '' , '');&cr; Model = -- Generating VODataService like metadata for model . Opening file

http://www.ivoa.net/xml/RegistryInterface/v1.0 http://www.ivoa.net/xml/VOResource/v1.0 http://www.ivoa.net/xml/VODataService/v1.1 http://www.w3.org/2001/XMLSchema-instance http://www.ivoa.net/xml/VOResource/v1.0 http://www.ivoa.net/xml/VOResource/v1.0 http://www.ivoa.net/xml/VODataService/v1.1 http://www.ivoa.net/xml/VODataService/v1.1 http://www.ivoa.net/xml/STC/stc-v1.30.xsd http://www.ivoa.net/xml/STC/stc-v1.30.xsd

TBD TBD TBD TBD

TBD TBD TBD

TBD

The unique, primary key column on this table.

This column stores the name of the object type from the data model stored in the row.

This column is a foreign key pointing to the containing object in

containerId

BOOLEAN SMALLINT INTEGER BIGINT REAL DOUBLE DOUBLE TIMESTAMP VARCHAR

boolean short integer long float double double datetime char