| DbWrench Documentation: PSLID 3.0 | 
| Home | Tables | Schemas | 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 | Table | Columns | Unique | Clustered | 
| Foreign Keys | ||||
| 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 | 
| Parent Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns | 
| label | tbllabel | tblslide_label | label_id | label_id | 
| Triggers | |||||||
| Name | Table | On Delete | On Insert | On Update | Execute | For Each | SQL | 
| Used in Diagrams | 
| Diagram Name | 
| Take II |