DbWrench Documentation: PSLID |
Home | Tables | Diagrams | Foreign Keys | Indexes |
Table: tblmicroscopy_filter |
Columns | |||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
| microscopy_filter_id | Integer | |||||
microscopy_id | Integer |
|
|
||||
ex_filter_id | Integer |
|
|
||||
excitation_filter_angle | Float |
| |||||
em_filter_id | Integer |
|
|
||||
emission_filter_angle | Float |
|
Indexes | |||
Name | Columns | Unique | Clustered |
Foreign Keys - Child Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
tblmicpyft_tblfilter1 | tblfilter | tblmicroscopy_filter | filter_id | ex_filter_id |
tblmicpyft_tblfilter2 | tblfilter | tblmicroscopy_filter | filter_id | em_filter_id |
tblmicpyft_tblmicpy | tblmicroscopy | tblmicroscopy_filter | microscopy_id | microscopy_id |
Foreign Keys - Parent Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
tblstack_tblmicroscopyfilter | tblmicroscopy_filter | tblstack | microscopy_filter_id | microscopy_filter_id |
Triggers | ||||||
Name | On Delete | On Insert | On Update | Execute | For Each | SQL |
Used in Diagrams |
Diagram Name |
Take II |