Table transmart.biomart.project_info 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
file_id int4 10
id varchar 100  √  null
name varchar 100  √  null
file_name varchar 100  √  null
activedataname varchar 400  √  null
project_accession varchar 100  √  null
project_category text 2147483647  √  null
project_contactaddress varchar 4000  √  null
project_contactcompany varchar 400  √  null
project_contactdepartment varchar 400  √  null
project_contactemail varchar 400  √  null
project_contactlaboratory varchar 400  √  null
project_contactname varchar 400  √  null
project_contactphone varchar 100  √  null
project_contactweblink varchar 1000  √  null
project_contributors varchar 4000  √  null
project_description text 2147483647  √  null
project_design text 2147483647  √  null
project_id varchar 100  √  null
project_keywords varchar 1000  √  null
project_organism varchar 400  √  null
project_tissue varchar 400  √  null
project_compound varchar 400  √  null
project_platform varchar 400  √  null
project_platformdescription varchar 4000  √  null
project_platformorganism varchar 400  √  null
project_platformprovider varchar 400  √  null
project_platformtechnology varchar 400  √  null
project_platformtype varchar 400  √  null
project_pubmed varchar 400  √  null
project_studytype varchar 1000  √  null
project_supplementaryfile varchar 400  √  null
project_title varchar 500  √  null
project_weblink varchar 1000  √  null
project_extractedfromcelfiles varchar 1000  √  null
project_contactorganization varchar 1000  √  null
project_contactfax varchar 100  √  null
project_outputfile varchar 500  √  null
project_datasource varchar 100  √  null
project_editors varchar 100  √  null
project_isprivate varchar 100  √  null
project_publishdate varchar 100  √  null
entrydt timestamp 29,6  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
file_id Primary key Asc project_info_pkey  
file_name Must be unique Asc project_info_file_name_key This unique column is also nullable
id Must be unique Asc project_info_id_key This unique column is also nullable
name Must be unique Asc project_info_name_key This unique column is also nullable