<?xml-stylesheet href='/static/xsl/oai.xsl' type='text/xsl'?>
<ri:Resource created="2010-07-26T13:39:00Z" status="active" updated="2024-02-06T08:59:18Z" version="1.2" xmlns:ri="http://www.ivoa.net/xml/RegistryInterface/v1.0" xmlns:vs="http://www.ivoa.net/xml/VODataService/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ivoa.net/xml/VODataService/v1.1 http://vo.ari.uni-heidelberg.de/docs/schemata/VODataService.xsd" xsi:type="vs:CatalogResource"><title>GloTS, the Global TAP Schema</title><identifier>ivo://org.gavo.dc/glots/q/createTables</identifier><curation><publisher>The GAVO DC team</publisher><creator><name>GAVO Data Centre</name><logo>http://vo.ari.uni-heidelberg.de/docs/GavoTiny.png</logo></creator><date role="Updated">2024-08-08T11:40:49Z</date><contact><name>GAVO Data Centre Team</name><address>Mönchhofstrasse 12-14, D-69120 Heidelberg</address><email>gavo@ari.uni-heidelberg.de</email><telephone>+49 6221 54 1837</telephone></contact></curation><content><subject>virtual-observatories</subject><subject>astronomy-databases</subject><description>
The global TAP schema collects information on
tables and columns from known TAP servers.  This facilitates locating
queriable data by physics (via UCD) or keywords (via description).

Note that this shouldn't really be necessary as all information
present here should be exposed through Registry records.  However,
in reality data providers currently are much more liable to give
column metadata in their tap_schema than in their Registry records.
Hence, for the time being, we maintain this service by harvesting
tap_schemas about monthly.</description><referenceURL>http://dc.g-vo.org/browse/glots/q</referenceURL><relationship><relationshipType>IsServedBy</relationshipType><relatedResource ivo-id="ivo://org.gavo.dc/tap">GAVO Data Center TAP service</relatedResource></relationship></content><capability standardID="ivo://ivoa.net/std/TAP#aux"><interface role="std" version="1.1" xsi:type="vs:ParamHTTP"><accessURL use="full">http://dc.g-vo.org/tap</accessURL><mirrorURL>https://dc.g-vo.org/tap</mirrorURL></interface></capability><tableset><schema><name>glots</name><title>GloTS, the Global TAP Schema</title><description>
The global TAP schema collects information on
tables and columns from known TAP servers.  This facilitates locating
queriable data by physics (via UCD) or keywords (via description).

Note that this shouldn't really be necessary as all information
present here should be exposed through Registry records.  However,
in reality data providers currently are much more liable to give
column metadata in their tap_schema than in their Registry records.
Hence, for the time being, we maintain this service by harvesting
tap_schemas about monthly.</description><table><name>glots.services</name><description>A table of TAP services harvested from the registry (and some
spoon-fed).</description><column><name>ivoid</name><description>IVOA identifier of providing service</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>indexed</flag><flag>primary</flag></column><column><name>accessurl</name><description>Base URL of TAP endpoint</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>nullable</flag></column><column><name>nextharvest</name><description>Next scheduled harvest of data</description><dataType arraysize="19" extendedType="timestamp" xsi:type="vs:VOTableType">char</dataType><flag>nullable</flag></column><column><name>harvestinterval</name><description>Approximate interval of harvest</description><unit>d</unit><dataType xsi:type="vs:VOTableType">int</dataType><flag>nullable</flag></column><column><name>lastsuccess</name><description>Last successful harvest of this service</description><dataType arraysize="19" extendedType="timestamp" xsi:type="vs:VOTableType">char</dataType><flag>nullable</flag></column></table><table><name>glots.columns</name><description>A table of columns within the tables listed in glots.tables.</description><column><name>ivoid</name><description>IVOA identifier of providing service</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>indexed</flag><flag>primary</flag></column><column><name>table_name</name><description>Fully qualified table name</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>indexed</flag><flag>primary</flag></column><column><name>column_name</name><description>Column name</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>indexed</flag><flag>primary</flag></column><column><name>description</name><description>Brief description of column</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>indexed</flag><flag>nullable</flag></column><column><name>unit</name><description>Unit in VO standard format</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>nullable</flag></column><column><name>ucd</name><description>UCD of column (some services still have 1.0 UCDs).</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>indexed</flag><flag>nullable</flag></column><column><name>utype</name><description>Utype of column</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>nullable</flag></column><column><name>datatype</name><description>ADQL datatype</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>nullable</flag></column><column><name>"size"</name><description>Length of variable length datatypes</description><dataType xsi:type="vs:VOTableType">int</dataType><flag>nullable</flag></column><column><name>principal</name><description>Is column principal?</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>nullable</flag></column><column><name>indexed</name><description>Is there an index on this column?</description><dataType xsi:type="vs:VOTableType">int</dataType><flag>nullable</flag></column><column><name>std</name><description>Is this a standard column?</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>nullable</flag></column><foreignKey><targetTable>glots.tables</targetTable><fkColumn><fromColumn>ivoid</fromColumn><targetColumn>ivoid</targetColumn></fkColumn><fkColumn><fromColumn>table_name</fromColumn><targetColumn>table_name</targetColumn></fkColumn></foreignKey></table><table><name>glots.tables</name><description>A table of tables accesible through the TAP services known to
glots.services.</description><column><name>ivoid</name><description>IVOA identifier of providing service</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>indexed</flag><flag>primary</flag></column><column><name>table_name</name><description>Fully qualified table name</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>indexed</flag><flag>primary</flag></column><column><name>table_desc</name><description>Brief description of the table</description><dataType arraysize="*" xsi:type="vs:VOTableType">unicodeChar</dataType><flag>indexed</flag><flag>nullable</flag></column><column><name>utype</name><description>utype if the table corresponds to a data model</description><dataType arraysize="*" xsi:type="vs:VOTableType">char</dataType><flag>nullable</flag></column><foreignKey><targetTable>glots.services</targetTable><fkColumn><fromColumn>ivoid</fromColumn><targetColumn>ivoid</targetColumn></fkColumn></foreignKey></table></schema></tableset></ri:Resource>