Columns

The DEFAULTCOLUMNSLIST table includes all the columns a user can specify in a list. The driver exposes all user-specified columns by default. The column names indicate the type of column created. The ID column marked with an asterisk is the primary key.

Column Name Data Type
ID* INT32
BOOLEANCOL BOOLEAN
CHOICECOL STRING(255)
CURRENCYCOL DECIMAL(19, 4)
LINKCOL​_DESCRIPTION STRING(255)
LINKCOL​_URL STRING(255)
LOCATIONCOL​_ADDRESS​_CITY STRING(255)
LOCATIONCOL​_ADDRESS​_COUNTRYORREGION STRING(255)
LOCATIONCOL​_ADDRESS​_POSTALCODE STRING(255)
LOCATIONCOL​_ADDRESS​_STATE STRING(255)
LOCATIONCOL​_ADDRESS​_STREET STRING(255)
LOCATIONCOL​_COORDINATES​_LATITUDE DOUBLE
LOCATIONCOL​_COORDINATES​_LONGITUDE DOUBLE
LOCATIONCOL​_DISPLAYNAME STRING(255)
MULTILINECOL STRING(63999)
NUMCOL DOUBLE
PERSONCOL STRING(255)
PICTURECOL​_DESCRIPTION STRING(255)
PICTURECOL​_URL STRING(255)
SINGLELINECOL STRING(255)
TASKCOL STRING(255)
TEXTCOL STRING(63999)
TITLE STRING(255)