musewide_tap_schema.columns

Description

The table of columns of the service

Columns

Name Type UCD Unit Description
id integer

Internal ID of the column

table_name char

The name of the table of the column

column_name char

The name of the column

datatype char

The datatype of the column

arraysize integer

The size of the column for variable length datatypes

size integer

The size of the column for variable length datatypes (legacy)

description char

The description of the column

utype char

The IVOA UTYPE of the column

unit char

The Unit of the column

ucd char

The IVOA UCD of the column

principal boolean

Designates if the column is considered a core part of the service

indexed boolean

Designates if the column is indexed

std boolean

Designates if the column is defined by some standard

column_index integer

The ordering index of the column

table_id integer

The foreign key to the table of this column