Home | Browser | Access | Login | FreeSQL

Glossary of VULCAN attributes
This Glossary alphabetically lists all attributes used in the VULCANv20260525 database(s) held in the ASNIR. If you would like to have more information about the schema tables please use the VULCANv20260525 Schema Browser (other Browser versions).

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

T
Name	Schema Table	Database	Description	Type	Length	Unit	Default Value	Unified Content Descriptor
tableID	ProgrammeTable	VULCANiDR	the unique table ID	int	4			meta.id;meta.main
tableID	RequiredNeighbours	VULCANiDR	the unique identifier for the programme table	int	4			meta.id
tableName	ProgrammeTable	VULCANiDR	the name of the table	varchar	256			meta.id;meta.dataset
teff_gspphot	gaia_source	GAIADR3	Effective temperature from GSP-Phot Aeneas best library using BP/RP spectra	real	4	K		phys.temperature.effective
teff_gspphot_lower	gaia_source	GAIADR3	Lower confidence level (16%) of effective temperature from GSP-Phot Aeneas best library using BP/RP spectra	real	4	K		phys.temperature.effective;stat.min
teff_gspphot_upper	gaia_source	GAIADR3	Upper confidence level (84%) of effective temperature from GSP-Phot Aeneas best library using BP/RP spectra	real	4	K		phys.temperature.effective;stat.max
tel_temp	twomass_scn	TWOMASS	Telescope girdle temperature at beginning of scan.	real	4	degC		phys.temperature
tel_temp	twomass_sixx2_scn	TWOMASS	telescope tube girdle temperature (deg C) at beg. of scan	real	4	degC
telescope	allSkyNIRFrameSetInfo	VULCANiDR		varchar	8	Name of telescope: VISTA/UKIRT
telluricExt	Detection	PS1DR2	Estimated Telluric extinction due to non-photometric observing conditions. Necessary for converting listed fluxes and magnitudes back to measured ADU counts.	real	4	magnitudes
tessID	ObjectThin	PS1DR2	Tessellation identifier. Details in the TessellationType table.	tinyint	1		0	meta.id
tessID	StackObjectThin	PS1DR2	Tessellation identifier. Details in the TessellationType table.	tinyint	1		0
tile	twomass_scn	TWOMASS	Tile identification number.	int	4			meta.id
tile	twomass_sixx2_scn	TWOMASS	tile ID number	int	4
timeStamp	ArchiveCurationHistory	VULCANiDR	Time of the completion of the whole task	datetime	8	UTC		time.epoch
timeStamp	ProgrammeCurationHistory	VULCANiDR	Time of individual programme curation completion	datetime	8	UTC		time.epoch
title	Programme	VULCANiDR	a short title for the programme, eg. "VISTA Hemisphere Survey"	varchar	64			meta.note
tmass_key	allwise_sc	WISE	2MASS PSC association. Unique identifier of the closest source in the 2MASS Point Source Catalog (PSC) that falls within 3" of the non-motion fit position of this WISE source. This is equivalent to the pts_key in the 2MASS PSC entry. This column is "null" if there is no 2MASS PSC source within 3" of the WISE source position. The number of 2MASS PSC sources within 3" of the WISE position is given in n_2mass. CAUTION - 2MASS source information included in the WISE source record is an association not an identification. Although the position accuracies of the two Catalogs are good, there is a non-zero probability of chance associations between physically unrelated objects, as well as missed associations between the Catalogs. You should always confirm associations by reviewing the entries from both Catalogs.	int	4
tmass_key	wise_allskysc	WISE	2MASS PSC association. Unique identifier of the closest source in the 2MASS Point Source Catalog (PSC) that falls within 3" of the position of this WISE source. This is equivalent to the pts_key in the 2MASS PSC entry. This column is default if there is no 2MASS PSC source within 3" of the WISE source position. The number of 2MASS PSC sources within 3" of the WISE position is given in n_2mass. CAUTION - 2MASS source information included in the WISE source record is an association not an identification.	bigint	8		-99999999
tmass_key	wise_prelimsc	WISE	Unique identifier of the closest source in the 2MASS Point Source Catalog (PSC) that falls within 3" of the position of this WISE source This is equivalent to the pts_key in the 2MASS PSC entry. This column is default if there is no 2MASS PSC source within 3" of the WISE source position. The number of 2MASS PSC sources within 3" of the WISE position is given in n_2mass	bigint	8		-99999999