filemetadata

73 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('filemetadata_id_seq'::regclass)
filemetadata_datafilecategory.filemetadatas_id fk_filemetadata_datafilecategory_filemetadatas_idR
vargroup.filemetadata_id fk_vargroup_filemetadata_idR
variablemetadata.filemetadata_id fk_variablemetadata_filemetadata_idR
description text 2147483647 √ null
directorylabel varchar 255 √ null
label varchar 255 null
prov_freeform text 2147483647 √ null
restricted bool 1 √ null
version int8 19 √ null
datafile_id int8 19 null
dvobject.id fk_filemetadata_datafile_idR
datasetversion_id int8 19 null
datasetversion.id fk_filemetadata_datasetversion_idR

Indexes

Constraint Name Type Sort Column(s)
filemetadata_pkey Primary key Asc id
index_filemetadata_datafile_id Performance Asc datafile_id
index_filemetadata_datasetversion_id Performance Asc datasetversion_id

Relationships

Close relationships within degrees of separation