public Default schema basicGeneral data about an astronomical object main_id Main identifier for an object meta.id;meta.main mango:MangoObject.identifier VARCHAR primary nbref number of references meta.bib;arith.sum INTEGER otype Object type src.class mango:Label.text[CT.vocabulary=https://www.ivoa.net/rdf/uat#classification] VARCHAR ra Right ascension deg pos.eq.ra;meta.main mango:EpochPosition.longitude[CS.spaceSys=ICRS CT.epoch=J2000] DOUBLE primary ra_prec Right ascension precision SMALLINT dec Declination deg pos.eq.dec;meta.main mango:EpochPosition.latitude[CS.spaceSys=ICRS CT.epoch=J2000] DOUBLE primary dec_prec Declination precision SMALLINT coo_err_maj Coordinate error major axis mas phys.angSize.smajAxis;pos.errorEllipse;pos.eq mango:EpochPosition.errors.position/mango:error.PErrorEllipse.semiMajorAxis[CS.spaceSys=ICRS CT.epoch=J2000] REAL coo_err_maj_prec Coordinate error major axis precision SMALLINT coo_err_min Coordinate error minor axis mas phys.angSize.sminAxis;pos.errorEllipse;pos.eq mango:EpochPosition.errors.position/mango:error.PErrorEllipse.semiMinorAxis[CS.spaceSys=ICRS CT.epoch=J2000] REAL coo_err_min_prec Coordinate error minor axis precision SMALLINT coo_err_angle Coordinate error angle deg pos.posAng;pos.errorEllipse;pos.eq mango:EpochPosition.errors.position/mango:error.PErrorEllipse.angle[CS.spaceSys=ICRS CT.epoch=J2000] SMALLINT coo_qual Coordinate quality meta.code.qual;pos.eq CHAR coo_wavelength Wavelength class for the origin of the coordinates (R,I,V,U,X,G) instr.bandpass;pos.eq CHAR coo_bibcode Coordinate reference meta.bib.bibcode;pos.eq CHAR hpx Healpix number at ORDER=10 meta.id BIGINT indexed pmra Proper motion in RA mas.yr-1 pos.pm;pos.eq.ra mango:EpochPosition.pmLongitude[CS.spaceSys=ICRS CT.epoch=J2000] DOUBLE pmra_prec Proper motion in RA precision SMALLINT pmdec Proper motion in DEC mas.yr-1 pos.pm;pos.eq.dec mango:EpochPosition.pmLatitude[CS.spaceSys=ICRS CT.epoch=J2000] DOUBLE pmdec_prec Proper motion in DEC precision SMALLINT pm_err_maj Proper motion error major axis mas.yr-1 phys.angSize.smajAxis;pos.errorEllipse;pos.pm mango:EpochPosition.errors.properMotion/mango:error.PErrorEllipse.semiMajorAxis[CS.spaceSys=ICRS CT.epoch=J2000] REAL pm_err_maj_prec Proper motion error major axis precision SMALLINT pm_err_min Proper motion error minor axis mas.yr-1 phys.angSize.sminAxis;pos.errorEllipse;pos.pm mango:EpochPosition.errors.properMotion/mango:error.PErrorEllipse.semiMinorAxis[CS.spaceSys=ICRS CT.epoch=J2000] REAL pm_err_min_prec Proper motion error minor axis precision SMALLINT pm_err_angle Proper motion error angle deg pos.posAng;pos.errorEllipse;pos.pm mango:EpochPosition.errors.properMotion/mango:error.PErrorEllipse.angle[CS.spaceSys=ICRS CT.epoch=J2000] SMALLINT pm_qual Proper motion quality meta.code.qual;pos.pm CHAR pm_bibcode Proper motion reference meta.bib.bibcode;pos.pm CHAR plx_value Parallax mas pos.parallax.trig mango:EpochPosition.parallax[CS.spaceSys=ICRS CT.epoch=J2000] DOUBLE plx_prec Parallax precision SMALLINT plx_err Parallax error mas stat.error;pos.parallax.trig REAL plx_err_prec Parallax error precision SMALLINT plx_qual Parallax quality meta.code.qual;pos.parallax.trig CHAR plx_bibcode Parallax reference meta.bib.bibcode;pos.parallax.trig CHAR rvz_type Radial velocity / redshift type CHAR rvz_radvel Radial Velocity km.s-1 spect.dopplerVeloc.opt mango:EpochPosition.radialVelocity[CS.spaceSys=ICRS CT.epoch=J2000] DOUBLE rvz_radvel_prec Radial velocity precision SMALLINT rvz_redshift redshift src.redshift DOUBLE rvz_redshift_prec redshift precision SMALLINT rvz_err Radial velocity / redshift error km.s-1 stat.error;spect.dopplerVeloc REAL rvz_err_prec Radial velocity / redshift error precision SMALLINT rvz_nature velocity / redshift nature meta.code;spect.dopplerVeloc CHAR rvz_qual Radial velocity / redshift quality meta.code.qual;spect.dopplerVeloc CHAR rvz_bibcode Radial velocity / redshift reference meta.bib.bibcode;spect.dopplerVeloc CHAR vlsr velocity in Local Standard of Rest reference frame km.s-1 phys.veloc;pos.lsr;stat.mean DOUBLE vlsr_err Error incertainty of the VLSR velocity km.s-1 stat.error;phys.veloc;pos.lsr DOUBLE vlsr_wavelength Wavelength class for the origin of the LSR velocity instr.bandpass;phys.veloc;pos.lsr CHAR vlsr_bibcode Reference for the origin of the LSR velocity meta.bib.bibcode;phys.veloc;pos.lsr CHAR vlsr_min Minimum for the mean value of the LSR velocity km.s-1 phys.veloc;pos.lsr;stat.min REAL vlsr_max Maximum for the mean value of the LSR velocity km.s-1 phys.veloc;pos.lsr;stat.max REAL sp_type MK spectral type src.spType VARCHAR sp_qual Spectral type quality meta.code.qual;src.spType CHAR sp_bibcode spectral type reference meta.bib.bibcode;src.spType CHAR morph_type Morphological type src.morph.type VARCHAR morph_qual Morphological type quality meta.code.qual;src.morph.type CHAR morph_bibcode morphological type reference meta.bib.bibcode;src.morph.type CHAR galdim_majaxis Angular size major axis arcmin phys.angSize.smajAxis REAL galdim_majaxis_prec Angular size major axis precision SMALLINT galdim_minaxis Angular size minor axis arcmin phys.angSize.sminAxis REAL galdim_minaxis_prec Angular size minor axis precision SMALLINT galdim_angle Galaxy ellipse angle deg pos.posAng SMALLINT galdim_qual Galaxy dimension quality meta.code.qual;phys.angSize CHAR galdim_wavelength Wavelength class for the origin of the Galaxy dimension instr.bandpass;phys.angSize CHAR galdim_bibcode Galaxy dimension reference meta.bib.bibcode;phys.angSize CHAR update_date Date of last modification time.processing VARCHAR oid Object internal identifier meta.record BIGINT otype_txt Object type src.class VARCHAR primary rvz_wavelength Wavelength class for the origin of the radial velocity/reshift instr.bandpass;spect.dopplerVeloc.opt CHAR identIdentifiers of an astronomical object id Identifier meta.id VARCHAR oidref Object internal identifier meta.record BIGINT basic oidref oid idsall names concatenated with pipe oidref Object internal identifier meta.record BIGINT ids List of all identifiers concatenated with pipe meta.id VARCHAR basic oidref oid catCatalogues name cat_name Catalogue name meta.id;meta.dataset VARCHAR description Catalogue description UNICODECHAR "size" Number of objects of the Catalogue in SIMBAD meta.id;arith.sum INTEGER fluxMagnitude/Flux information about an astronomical object flux_err_prec flux error precision stat.error;phot.flux SMALLINT flux_prec flux precision phot.flux SMALLINT oidref Object internal identifier meta.record BIGINT filter flux filter name instr.bandpass;instr.filter VARCHAR flux phot.flux REAL system flux system A=AB V=Vega meta.id;phot.flux CHAR flux_err flux error stat.error;phot.mag REAL qual flux quality flag meta.code.qual;phot.flux CHAR bibcode flux reference meta.bib.bibcode;phot.flux CHAR basic oidref oid filter filter filtername allfluxesall flux/magnitudes U,B,V,I,J,H,K,u_,g_,r_,i_,z_ oidref Object internal identifier meta.record BIGINT U U magnitude phot.mag;em.opt.U mango:Brightness.value[CS.photCal=U] DOUBLE B B magnitude phot.mag;em.opt.B mango:Brightness.value[CS.photCal=B] DOUBLE V V magnitude phot.mag;em.opt.V mango:Brightness.value[CS.photCal=V] DOUBLE G G magnitude phot.mag;em.opt mango:Brightness.value[CS.photCal=G] DOUBLE R R magnitude phot.mag;em.opt.R mango:Brightness.value[CS.photCal=R] DOUBLE I I magnitude phot.mag;em.opt.I mango:Brightness.value[CS.photCal=I] DOUBLE J J magnitude phot.mag;em.IR.J mango:Brightness.value[CS.photCal=J] DOUBLE H H magnitude phot.mag;em.IR.H mango:Brightness.value[CS.photCal=H] DOUBLE K K magnitude phot.mag;em.IR.K mango:Brightness.value[CS.photCal=K] DOUBLE F150W JWST NIRCam F150W phot.mag;em.IR.NIR mango:Brightness.value[CS.photCal=F150W] DOUBLE F200W JWST NIRCam F200W phot.mag;em.IR.NIR mango:Brightness.value[CS.photCal=F200W] DOUBLE F444W JWST NIRCam F444W phot.mag;em.IR.NIR mango:Brightness.value[CS.photCal=F444W] DOUBLE u_ u magnitude phot.mag;em.opt.U mango:Brightness.value[CS.photCal=u] DOUBLE g_ g magnitude phot.mag;em.opt.B mango:Brightness.value[CS.photCal=g] DOUBLE r_ r magnitude phot.mag;em.opt.R mango:Brightness.value[CS.photCal=r] DOUBLE z_ z magnitude phot.mag;em.opt.I mango:Brightness.value[CS.photCal=z] DOUBLE i_ i magnitude phot.mag;em.opt.I mango:Brightness.value[CS.photCal=i] DOUBLE basic oidref oid filterDescription of a flux filter description flux filter description meta.note;instr.filter UNICODECHAR unit physical unit name meta.unit VARCHAR filtername flux filter name instr.bandpass;instr.filter VARCHAR otypesList of all object types associated with an object otype_txt Object type src.class UNKNOWN oidref Object internal identifier meta.record BIGINT origin explanation of origin of this type UNKNOWN otype Object type src.class VARCHAR basic oidref oid alltypesall object types concatenated with pipe otypes List of all object types concatenated with pipe src.class VARCHAR oidref Object internal identifier meta.record BIGINT basic oidref oid otypedefall names and definitions for the object types otype Object type src.class VARCHAR primary label Object type, compact label string src.class VARCHAR description Object type, full description string src.class UNICODECHAR comment Additional comment UNICODECHAR is_candidate True if the object type is a candidate (non-confirmed) SMALLINT otype_shortname (DEPRECATED) Object type, short name src.class VARCHAR otype_longname (DEPRECATED) Object type, full description string src.class UNICODECHAR path Otype path in the hierarchical classification VARCHAR basic otype otype otypes otype otype has_refAssociations between astronomical objects and their bibliographic references obj_freq flag meta.number SMALLINT oidbibref Bibcode internal identifier meta.record BIGINT ref_flag flag meta.code.multip SMALLINT ref_raw_id id like it appears in the article meta.id VARCHAR oidref Object internal identifier meta.record BIGINT basic oidref oid ref oidbibref oidbib refBibliographic reference oidbib Bibcode internal identifier meta.record BIGINT bibcode Bibcode meta.bib.bibcode CHAR title Title meta.title UNICODECHAR "year" Publication year time.publiYear SMALLINT journal Abbreviation for the journal meta.bib.journal VARCHAR page page number meta.bib.page INTEGER last_page Last page number meta.bib.page INTEGER volume volume number meta.bib.volume INTEGER abstract (revisited) Abstract of published paper meta.record UNICODECHAR nbobject Number of objects studied in meta.id;arith.sum INTEGER doi DOI designation meta.ref.doi VARCHAR journals journal journal biblioBibliography biblio List of Bibcodes separated with a pipe meta.bib.bibcode VARCHAR oidref Object internal identifier meta.record BIGINT basic oidref oid authorAuthor of a bibliographic reference name Author of a bibliographical reference meta.bib.author VARCHAR oidbibref Bibcode internal identifier meta.record BIGINT pos Position of the author in the bib ref stat.rank SMALLINT ref oidbibref oidbib keywordsList of keywords in a paper keyword Keyword text and link meta.record UNICODECHAR oidbibref Object internal identifier of reference meta.record BIGINT "position" Position of the keyword in the publication meta.record INTEGER ref oidbibref oidbib journalsDescription of all used journals in the database journal Abbreviation for the journal meta.bib.journal VARCHAR name Full name of the journal meta.bib.journal VARCHAR years Range of years of this journal in the database time.publiYear VARCHAR h_linkhierarchy of membership measure child child oid meta.record BIGINT link_bibcode link reference meta.bib.bibcode CHAR membership membership probability percent SMALLINT parent parent oid meta.record BIGINT basic child oid basic parent oid mesDiameterCollection of stellar diameters. bibcode measurement bibcode meta.bib.bibcode CHAR diameter Diameter value phys.angSize DOUBLE diameter_prec Precision (# of decimal positions) associated with the column diameter SMALLINT error Error stat.error DOUBLE error_prec Precision (# of decimal positions) associated with the column error SMALLINT filter filter or wavelength instr.bandpass;instr.filter CHAR method calculation method instr.setup CHAR qual Quality meta.code.qual CHAR unit Unit (mas/km) meta.unit CHAR oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT basic oidref oid mesDistanceCollection of distances (pc, kpc or Mpc) by several means. bibcode measurement bibcode meta.bib.bibcode CHAR dist Distance value pos.distance DOUBLE dist_prec Precision (# of decimal positions) associated with the column dist SMALLINT method distance calculation method instr.setup CHAR minus_err minus error stat.error DOUBLE minus_err_prec Precision (# of decimal positions) associated with the column minus_err SMALLINT plus_err plus error stat.error DOUBLE plus_err_prec Precision (# of decimal positions) associated with the column plus_err SMALLINT qual Quality meta.code.qual CHAR unit Unit (pc,kpc or Mpc) meta.unit CHAR oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT basic oidref oid mesFe_hCollection of metallicity, as well as Teff, logg for stars. oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT teff Effective Temperature unit-degK phys.temperature.effective INTEGER log_g Decimal logarithm of the surface gravity cm/s**2 phys.gravity REAL log_g_prec Precision (# of decimal positions) associated with the column log_g SMALLINT fe_h Metallicity index relative to the Sun phys.abund.Fe REAL fe_h_prec Precision (# of decimal positions) associated with the column fe_h SMALLINT flag Flag on the [Fe/H] value meta.code.error CHAR compstar Designates the comparison star from which the [Fe/H] value was obtained meta.id CHAR catno Star in the Cayrel et al. (1997A&AS..124..299C) compilation meta.id;meta.main CHAR bibcode measurement bibcode meta.bib.bibcode CHAR basic oidref oid mesHerschelThe Herschel observing Log alpha Right Ascension J2000 h:m:s pos.eq.ra;meta.main CHAR delta Declination J2000 d:m:s pos.eq.dec;meta.main CHAR obsid Observation identifier meta.id;meta.main CHAR oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT basic oidref oid mesISOInfrared Space Observatory (ISO) observing log. dec Declination deg pos.eq.dec;meta.main DOUBLE dec_prec Precision (# of decimal positions) associated with the column dec SMALLINT obsid Observation identifier meta.id;meta.main CHAR ra Right ascension deg pos.eq.ra;meta.main DOUBLE ra_prec Precision (# of decimal positions) associated with the column ra SMALLINT oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT basic oidref oid mesIUEInternational Ultraviolet Explorer observing log. abnormcode Abnormality code meta.code.qual CHAR aperture Aperture designation code meta.code;instr.fov CHAR bibcode measurement bibcode meta.bib.bibcode CHAR camid Camera id meta.id;instr CHAR classcode IUE class code src.class SMALLINT comments Comments meta.note CHAR complid Complementary Identifier meta.id CHAR dispcode Dispersion code meta.code CHAR expqualcode Exposure quality code meta.code.class CHAR exptime Effective exposure time sec time.expo INTEGER fescount FES count phot.count;em.opt INTEGER fesmode FES mode meta.code CHAR flag Flag meta.code CHAR image Image number meta.id;obs.image INTEGER name Homogenized Name meta.id;meta.main CHAR obsdate Observation date time.epoch CHAR obstime Observation time time.epoch CHAR progid Observing Program Identification meta.id;obs CHAR station Station (V=Vilspa/G=Goddard) meta.code;instr.tel CHAR oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT basic oidref oid mesOtypeOther object types associated with an object with origins oidref Object internal identifier meta.record BIGINT indexed primary otype Object type src.class VARCHAR indexed primary comments explanation of origin of this type UNICODECHAR bibcode bibcode reference meta.bib.bibcode VARCHAR indexed basic oidref oid mesPLXCollection of trigonometric parallaxes. bibcode measurement bibcode meta.bib.bibcode CHAR obscode Observatory code meta.id;instr.obsty CHAR plx Parallax mas pos.parallax.trig REAL plx_err sigma{plx} mas stat.error REAL plx_prec Precision (# of decimal positions) associated with the column plx SMALLINT oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT basic oidref oid mesPMCollection of proper motions. bibcode measurement bibcode meta.bib.bibcode CHAR coosystem coordinates system designation pos.frame CHAR pmde Proper motion DEC. mas.yr-1 pos.pm;pos.eq.dec REAL pmde_err sigma{pm-de} mas.yr-1 stat.error REAL pmde_err_prec Precision (# of decimal positions) associated with the column pmde_err SMALLINT pmde_prec Precision (# of decimal positions) associated with the column pmde SMALLINT pmra Proper motion R.A. mas.yr-1 pos.pm;pos.eq.ra REAL pmra_err sigma{pm-ra} mas.yr-1 stat.error REAL pmra_err_prec Precision (# of decimal positions) associated with the column pmra_err SMALLINT pmra_prec Precision (# of decimal positions) associated with the column pmra SMALLINT oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT basic oidref oid mesRotStellar Rotational Velocities. bibcode measurement bibcode meta.bib.bibcode CHAR nbmes Number of measurements meta.number SMALLINT qual Quality meta.code.qual CHAR upvsini Upper value of Vsini meta.code CHAR vsini V sini km.s-1 phys.veloc.rotat REAL vsini_err error stat.error REAL vsini_err_prec Precision (# of decimal positions) associated with the column vsini_err SMALLINT vsini_prec Precision (# of decimal positions) associated with the column vsini SMALLINT oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT basic oidref oid mesSpTCollection of spectral types. bibcode measurement bibcode meta.bib.bibcode CHAR dispsystem dispersive system meta.id;instr CHAR mssnote mss notes meta.note CHAR sptype MK/MSS spectral type src.spType CHAR oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT basic oidref oid mesVarCollection of stellar variability types and periods. oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT vartyp Type of variability meta.code;src.var CHAR lowvmax Upper limit flag for Vmax meta.code.error CHAR vmax Maximum of brightness mag phot.mag REAL vmax_prec Precision (# of decimal positions) associated with the column vmax SMALLINT r_vmax Uncertainty flag meta.code.error CHAR magtyp Magnitude type meta.id;phot CHAR uppvmin Lower limit flag for Vmin meta.code CHAR vmin Minimum of brightness mag phot.mag REAL vmin_prec Precision (# of decimal positions) associated with the column vmin SMALLINT r_vmin Uncertainty flag for Vmin meta.code.error CHAR upperiod Lower limit flag for the period meta.code CHAR period Period day time.period DOUBLE period_prec Precision (# of decimal positions) associated with the column period SMALLINT r_period Uncertainty flag on period (:) meta.code.error CHAR epoch Epoch of maximum or minimum day time.epoch DOUBLE epoch_prec Precision (# of decimal positions) associated with the column epoch SMALLINT r_epoch Uncertainty on epoch (:) meta.code.error CHAR raisingtime Raising time for all other variable types time.interval REAL raisingtime_prec Precision (# of decimal positions) associated with the column raisingTime SMALLINT r_raisingtime Uncertainty flag on raising time meta.code.error CHAR bibcode measurement bibcode meta.bib.bibcode CHAR basic oidref oid mesVelocitiesCollection of HRV, Vlsr, cz and redshifts. bibcode measurement bibcode meta.bib.bibcode CHAR d 'D' if the resolution is a conversion from the dispersion meta.code CHAR meanerror sigma(Value) stat.error REAL meanerror_prec Precision (# of decimal positions) associated with the column meanError SMALLINT nature nature of the measurement meta.code;spect.dopplerVeloc CHAR nbmes Number of measurements meta.number SMALLINT obsdate Observation date time.epoch DOUBLE obsdate_prec Precision (# of decimal positions) associated with the column obsdate SMALLINT origin Origin of the radial velocity meta.note CHAR qual Quality meta.code.qual CHAR quality Quality meta.code.qual CHAR remark colon is uncertain question mark is questionable meta.note CHAR remarks Remarks meta.note CHAR resolution Resolution spect.resolution INTEGER veltype velocity type (v, z or cz) meta.code;spect.dopplerVeloc CHAR velvalue Velocity spect.dopplerVeloc DOUBLE velvalue_prec Precision (# of decimal positions) associated with the column velValue SMALLINT wdomain Wavelength domain (Rad,mm,IR,Opt,UV,XRay,Gam) em.wl.central;spect.dopplerVeloc CHAR oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT basic oidref oid mesXmmXMM observing log. obsid Observation identifier meta.id;meta.main CHAR oidref Object internal identifier meta.record BIGINT mespos Position of a measurement in a list of measurements stat.rank SMALLINT basic oidref oid TAP_SCHEMA Set of tables listing and describing the schemas, tables and columns published in this TAP service. TAP_SCHEMA.schemasList of schemas published in this TAP service. schema_name schema name, possibly qualified VARCHAR indexed primary description brief description of schema VARCHAR utype UTYPE if schema corresponds to a data model VARCHAR TAP_SCHEMA.tablesList of tables published in this TAP service. table_index this index is used to recommend table ordering for clients INTEGER schema_name the schema name from TAP_SCHEMA.schemas VARCHAR indexed primary table_name table name as it should be used in queries VARCHAR indexed primary table_type one of: table, view VARCHAR description brief description of table VARCHAR utype UTYPE if table corresponds to a data model VARCHAR TAP_SCHEMA.columnsList of columns of all tables listed in TAP_SCHEMA.TABLES and published in this TAP service. column_index this index is used to recommend column ordering for clients INTEGER table_name table name from TAP_SCHEMA.tables VARCHAR indexed primary column_name column name VARCHAR indexed primary datatype ADQL datatype as in section 2.5 VARCHAR arraysize length of variable length datatypes INTEGER "size" length of variable length datatypes INTEGER description brief description of column VARCHAR utype UTYPE of column if any VARCHAR unit unit in VO standard format VARCHAR ucd UCD of column if any VARCHAR indexed an indexed column; 1 means true, 0 means false INTEGER principal a principal column; 1 means true, 0 means false INTEGER std a standard column; 1 means true, 0 means false INTEGER TAP_SCHEMA.keysList 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. key_id unique key identifier VARCHAR indexed primary from_table fully qualified table name VARCHAR target_table fully qualified table name VARCHAR description description of this key VARCHAR utype utype of this key VARCHAR TAP_SCHEMA.key_columnsList 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. key_id unique key identifier VARCHAR indexed primary from_column key column name in the from_table VARCHAR target_column key column name in the target_table VARCHAR