VIEW Columns

DERIVED FROM DBColumns

Aliias the DBColumns table also as Columns, for legacy SkyQuery

name type length unit ucd description

tablename varchar 128 ID_TABLE The name of the parent table

name varchar 64 ID_IDENTIFIER The name of column

unit varchar 64 METADATA_UNIT Optional description of units

ucd varchar 128 ID_IDENTIFIER Optional UCD definition

enum varchar 64 ID_TABLE Optional link to an enumerated table

description varchar 2000 METADATA_DESCRIPTION One line description of column

rank int 4 ID_TABLE Optional position of column in table column display

name	type	length	unit	ucd	description
tablename	varchar	128		ID_TABLE	The name of the parent table
name	varchar	64		ID_IDENTIFIER	The name of column
unit	varchar	64		METADATA_UNIT	Optional description of units
ucd	varchar	128		ID_IDENTIFIER	Optional UCD definition
enum	varchar	64		ID_TABLE	Optional link to an enumerated table
description	varchar	2000		METADATA_DESCRIPTION	One line description of column
rank	int	4		ID_TABLE	Optional position of column in table column display