Stores minimal application schema identifying, descriptive and MIME type information about columns in user vector feature and tile matrix data tables that supplements the data available from the SQLite sqlite_master table and pragma table_info(table_name) SQL function. The gpkg_data_columns data CAN be used to provide more specific column data types and value ranges and application specific structural and semantic information to enable more informative user menu displays and more effective user decisions on the suitability of GeoPackage contents for specific purposes.

Hierarchy

  • DataColumns

Constructors

Properties

column_name: string

the name of the table column

Member

constraint_name: string

Case sensitive column value constraint name specified

description: string

A human-readable description for the table_name contents

Member

mime_type: string

MIME type of columnName if BLOB type or NULL for other types

Member

name: string

A human-readable identifier (e.g. short name) for the column_name content

Member

table_name: string

the name of the tiles, or feature table

Member

title: string

A human-readable formal title for the column_name content

Member

COLUMN_COLUMN_NAME: "column_name" = 'column_name'

columnName field name

COLUMN_CONSTRAINT_NAME: "constraint_name" = 'constraint_name'

constraintName field name

COLUMN_DESCRIPTION: "description" = 'description'

description field name

COLUMN_ID_1: string = DataColumns.COLUMN_TABLE_NAME

id 1 field name, tableName

COLUMN_ID_2: "column_name" = DataColumns.COLUMN_COLUMN_NAME

id 2 field name, columnName

COLUMN_MIME_TYPE: "mime_type" = 'mime_type'

mimeType field name

COLUMN_NAME: "name" = 'name'

name field name

COLUMN_TABLE_NAME: string = Contents.COLUMN_TABLE_NAME

tableName field name

COLUMN_TITLE: "title" = 'title'

title field name

TABLE_NAME: "gpkg_data_columns" = 'gpkg_data_columns'

Table name

Methods

Generated using TypeDoc