Table transmart.biomart.bio_content 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
bio_file_content_id int8 19
bio_content_reference.bio_content_id bio_content_ref_cont_fk R
file_name varchar 1000  √  null
repository_id int8 19  √  null
bio_content_repository.bio_content_repo_id ext_file_cnt_cnt_repo_fk R
location varchar 400  √  null
title varchar 1000  √  null
abstract varchar 2000  √  null
file_type varchar 200
etl_id int8 19  √  null
etl_id_c varchar 30  √  null
study_name varchar 30  √  null
cel_location varchar 300  √  null
cel_file_suffix varchar 30  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_file_content_id Primary key Asc external_file_pk
bio_file_content_id Must be unique Asc bio_content_pk

Close relationships: