SchemaSpy - transmart.tm_lz

Generated by
SchemaSpy


Things that might not be 'quite right' about your schema:

Columns whose name and type imply a relationship to another table's primary key:
Anomaly not detected

Tables without indexes:

Table	Rows
clinical_trial_metadata_ext	0
lt_metabolomic_annotation	0
lt_metabolomic_display_mapping	0
lt_protein_annotation	0
lt_qpcr_mirna_annotation	0
lt_rnaseq_annotation	0
lt_snp_calls_by_gsm	0
lt_snp_copy_number	0
lt_snp_gene_map	0
lt_src_acgh_data	0
lt_src_cel_files	0
lt_src_clinical_data	0
lt_src_data_metadata	0
lt_src_deapp_annot	0
lt_src_display_mapping	0
lt_src_metabolomic_data	0
lt_src_metabolomic_map	0
lt_src_metabolomics_display_mapping	0
lt_src_mirna_deapp_annot	0
lt_src_mirna_display_mapping	0
lt_src_mirna_subj_samp_map	0
lt_src_mrna_data	0
lt_src_mrna_subj_samp_map	0
lt_src_nextbio	0
lt_src_omicsoft_annot	0
lt_src_omicsoft_data	0
lt_src_pathway	0
lt_src_pathway_org	0
lt_src_protein_display_mapping	0
lt_src_proteomics_data	0
lt_src_proteomics_sub_sam_map	0
lt_src_qpcr_mirna_data	0
lt_src_rbm_annotation	0
lt_src_rbm_data	0
lt_src_rbm_display_mapping	0
lt_src_rbm_subj_samp_map	0
lt_src_rna_display_mapping	0
lt_src_rna_seq_data	0
lt_src_rna_seq_subj_samp_map	0
lt_src_rnaseq_data	0
lt_src_sample_categories	0
lt_src_search_keyword	0
lt_src_study_metadata	0
lt_src_study_metadata_ad_hoc	0
lt_src_subj_enroll_date	0
lz_src_analysis_metadata	0
lz_src_clinical_data	0
lz_src_mrna_data	0
lz_src_sample_categories	0
lz_src_sample_categories_bkup	0
lz_src_study_metadata	0
lz_src_study_metadata_ad_hoc	0
lz_src_subj_enroll_date	0
rwg_analysis	0
rwg_analysis_data	0
rwg_analysis_data_ext	0
rwg_analysis_ext	0
rwg_cohorts	0
rwg_cohorts_ext	0
rwg_samples	0
rwg_samples_ext	0
wt_snp_node_values	0
wt_snp_nodes	0

63 instances of anomaly detected

Columns that are flagged as both 'nullable' and 'must be unique':
Anomaly not detected
Tables that contain a single column:

Table Column

lt_src_cel_files cel_file_name

1 instance of anomaly detected

Table	Column
lt_src_cel_files	cel_file_name

Tables with incrementing column names, potentially indicating denormalization:

8 instances of anomaly detected

Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
Anomaly not detected