DbWrench Documentation: PSLID 3.0 |
Home | Tables | Schemas | Diagrams | Foreign Keys | Indexes |
Table: tblsubstance |
Columns | |||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
| substance_id | Integer | |||||
name | VarChar(40) |
| |||||
source_organism_mesh_heading | VarChar(40) |
| |||||
source_organism_mesh_treenumber | VarChar(40) |
| |||||
supplier_id | Integer |
|
|
||||
supplier_part_number | Integer |
| |||||
substance_mesh_heading | VarChar(40) |
| |||||
substance_mesh_treenumber | VarChar(40) |
| |||||
uniprot_link | VarChar(100) |
|
Indexes | ||||
Name | Table | Columns | Unique | Clustered |
Foreign Keys | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
tblsub_tblsup | tblsupplier | tblsubstance | supplier_id | supplier_id |
Parent Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
tbllabel_tblsub1 | tblsubstance | tbllabel | substance_id | target_id |
tbllabel_tblsub2 | tblsubstance | tbllabel | substance_id | ligand_class_id |
tblstack_tbltarget | tblsubstance | tblstack | substance_id | target_id |
tblsub_child | tblsubstance | tblsub2sub | substance_id | child |
tblsub_parent | tblsubstance | tblsub2sub | substance_id | parent |
Triggers | |||||||
Name | Table | On Delete | On Insert | On Update | Execute | For Each | SQL |
Used in Diagrams |
Diagram Name |
Take II |