Table transmart.biomart.bio_lit_alt_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_alt_data_id int8 19
bio_lit_amd_data.bio_lit_alt_data_id bio_lit_amd_alt_fk R
bio_lit_ref_data_id int8 19
bio_lit_ref_data.bio_lit_ref_data_id bio_lit_alt_ref_fk R
in_vivo_model_id int8 19  √  null
in_vitro_model_id int8 19  √  null
etl_id varchar 50  √  null
alteration_type varchar 50  √  null
control varchar 1000  √  null
effect varchar 500  √  null
description varchar 1000  √  null
techniques varchar 1000  √  null
patients_percent varchar 500  √  null
patients_number varchar 500  √  null
pop_number varchar 250  √  null
pop_inclusion_criteria varchar 1000  √  null
pop_exclusion_criteria varchar 1000  √  null
pop_description varchar 1000  √  null
pop_type varchar 250  √  null
pop_value varchar 250  √  null
pop_phase varchar 250  √  null
pop_status varchar 250  √  null
pop_experimental_model varchar 250  √  null
pop_tissue varchar 250  √  null
pop_body_substance varchar 250  √  null
pop_localization varchar 1000  √  null
pop_cell_type varchar 250  √  null
clin_submucosa_marker_type varchar 250  √  null
clin_submucosa_unit varchar 250  √  null
clin_submucosa_value varchar 250  √  null
clin_asm_marker_type varchar 250  √  null
clin_asm_unit varchar 250  √  null
clin_asm_value varchar 250  √  null
clin_cellular_source varchar 250  √  null
clin_cellular_type varchar 250  √  null
clin_cellular_count varchar 250  √  null
clin_prior_med_percent varchar 250  √  null
clin_prior_med_dose varchar 250  √  null
clin_prior_med_name varchar 250  √  null
clin_baseline_variable varchar 250  √  null
clin_baseline_percent varchar 250  √  null
clin_baseline_value varchar 250  √  null
clin_smoker varchar 250  √  null
clin_atopy varchar 250  √  null
control_exp_percent varchar 50  √  null
control_exp_number varchar 50  √  null
control_exp_value varchar 50  √  null
control_exp_sd varchar 50  √  null
control_exp_unit varchar 100  √  null
over_exp_percent varchar 50  √  null
over_exp_number varchar 50  √  null
over_exp_value varchar 50  √  null
over_exp_sd varchar 50  √  null
over_exp_unit varchar 100  √  null
loss_exp_percent varchar 50  √  null
loss_exp_number varchar 50  √  null
loss_exp_value varchar 50  √  null
loss_exp_sd varchar 50  √  null
loss_exp_unit varchar 100  √  null
total_exp_percent varchar 50  √  null
total_exp_number varchar 50  √  null
total_exp_value varchar 50  √  null
total_exp_sd varchar 50  √  null
total_exp_unit varchar 100  √  null
glc_control_percent varchar 250  √  null
glc_molecular_change varchar 250  √  null
glc_type varchar 50  √  null
glc_percent varchar 100  √  null
glc_number varchar 100  √  null
ptm_region varchar 250  √  null
ptm_type varchar 250  √  null
ptm_change varchar 250  √  null
loh_loci varchar 250  √  null
mutation_type varchar 250  √  null
mutation_change varchar 250  √  null
mutation_sites varchar 250  √  null
epigenetic_region varchar 250  √  null
epigenetic_type varchar 250  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_lit_alt_data_id Primary key Asc bio_lit_alt_data_pk

Close relationships  within of separation: