ER
2017-07-30 18:07:04 0 举报生物医疗数据库ER图第一版，啦啦啦啦啦啦啦
作者其他创作
大纲/内容
n
1
drug_products
protein_synonyms
motif
Uniprot_ID(primary_key)Feature_keyPositionDescriptionActionsLenth
treat
belong
drug_synonyms
Synonyms(primary_key)Gene_ID
drug
Synonyms(primary_key)Uniprot_ID
gene
have
isforms_ID
Uniprot_ID(primary_key)Isoforms_ID(primary_key)
drug_symptom
drug_side_effects
disease
gene_synonyms
protein
Product_name(primary_key)Defined_ID(primary_key)
Defined_ID(primary_key)NamePubchem_IDDrugbank_IDChembl_IDTypeGroupsDescriptionIndicationCategoriesMechanism_of_actionRelated_articlesAbsorptionHalf_lifeToxicityAffected_organismsFood_interaction
Symptom(primary_key)Defined_ID(primary_key)
drug_target
Target_nameKindPharmacological_actionActionsOrganismScoreGeneral_functionSpecific_functionUniprot_IDgene_name
drug_effects
Side_effects(primary_key)Defined_ID(primary_key)
DOID(primary_key)NameMESH_classOntology_typeDefinationsynonymsOMIM_IDUMLS_CUIMESHICD_10Semantic_typePhenotypesDisease_ontologyInheritanceSymptomProtein_association
drug_disease
Defined_ID(primary_key)DOID(primary_key)
Synonyms(primary_key)Defined_ID
disease_gene
Gene_ID(primary_key)DOID(primary_key)ScorePMIDs
drug_interaction
Defined_ID_1(primary_key)Defined_ID_2(primary_key)Interaction
target
interaction
cause
Gene_ID(primary_key)NameOfficial_full_nameDescriptionGene_typeRefSeq_statusOrganismLocationProtein
GO-molecular_function
Uniprot_ID(primary_key)IDNameDefination
Uniprot_ID(primary_key)NameGene_IDOrganismTaxonomic_identifierProteomesSubcellular_locationChEMBL_ID
0 条评论
下一页
