TABLE IndexMap

Table containing the definition of all indices

Contains all information necessary to build the indices including the list of fields. Drives both index creation and data validation.

name type length unit ucd description

indexmapid int 4 CODE_MISC unique primary key for the indexmap

code varchar 2 CODE_MISC one char designator of index category for lookup ('K'|'F'|'I')

type varchar 32 CODE_MISC index type, one of ('primary key'|'foreign key'|'index'|'unique index')

tableName varchar 128 CODE_MISC the name of the table the index is built on

fieldList varchar 1000 CODE_MISC the list of columns to be included in the index

foreignKey varchar 1000 CODE_MISC the definition of the foreign Key if any

indexgroup varchar 128 CODE_MISC the group id, one of ('PHOTO'|'TAG'|'SPECTRO'|'QSO'|'META'|'TILES'|'FINISH')

name	type	length	unit	ucd	description
indexmapid	int	4		CODE_MISC	unique primary key for the indexmap
code	varchar	2		CODE_MISC	one char designator of index category for lookup ('K'\|'F'\|'I')
type	varchar	32		CODE_MISC	index type, one of ('primary key'\|'foreign key'\|'index'\|'unique index')
tableName	varchar	128		CODE_MISC	the name of the table the index is built on
fieldList	varchar	1000		CODE_MISC	the list of columns to be included in the index
foreignKey	varchar	1000		CODE_MISC	the definition of the foreign Key if any
indexgroup	varchar	128		CODE_MISC	the group id, one of ('PHOTO'\|'TAG'\|'SPECTRO'\|'QSO'\|'META'\|'TILES'\|'FINISH')