tblsubstance - Table

tblsubstance - Table

DbWrench Documentation: PSLID

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	Columns	Unique	Clustered

Foreign Keys - Child Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
tblsub_tblsup	tblsupplier	tblsubstance	supplier_id	supplier_id

Foreign Keys - 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	On Delete	On Insert	On Update	Execute	For Each	SQL