Table transmart.biomart.bio_compound 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_compound_id int8 19
bio_data_compound.bio_compound_id bio_df_cmp_fk R
tmp_omicsoft_compound.bio_compound_id Implied Constraint R
cnto_number varchar 200  √  null
jnj_number varchar 200  √  null
cas_registry varchar 400  √  null
code_name varchar 300  √  null
generic_name varchar 200  √  null
brand_name varchar 200  √  null
chemical_name varchar 1000  √  null
mechanism varchar 400  √  null
product_category varchar 200  √  null
description varchar 1000  √  null
etl_id_retired int8 19  √  null
etl_id varchar 50  √  null
source_cd varchar 100  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_compound_id Primary key Asc compounddim_pk
bio_compound_id Must be unique Asc bio_compound_pk

Close relationships: