filemetadata - dataverse5.public

Columns

Related columns Constraint Comments

Search:

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_id	R
vargroup.filemetadata_id	fk_vargroup_filemetadata_id	R
variablemetadata.filemetadata_id	fk_variablemetadata_filemetadata_id	R

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_id

R

datasetversion_id

int8

19

null

datasetversion.id

fk_filemetadata_datasetversion_id

R

Showing 1 to 9 of 9 entries

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees