Schema Diagram
erDiagram
Control {
string comment
string control_type
integer id
}
ControlImage {
string magnification
string phenotype_comments
string phenotype_id
string resolution
string scale_bar
integer id
}
Experiment {
string rearing_condition_comment
boolean standard_rearing_condition
integer id
}
ExposureEvent {
string additional_exposure_condition
string comment
uriorcurie exposure_end_stage
uriorcurie exposure_start_stage
integer id
}
ExposureRoute {
string term_label
uriorcurie term_uri
}
ExposureType {
string term_label
uriorcurie term_uri
}
Fish {
string name
string zfin_id
}
Image {
string magnification
string resolution
string scale_bar
integer id
}
OntologyEntity {
}
Phenotype {
SeverityEnum severity
uriorcurie stage
integer id
}
PhenotypeObservationSet {
integer id
}
PhenotypeTerm {
string term_label
uriorcurie term_uri
}
QuantityValue {
string numeric_value
string unit
}
Regimen {
ExposureRegimenTypeEnum exposure_regimen_type
integer number_of_individual_exposure
integer id
}
StressorChemical {
string cas_id
uriorcurie chemical_id
string chemical_name
string comment
ManufacturerEnum manufacturer
stringList synonym
integer id
}
Study {
uriorcurieList annotator
uriorcurie lab
string publication
integer id
}
VehicleOfTransmission {
string comment
ManufacturerEnum manufacturer
VehicleEnum vehicle_type
integer id
}
ZappEntity {
integer id
}
ZfinEntity {
string zfin_id
}
Control ||--|o VehicleOfTransmission : "vehicle_if_treated"
Control ||--}o ControlImage : "control_image"
Experiment ||--|o Fish : "fish"
Experiment ||--}o Control : "control"
Experiment ||--}o ExposureEvent : "exposure_event"
ExposureEvent ||--|o ExposureRoute : "route"
ExposureEvent ||--|o ExposureType : "exposure_type"
ExposureEvent ||--|o Regimen : "regimen"
ExposureEvent ||--}o PhenotypeObservationSet : "phenotype_observation"
ExposureEvent ||--}o StressorChemical : "stressor"
ExposureEvent ||--}o VehicleOfTransmission : "vehicle"
Phenotype ||--|o PhenotypeTerm : "phenotype_term_id"
Phenotype ||--|o QuantityValue : "prevalence"
PhenotypeObservationSet ||--}o ControlImage : "control_image"
PhenotypeObservationSet ||--}o Image : "image"
PhenotypeObservationSet ||--}o Phenotype : "phenotype"
Regimen ||--|o QuantityValue : "individual_exposure_duration, interval_between_individual_exposures, total_exposure_duration"
StressorChemical ||--|| QuantityValue : "concentration"
Study ||--}o Experiment : "experiment"
VehicleOfTransmission ||--|o QuantityValue : "concentration"