tblresearcher - Table

tblresearcher - Table

DbWrench Documentation: PSLID 3.0

Table: tblresearcher

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	researcher_id	Integer
	laboratory_id	Integer
	researcher_name	VarChar(30)
	researcher_email_add	VarChar(30)
	researcher_phone_num	VarChar(30)

Indexes
Name	Table	Columns	Unique	Clustered

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
tblresch_tbllab	tbllaboratory	tblresearcher	laboratory_id	laboratory_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
tblexp_tblresch	tblresearcher	tblexperiment	researcher_id	researcher_id

Triggers
Name	Table	On Delete	On Insert	On Update	Execute	For Each	SQL