VIEW  Columns

DERIVED FROM  DBColumns

Aliias the DBColumns table also as Columns, for legacy SkyQuery

nametypelengthunitucddescription
tablenamevarchar128 ID_TABLEThe name of the parent table
namevarchar64 ID_IDENTIFIERThe name of column
unitvarchar64 METADATA_UNITOptional description of units
ucdvarchar128 ID_IDENTIFIEROptional UCD definition
enumvarchar64 ID_TABLEOptional link to an enumerated table
descriptionvarchar2000 METADATA_DESCRIPTIONOne line description of column
rankint4 ID_TABLEOptional position of column in table column display