Table transmart.biomart.bio_lit_inh_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_inh_data_id int8 19
bio_lit_ref_data_id int8 19  √  null
bio_lit_ref_data.bio_lit_ref_data_id bio_lit_inh_ref_fk R
etl_id varchar 50  √  null
trial_type varchar 250  √  null
trial_phase varchar 250  √  null
trial_status varchar 250  √  null
trial_experimental_model varchar 250  √  null
trial_tissue varchar 250  √  null
trial_body_substance varchar 250  √  null
trial_description varchar 1000  √  null
trial_designs varchar 250  √  null
trial_cell_line varchar 250  √  null
trial_cell_type varchar 250  √  null
trial_patients_number varchar 100  √  null
trial_inclusion_criteria varchar 2000  √  null
inhibitor varchar 250  √  null
inhibitor_standard_name varchar 250  √  null
casid varchar 250  √  null
description varchar 1000  √  null
concentration varchar 250  √  null
time_exposure varchar 500  √  null
administration varchar 250  √  null
treatment varchar 2000  √  null
techniques varchar 1000  √  null
effect_molecular varchar 250  √  null
effect_percent varchar 250  √  null
effect_number varchar 50  √  null
effect_value varchar 250  √  null
effect_sd varchar 250  √  null
effect_unit varchar 250  √  null
effect_response_rate varchar 250  √  null
effect_downstream varchar 2000  √  null
effect_beneficial varchar 2000  √  null
effect_adverse varchar 2000  √  null
effect_description varchar 2000  √  null
effect_pharmacos varchar 2000  √  null
effect_potentials varchar 2000  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_lit_inh_data_id Primary key Asc bio_lit_inh_data_pk

Close relationships  within of separation: