Table transmart.biomart.bio_lit_amd_data 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_lit_amd_data_id int8 19
bio_lit_alt_data_id int8 19
bio_lit_alt_data.bio_lit_alt_data_id bio_lit_amd_alt_fk R
etl_id varchar 50  √  null
molecule varchar 50  √  null
molecule_type varchar 50  √  null
total_exp_percent varchar 50  √  null
total_exp_number varchar 100  √  null
total_exp_value varchar 100  √  null
total_exp_sd varchar 50  √  null
total_exp_unit varchar 50  √  null
over_exp_percent varchar 50  √  null
over_exp_number varchar 100  √  null
over_exp_value varchar 100  √  null
over_exp_sd varchar 50  √  null
over_exp_unit varchar 50  √  null
co_exp_percent varchar 50  √  null
co_exp_number varchar 100  √  null
co_exp_value varchar 100  √  null
co_exp_sd varchar 50  √  null
co_exp_unit varchar 50  √  null
mutation_type varchar 50  √  null
mutation_sites varchar 50  √  null
mutation_change varchar 50  √  null
mutation_percent varchar 50  √  null
mutation_number varchar 100  √  null
target_exp_percent varchar 50  √  null
target_exp_number varchar 100  √  null
target_exp_value varchar 100  √  null
target_exp_sd varchar 50  √  null
target_exp_unit varchar 50  √  null
target_over_exp_percent varchar 50  √  null
target_over_exp_number varchar 100  √  null
target_over_exp_value varchar 100  √  null
target_over_exp_sd varchar 50  √  null
target_over_exp_unit varchar 50  √  null
techniques varchar 250  √  null
description varchar 1000  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_lit_amd_data_id Primary key Asc bio_lit_amd_data_pk

Close relationships  within of separation: