covercodes - Table

Turboveg 3

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: covercodes

Table with cover codes and their percentage representation

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	id	Integer
	lookupdataid	Integer
	code	VarChar()				Code voor bedekkingswaarde
	uri	VarChar()				NDFF-uri voor de code
	percentage_mean	Real				Bedekking in procenten (gemiddeld)
	percentage_min	Real				Bedekking in procenten (minimum)
	percentage_max	Real				Bedekking in procenten (maximum)

Indexes

Name	Table	Columns	Unique	Clustered
covercodes_index01	covercodes	lookupdataid, code

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
covercodes_fkey01	lookupdata	covercodes	id	lookupdataid

Used in Diagrams