ArVO Byurakan TAP serviceArVO Byu TAPivo://byu.arvo/tapThe staff at the ArVO Data CenterAreg Mickaelianhttp://arvo-registry.sci.am/favicon.png2020-02-21T09:33:52Areg Mickaelian
Byurakan Astrophysical Observatory, Byurakan 0213, Armenia
aregmick@yahoo.com<+37491195914Virtual observatoryCatalogsADQLThe ArVO Byurakan's TAP end point. The Table Access Protocol (TAP) lets you execute queries against our database tables, inspect various metadata, and upload your own data. It is thus the VO's premier way to access public data holdings. Tables exposed through this endpoint include: columns, groups, key_columns, keys, schemas, tables from the tap_schema schema, main from the dfbsplates schema, spectra, ssa from the dfbsspec schema, obscore from the ivoa schema.http://arvo-registry.sci.am/__system__/tap/run/infoservice-forDigitized First Byurakan Survey (DFBS) Extracted Spectrahttp://arvo-registry.sci.am/tapObscore-1.1ADQL2.12.0The Astronomical Data Query Language is the standard IVOA dialect of SQL; it contains a very general SELECT statement as well as some extensions for spherical geometry and higher mathematics.
gavo_simbadpoint(identifier TEXT) -> POINT
gavo_simbadpoint queries simbad for an identifier and returns the corresponding point. Note that identifier can only be a literal, i.e., as simple string rather than a column name. This is because our database cannot query simbad, and we probably wouldn't want to fire off millions of simbad queries anyway; use simbad's own TAP service for this kind of applications.
ivo_interval_has(val NUMERIC, iv INTERVAL) -> INTEGER
The function returns 1 if the interval iv contains val, 0 otherwise. The lower limit is always included in iv, behaviour on the upper limit is column-specific.
gavo_getauthority(ivoid TEXT) -> TEXT
returns the authority part of an ivoid (or, more generally a URI). So, ivo://org.gavo.dc/foo/bar#baz becomes org.gavo.dc. The behaviour for anything that's not a full URI is undefined.
gavo_match(pattern TEXT, string TEXT) -> INTEGER
gavo_match returns 1 if the POSIX regular expression pattern matches anything in string, 0 otherwise.
ivo_healpix_center(hpxOrder INTEGER, hpxIndex BIGINT) -> POINT
returns a POINT corresponding to the center of the healpix with the given index at the given order.
ivo_string_agg(expression TEXT, delimiter TEXT) -> TEXT
An aggregate function returning all values of expression within a GROUP contcatenated with delimiter
ivo_apply_pm(ra DOUBLE PRECISION, dec DOUBLE PRECISION, pmra DOUBLE PRECISION, pmde DOUBLE PRECISON, epdist DOUBLE PRECISION) -> POINT
Returns a POINT (in the UNDEFINED reference frame) for the position an object at ra/dec with proper motion pmra/pmde has after epdist years. positions must be in degrees, PMs in should be in julian years (i.e., proper motions are expected in degrees/year). pmra is assumed to contain cos(delta). NOTE: This currently is a crappy approximation that does *not* go through the tangential plane. If you use it, let the operators know so we replace it with something real.
gavo_to_jd(d TIMESTAMP) -> DOUBLE PRECISION
The function converts a postgres timestamp to julian date. This is naive; no corrections for timezones, let alone time scales or the like are done; you can thus not expect this to be good to second-precision unless you are careful in the construction of the timestamp.
ivo_interval_overlaps(l1 NUMERIC, h1 NUMERIC, l2 NUMERIC, h2 NUMERIC) -> INTEGER
The function returns 1 if the interval [l1...h1] overlaps with the interval [l2...h2]. For the purposes of this function, the case l1=h2 or l2=h1 is treated as overlap. The function returns 0 for non-overlapping intervals.
gavo_transform(from_sys TEXT, to_sys TEXT, geo GEOMETRY) -> GEOMETRY
The function transforms ADQL geometries between various reference systems. geo can be a POINT, a CIRCLE, or a POLYGON, and the function will return a geometry of the same type. In the current implementation, from_sys and to_sys must be literal strings (i.e., they cannot be computed through expressions or be taken from database columns). All transforms are just simple rotations, which is only a rough approximation to the actual relationships between reference systems (in particular between FK4 and ICRS-based ones). Not that, in particular, the epoch is not changed (i.e., no proper motions are applied). We currently support the following reference frames: ICRS, FK5 (which is trested as ICRS), FK4 (for B1950. without epoch-dependent corrections), GALACTIC. Reference frame names are case-sensitive.
ivo_healpix_index(order INTEGER, ra DOUBLE PRECISION, dec DOUBLE PRECISION) -> BIGINT
Returns the index of the (nest) healpix with order containing the spherical point (ra, dec). An alternative, 2-argument form ivo_healpix_index(order INTEGER, p POINT) -> BIGINT is also available.
ivo_hashlist_has(hashlist TEXT, item TEXT) -> INTEGER
The function takes two strings; the first is a list of words not containing the hash sign (#), concatenated by hash signs, the second is a word not containing the hash sign. It returns 1 if, compared case-insensitively, the second argument is in the list of words coded in the first argument. The behaviour in case the the second argument contains a hash sign is unspecified.
gavo_histogram(val REAL, lower REAL, upper REAL, nbins INTEGER) -> INTEGER[]
The aggregate function returns a histogram of val with nbins+2 elements. Assuming 0-based arrays, result[0] contains the number of underflows (i.e., val<lower), result[nbins+1] the number of overflows. Elements 1..nbins are the counts in nbins bins of width (upper-lower)/nbins. Clients will have to convert back to physical units using some external communication, there currently is no (meta-) data as lower and upper in the TAP response.
gavo_to_mjd(d TIMESTAMP) -> DOUBLE PRECISION
The function converts a postgres timestamp to modified julian date. This is naive; no corrections for timezones, let alone time scales or the like are done; you can thus not expect this to be good to second-precision unless you are careful in the construction of the timestamp.
ivo_nocasematch(value TEXT, pattern TEXT) -> INTEGER
ivo_nocasematch returns 1 if pattern matches value, 0 otherwise. pattern is defined as for the SQL LIKE operator, but the match is performed case-insensitively. This function in effect provides a surrogate for the ILIKE SQL operator that is missing from ADQL. On this site, this is actually implemented using python's and SQL's LOWER, so for everything except ASCII, your milage will vary.
ivo_hasword(haystack TEXT, needle TEXT) -> INTEGER
gavo_hasword returns 1 if needle shows up in haystack, 0 otherwise. This is for "google-like"-searches in text-like fields. In word, you can actually employ a fairly complex query language; see http://www.postgresql.org/docs/8.3/static/textsearch.html for details.
gavo_ipix(long REAL, lat REAL) -> BIGINT
gavo_ipix returns the q3c ipix for a long/lat pair (it simply wraps the 13c_ang2ipix function). This is probably only relevant when you play tricks with indices or PPMXL ids.
BOX
POINT
CIRCLE
POLYGON
REGION
CENTROID
COORD1
COORD2
DISTANCE
CONTAINS
INTERSECTS
AREA
LOWER
ILIKE
OFFSET
CAST
IN_UNIT
WITH
TABLESAMPLE
Written after a table reference, TABLESAMPLE(10) will make the database only use 10% of the rows; these are `somewhat random' in that the system will use random blocks. This should be good enough when just testing queries (and much better than using TOP n).
UNION
EXCEPT
INTERSECT
text/xmlapplication/x-votable+xml;version=1.4vodmltext/htmlhtmlapplication/x-votable+xml;serialization=binary2votable/b2application/geo-jsongeojsonapplication/fitsfitstext/csvtext/csv;header=presentcsvapplication/x-votable+xml;serialization=tabledatavotable/tdapplication/jsonjsonapplication/x-votable+xmlvotabletext/plaintext/tab-separated-valuestsv1728003600200002000000020000000http://arvo-registry.sci.am/__system__/tap/run/availabilityhttp://arvo-registry.sci.am/__system__/tap/run/capabilitieshttp://arvo-registry.sci.am/__system__/tap/run/tableMetadatadfbsplatesDigitized First Byurakan Survey (DFBS) Plate Scans The First Byurakan Survey (FBS) is the largest and the first systematic objective prism survey of the extragalactic sky. It covers 17,000 sq.deg. in the Northern sky together with a high galactic latitudes region in the Southern sky. This service serves the scanned objective prism images and offers SODA-based cutouts.dfbsplates.main The First Byurakan Survey (FBS) is the largest and the first systematic objective prism survey of the extragalactic sky. It covers 17,000 sq.deg. in the Northern sky together with a high galactic latitudes region in the Southern sky. This service serves the scanned objective prism images and offers SODA-based cutouts.accrefAccess key for the dataAccess.ReferencecharindexednullableownerOwner of the datacharnullableembargoDate the data will become/became publicacharnullablemimeMIME type of the file servedmeta.code.mimeAccess.FormatcharnullableaccsizeSize of the data in bytesbyteVOX:Image_FileSizeAccess.SizelongnullablecenteralphaApproximate center of image, RAdegPOS_EQ_RA_MAINdoublenullablecenterdeltaApproximate center of image, DecdegPOS_EQ_DEC_MAINdoublenullableimagetitleSynthetic name of the imageVOX:Image_TitlecharnullableinstidIdentifier of the originating instrumentINST_IDcharnullabledateobsEpoch at midpoint of observationdVOX:Image_MJDateObsdoublenullablenaxesNumber of axes in dataVOX:Image_NaxesintnullablepixelsizeNumber of pixels along each of the axespixVOX:Image_NaxisintnullablepixelscaleThe pixel scale on each image axisdeg/pixVOX:Image_ScalefloatnullablerefframeCoordinate system reference frameVOX:STC_CoordRefFramecharnullablewcs_equinoxEquinox of the given coordinatesyrVOX:STC_CoordEquinoxfloatnullablewcs_projectionFITS WCS projection typeVOX:WCS_CoordProjectioncharnullablewcs_refpixelWCS reference pixelpixVOX:WCS_CoordRefPixelfloatnullablewcs_refvaluesWorld coordinates at WCS reference pixeldegVOX:WCS_CoordRefValuedoublenullablewcs_cdmatrixFITS WCS CDij matrixdeg/pixVOX:WCS_CDMatrixfloatnullablebandpassidFreeform name of the bandpass usedVOX:BandPass_IDcharnullablebandpassunitUnit of bandpass specifications (always m).VOX:BandPass_UnitcharnullablebandpassrefvalCharacteristic quantity for the bandpass of the imagemVOX:BandPass_RefValuefloatnullablebandpasshiUpper limit of the bandpass (in BandPass_Unit units)mVOX:BandPass_HiLimitfloatnullablebandpassloLower limit of the bandpass (in BandPass_Unit units)mVOX:BandPass_LoLimitfloatnullablepixflagsFlags specifying the processing done (C-original; F-resampled; Z-fluxes valid; X-not resampled; V-for display onlyVOX:Image_PixFlagscharnullablecoverageField covered by the imagedegdoubleindexednullableplateIdentifier (plate number) for the DFBS plate.meta.idcharnullableexptimeExposure time.sfloatnullablepublisher_didDataset identifier assigned by the publisher.meta.ref.uri;meta.curationcharnullable
dfbsspecDigitized First Byurakan Survey (DFBS) Extracted Spectra The First Byurakan Survey (FBS) is the largest and the first systematic objective prism survey of the extragalactic sky. It covers 17,000 sq.deg. in the Northern sky together with a high galactic latitudes region in the Southern sky. The FBS has been carried out by B.E. Markarian, V.A. Lipovetski and J.A. Stepanian in 1965-1980 with the Byurakan Observatory 102/132/213 cm (40"/52"/84") Schmidt telescope using 1.5 deg. prism. Each FBS plate contains low-dispersion spectra of some 15,000-20,000 objects; the whole survey consists of about 20,000,000 objects.dfbsspec.ssaA view providing standard SSA metadata for DBFS metadata in dfbsspec.spectraaccrefAccess key for the datameta.ref.url;meta.datasetssa:Access.ReferencecharindexednullableownerOwner of the datacharnullableembargoDate the data will become/became publicacharnullablemimeMIME type of the file servedmeta.code.mimessa:Access.FormatcharnullableaccsizeSize of the data in bytesbytessa:Access.Sizelongnullablessa_dstitleA compact and descriptive designation of the dataset.meta.title;meta.datasetssa:DataID.Titlecharssa_creatordidDataset identifier assigned by the creatormeta.idssa:DataID.CreatorDIDcharnullablessa_pubdidDataset identifier assigned by the publisherssa:Curation.PublisherDIDcharindexednullablessa_cdateProcessing/Creation datetime;meta.datasetssa:DataID.Datecharnullablessa_pdateDate last published.ssa:Curation.Datecharnullablessa_bandpassBandpass (i.e., rough spectral location) of this dataset; this should be the most appropriate term from the values of VODataService vs:Waveband.instr.bandpassssa:DataID.Bandpasscharnullablessa_cversionCreator assigned version for this dataset (will be incremented when this particular item is changed).meta.version;meta.datasetssa:DataID.Versioncharnullablessa_targnameCommon name of object observed.meta.id;srcssa:Target.Namecharindexedssa_targclassObject class (star, QSO,...; use Simbad object classification http://simbad.u-strasbg.fr/simbad/sim-display?data=otypes if at all possible)src.classssa:Target.Classcharnullablessa_redshiftRedshift of target objectsrc.redshiftssa:Target.Redshiftfloatnullablessa_targetposEquatorial (ICRS) position of the target object.pos.eq;srcssa:Target.pos.spointdoublenullablessa_snrSignal-to-noise ratio estimated for this datasetstat.snrssa:Derived.SNRfloatnullablessa_locationICRS location of aperture centerdegpos.eqstc:AstroCoords.Position2D.Value2doubleindexednullablessa_apertureAngular diameter of aperturedeginstr.fovssa:Char.SpatialAxis.Coverage.Bounds.Extentfloatnullablessa_dateobsMidpoint of exposuredtime.epochssa:Char.TimeAxis.Coverage.Location.Valuedoublenullablessa_timeextExposure durationstime.durationssa:Char.TimeAxis.Coverage.Bounds.Extentfloatnullablessa_specmidMidpoint of region covered in this datasetmem.wl;instr.bandpassssa:Char.SpectralAxis.Coverage.Location.Valuefloatnullablessa_specextWidth of the spectrummem.wl;instr.bandwidthssa:Char.SpectralAxis.Coverage.Bounds.Extentfloatnullablessa_specstartLower value of spectral coordinatemem.wl;stat.minssa:Char.SpectralAxis.Coverage.Bounds.Startfloatnullablessa_specendUpper value of spectral coordinatemem.wl;stat.maxssa:Char.SpectralAxis.Coverage.Bounds.Stopfloatnullablessa_lengthNumber of points in the spectrumssa:Dataset.Lengthintnullablessa_dstypeType of data (spectrum, time series, etc)ssa:Dataset.Typecharnullablessa_publisherPublisher of the datasets included here.ssa:Curation.Publishercharnullablessa_creatorCreator of the datasets included here.ssa:DataID.CreatorunicodeCharnullablessa_collectionA short handle naming the collection this spectrum belongs to.ssa:DataID.Collectioncharnullablessa_instrumentInstrument or code used to produce these datasetsmeta.id;instrssa:DataID.Instrumentcharnullablessa_datasourceMethod of generation for the data (one of survey, pointed, theory, custom, artificial).ssa:DataID.DataSourcecharnullablessa_creationtypeProcess used to produce the data (archival, cutout, filtered, mosaic, projection, spectralExtraction, or catalogExtraction)ssa:DataID.CreationTypecharnullablessa_referenceURL or bibcode of a publication describing this data.ssa:Curation.Referencecharnullablessa_fluxstaterrorStatistical error in fluxstat.error;phot.flux.density;emssa:Char.FluxAxis.Accuracy.StatErrorfloatnullablessa_fluxsyserrorSystematic error in fluxstat.error.sys;phot.flux.density;emssa:Char.FluxAxis.Accuracy.SysErrorfloatnullablessa_fluxcalibType of flux calibration (ABSOLUTE, CALIBRATED, RELATIVE, NORMALIZED, or UNCALIBRATED).ssa:Char.FluxAxis.Calibrationcharnullablessa_binsizeBin size in wavelengthmem.wl;spect.binSizessa:Char.SpectralAxis.Accuracy.BinSizefloatnullablessa_spectstaterrorStatistical error in wavelengthmstat.error;emssa:Char.SpectralAxis.Accuracy.StatErrorfloatnullablessa_spectsyserrorSystematic error in wavelengthmstat.error.sys;emssa:Char.SpectralAxis.Accuracy.SysErrorfloatnullablessa_speccalibType of wavelength calibrationmeta.code.qualssa:Char.SpectralAxis.Calibrationcharnullablessa_specresResolution on the spectral axismspect.resolution;em.wlssa:Char.SpectralAxis.Resolutionfloatnullablessa_regionRough coverage based on location and aperture.doubleindexednullablemagbSource object magnitude in Johnson Bmagphot.mag;em.opt.BfloatnullablemagrSource object magnitude in Johnson Rmagphot.mag;em.opt.RfloatnullableplateNumber of the plate this spectrum was extracted from. Technically, this is a foreign key into dfbs.plates.charnullableraICRS RA of the source of this spectrum.degpos.eq.ra;meta.maindoublenullabledecICRS Dec of the source of this spectrum.degpos.eq.dec;meta.maindoublenullable
dfbsspec.spectraThis table contains basic metadata as well as the spectra from the Digital First Byurakan Survey (DFBS).accrefAccess key for the dataAccess.ReferencecharnullableplateNumber of the plate this spectrum was extracted from. Technically, this is a foreign key into dfbs.plates.charnullablespecidIdentifier of the spectrum built from the plate identifier, a -, and the object position as in objectid.meta.id;meta.maincharnullableraICRS RA of the source of this spectrum.degpos.eq.ra;meta.maindoublenullabledecICRS Dec of the source of this spectrum.degpos.eq.dec;meta.maindoublenullableposThe object position as s pgsphere spoint.pos.eqdoublenullablesp_classQuality indicator: OK of undisturbed spectra of sufficiently bright objects, NL if disturbers are nearby, U for objects unclassifiable because of lack of signal.meta.code.qualcharnullablepx_lengthNumber of points in this spectrumfloatnullablefluxFlux points of the extracted spectrum (arbitrary units)phot.flux.density;em.wlfloatnullablemagbSource object magnitude in Johnson Bmagphot.mag;em.opt.BfloatnullablemagrSource object magnitude in Johnson Rmagphot.mag;em.opt.RfloatnullablesnrEstimated signal-to-noise ratio for this spectrum.stat.snrfloatnullablelam_minMinimal wavelength in this spectrum (the longest wavelength is always 690 nm).mstat.min;em.wlfloatnullablepx_xLocation of the spectrum on the plate scan, x coordinate.pixelpos.cartesian.x;instrfloatnullablepx_yLocation of the spectrum on the plate scan, y coordinate.pixelpos.cartesian.y;instrfloatnullablepos_angPosition angle of the spectrum on the plate, north over east.degpos.posAngfloatnullableepochDate of observation from WFPDB (this probably does not include the time).dtime.epochdoublenullableexptimeExposure time from WFPDB.stime.duration;obs.exposurefloatnullableemulsionEmulsion used in this plate from WFPDB.instr.plate.emulsioncharnullablespectralSpectral points of the extracted spectrum (wavelengths) as an array (that's actually the same for all spectra and only given here as a convenience).mfloatnullablecutout_linkCutout of the image this spectrum was extracted frommeta.ref.urlcharnullable
ivoaDefinition and support code for the ObsCore data model and table.ivoa.obscoreThe IVOA-defined obscore table, containing generic metadata for datasets within this datacenter.dataproduct_typeHigh level scientific classification of the data product, taken from an enumerationmeta.idobscore:obsdataset.dataproducttypecharnullabledataproduct_subtypeData product specific typemeta.idobscore:obsdataset.dataproductsubtypecharnullablecalib_levelAmount of data processing that has been applied to the datameta.code;obs.calibobscore:obsdataset.caliblevelshortobs_collectionName of a data collection (e.g., project name) this data belongs tometa.idobscore:dataid.collectioncharnullableobs_idUnique identifier for an observationmeta.idobscore:DataID.observationIDcharnullableobs_titleFree-from title of the data setmeta.title;obsobscore:dataid.titlecharnullableobs_publisher_didDataset identifier assigned by the publisher.meta.ref.uri;meta.curationobscore:curation.publisherdidcharnullableobs_creator_didDataset identifier assigned by the creator.meta.idobscore:dataid.creatordidcharnullableaccess_urlThe URL at which to obtain the data set.meta.ref.urlobscore:access.referencecharnullableaccess_formatMIME type of the resource at access_urlmeta.code.mimeobscore:access.formatcharnullableaccess_estsizeEstimated size of data productkbytephys.size;meta.fileobscore:access.sizelongnullabletarget_nameObject a targeted observation targetedmeta.id;srcobscore:Target.Namecharnullabletarget_classClass of the target object (star, QSO, ...)src.classobscore:target.classcharnullables_raRA of (center of) observation, ICRSdegpos.eq.raobscore:char.spatialaxis.coverage.location.coord.position2d.value2.c1doublenullables_decDec of (center of) observation, ICRSdegpos.eq.decobscore:char.spatialaxis.coverage.location.coord.position2d.value2.c2doublenullables_fovApproximate spatial extent for the region covered by the observationdegphys.angSize;instr.fovobscore:char.spatialaxis.coverage.bounds.extent.diameterdoublenullables_regionRegion covered by the observation, as a polygonpos.outline;obs.fieldobscore:char.spatialaxis.coverage.support.areacharnullables_resolutionBest spatial resolution within the data setarcsecpos.angResolutionobscore:Char.SpatialAxis.Resolution.refval.valuedoublenullablet_minLower bound of times represented in the data set, as MJDdtime.start;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.starttimedoublenullablet_maxUpper bound of times represented in the data set, as MJDdtime.end;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.stoptimedoublenullablet_exptimeTotal exposure timestime.duration;obs.exposureobscore:char.timeaxis.coverage.support.extentfloatnullablet_resolutionMinimal significant time interval along the time axisstime.resolutionobscore:char.timeaxis.resolution.refval.valuefloatnullableem_minMinimal wavelength represented within the data setmem.wl;stat.minobscore:char.spectralaxis.coverage.bounds.limits.lolimitdoublenullableem_maxMaximal wavelength represented within the data setmem.wl;stat.maxobscore:char.spectralaxis.coverage.bounds.limits.hilimitdoublenullableem_res_powerSpectral resolving power delta lambda/lamdaspect.resolutionobscore:char.spectralaxis.resolution.resolpower.refvaldoublenullableo_ucdUCD for the product's observablemeta.ucdobscore:char.observableaxis.ucdcharnullablepol_statesList of polarization states in the data setmeta.code;phys.polarizationobscore:Char.PolarizationAxis.stateListcharnullablefacility_nameName of the facility at which data was takenmeta.id;instr.telobscore:Provenance.ObsConfig.facility.namecharnullableinstrument_nameName of the instrument that produced the datameta.id;instrobscore:Provenance.ObsConfig.instrument.namecharnullables_xel1Number of elements (typically pixels) along the first spatial axis.meta.numberobscore:Char.SpatialAxis.numBins1longnullables_xel2Number of elements (typically pixels) along the second spatial axis.meta.numberobscore:Char.SpatialAxis.numBins2longnullablet_xelNumber of elements (typically pixels) along the time axis.meta.numberobscore:Char.TimeAxis.numBinslongnullableem_xelNumber of elements (typically pixels) along the spectral axis.meta.numberobscore:Char.SpectralAxis.numBinslongnullablepol_xelNumber of elements (typically pixels) along the polarization axis.meta.numberobscore:Char.PolarizationAxis.numBinslongnullables_pixel_scaleSampling period in world coordinate units along the spatial axisarcsecphys.angSize;instr.pixelobscore:Char.SpatialAxis.Sampling.RefVal.SamplingPerioddoublenullableem_ucdNature of the product's spectral axismeta.ucdobscore:Char.SpectralAxis.ucdcharnullablepreviewURL of a preview (low-resolution, quick-to-retrieve representation) of the data.meta.ref.url;datalink.previewcharnullablesource_tableName of a TAP-queriable table this data originates from. This source table usually provides more information on the the data than what is given in obscore. See the TAP_SCHEMA of the originating TAP server for details.meta.id;meta.tablecharnullable
tap_schema ArVO Byurakan's Table Access Protocol (TAP) service with table metadata.tap_schema.schemasSchemas containing tables available for ADQL querying.schema_nameFully qualified schema namecharindexedprimarydescriptionBrief description of the schemacharnullableutypeutype if schema corresponds to a data modelcharnullableschema_indexSuggested position this schema should take in a sorted list of schemas from this data center.intnullable
tap_schema.tablesTables available for ADQL querying.schema_nameFully qualified schema namecharnullabletable_nameFully qualified table namecharindexedprimarytable_typeOne of: table, viewcharnullabledescriptionBrief description of the tablecharnullableutypeutype if the table corresponds to a data modelcharnullabletable_indexSuggested position this table should take in a sorted list of tables from this data centerintnullablesourcerdId of the originating rd (local information)charnullabletap_schema.schemasschema_nameschema_name
tap_schema.columnsColumns in tables available for ADQL querying.table_nameFully qualified table namecharindexedprimarycolumn_nameColumn namecharindexedprimarydescriptionBrief description of columnunicodeCharnullableunitUnit in VO standard formatcharnullableucdUCD of column if anycharnullableutypeUtype of column if anycharnullabledatatypeADQL datatypecharnullablearraysizeArraysize in VOTable notationcharnullablextypeVOTable extended type information (for special interpretation of data content, e.g., timestamps or points)charnullable"size"Legacy length (ignore if you can).intnullableprincipalIs column principal?intindexedIs there an index on this column?intstdIs this a standard column?intsourcerdId of the originating rd (local information)charnullablecolumn_index1-based index of the column in database order.shortnullabletap_schema.tablestable_nametable_name
tap_schema.keysForeign key relationships between tables available for ADQL querying.key_idUnique key identifiercharindexedprimaryfrom_tableFully qualified table namecharnullabletarget_tableFully qualified table namecharnullabledescriptionDescription of this keycharnullableutypeUtype of this keycharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.tablesfrom_tabletable_nametap_schema.tablestarget_tabletable_name
tap_schema.key_columnsColumns participating in foreign key relationships between tables available for ADQL querying.key_idKey identifier from TAP_SCHEMA.keyscharnullablefrom_columnKey column name in the from tablecharnullabletarget_columnKey column in the target tablecharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.keyskey_idkey_id
tap_schema.groupsColumns that are part of groups within tables available for ADQL querying.table_nameFully qualified table namecharnullablecolumn_nameName of a column belonging to the groupcharnullablecolumn_utypeutype the column withing the groupcharnullablegroup_nameName of the groupcharnullablegroup_utypeutype of the groupcharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.tablestable_nametable_name