DbWrench Documentation: PSLID |
Home | Tables | Diagrams | Foreign Keys | Indexes |
Table: tbllabel |
Columns | |||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
| label_id | Integer | |||||
dye_id | Integer |
|
|
||||
label_name | VarChar(40) |
| |||||
target_id | Integer |
|
|
||||
ligand_class_id | Integer |
|
|
Indexes | |||
Name | Columns | Unique | Clustered |
Foreign Keys - Child Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
tbllabel_tbldye | tbldye | tbllabel | dye_id | dye_id |
tbllabel_tblsub1 | tblsubstance | tbllabel | substance_id | target_id |
tbllabel_tblsub2 | tblsubstance | tbllabel | substance_id | ligand_class_id |
Foreign Keys - Parent Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
label | tbllabel | tblslide_label | label_id | label_id |
Triggers | ||||||
Name | On Delete | On Insert | On Update | Execute | For Each | SQL |
Used in Diagrams |
Diagram Name |
Take II |