datasets - Table

Turboveg 3

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: datasets

Tablel with information on datasets.

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	id	Integer
	name	VarChar(50)
	datasetgroupid	Integer
	profileid	Integer
	taxonlistid	Integer
	custodianid	Integer
	deputycustodianid	Integer
	givdid	VarChar()				GIVD code (www.givd.info)
	guid	VarChar()				Uniek id voor dataset
	metadata	VarChar()

Indexes

Name	Table	Columns	Unique	Clustered
datasets_index01	datasets	datasetgroupid
datasets_index02	datasets	name

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
datasets_fkey01	datasetgroups	datasets	id	datasetgroupid
datasets_fkey02	taxonlists	datasets	id	taxonlistid
datasets_fkey03	profiles	datasets	id	profileid
datasets_fkey04	custodians	datasets	id	custodianid
datasets_fkey05	custodians	datasets	id	deputycustodianid

Used in Diagrams