|
DbWrench Documentation: PSLID |
| Home | Tables | Diagrams | Foreign Keys | Indexes |
|
Table: tbldye |
| Columns | |||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
|
| dye_id | Integer | |||||
| dye_name | VarChar(30) |
| |||||
| dye_mesh_heading | VarChar(60) |
| |||||
| excitation_max | Integer |
| |||||
| emission_max | Integer |
| |||||
| supplier_id | Integer |
|
|
||||
| supplier_part_number | Integer |
| |||||
| Indexes | |||
| Name | Columns | Unique | Clustered |
| Foreign Keys - Child Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| tbldye_tbysup | tblsupplier | tbldye | supplier_id | supplier_id |
| Foreign Keys - Parent Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| tbllabel_tbldye | tbldye | tbllabel | dye_id | dye_id |
| Triggers | ||||||
| Name | On Delete | On Insert | On Update | Execute | For Each | SQL |
| Used in Diagrams |
| Diagram Name |
| Take II |