Table transmart.i2b2demodata.linked_file_collection
Stores universally unique identifier to the collection of files (a folder) on an external file system (e.g. Arvados Keep)

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int4 10
storage_system.id Implied Constraint R
name varchar 900  √  null Name of the collection.
study_id int4 10
study.study_num STUDY_ID_FK R
Points to the study the file associated with.
source_system_id int4 10
storage_system.id SOURCE_SYSTEM_ID_ID_FK R
The universally unique identifier on the storage system.
uuid varchar 50  √  null

Table contained 0 rows at Wed Jun 26 00:11 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc linked_file_collection_pkey

Close relationships  within of separation: