DbWrench Documentation: PSLID 3.0 |
Home | Tables | Schemas | Diagrams | Foreign Keys | Indexes |
Table: tblmicroscopy |
Columns | |||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
| microscopy_id | Integer | |||||
objective_id | Integer |
|
|
||||
detector_id | Integer |
|
|
||||
condenser_id | Integer |
|
|
||||
illumination_id | Integer |
|
|
||||
microscope_id | Integer |
|
|
||||
exposure_time | VarChar(30) |
| |||||
microscopy_name | VarChar(60) |
| |||||
emission_magnification | Float |
|
Indexes | ||||
Name | Table | Columns | Unique | Clustered |
Foreign Keys | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
tblmicpy_tblcondser | tblcondenser | tblmicroscopy | condenser_id | condenser_id |
tblmicpy_tbldetector | tbldetector | tblmicroscopy | detector_id | detector_id |
tblmicpy_tblillum | tblillumination | tblmicroscopy | illumination_id | illumination_id |
tblmicpy_tblmicsp | tblmicroscope | tblmicroscopy | microscope_id | microscope_id |
tblmicpy_tblobj | tblobjective | tblmicroscopy | objective_id | objective_id |
Parent Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
tblmicpyft_tblmicpy | tblmicroscopy | tblmicroscopy_filter | microscopy_id | microscopy_id |
Triggers | |||||||
Name | Table | On Delete | On Insert | On Update | Execute | For Each | SQL |
Used in Diagrams |
Diagram Name |
Take II |