tblmicroscopy - Table

tblmicroscopy - Table

DbWrench Documentation: PSLID

Table: tblmicroscopy

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	microscopy_id	Integer
	objective_id	Integer
	detector_id	Integer
	condenser_id	Integer
	illumination_id	Integer
	microscope_id	Integer
	exposure_time	VarChar(30)
	microscopy_name	VarChar(60)
	emission_magnification	Float

Indexes
Name	Columns	Unique	Clustered

Foreign Keys - Child Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
tblmicpy_tblcondser	tblcondenser	tblmicroscopy	condenser_id	condenser_id
tblmicpy_tbldetector	tbldetector	tblmicroscopy	detector_id	detector_id
tblmicpy_tblillum	tblillumination	tblmicroscopy	illumination_id	illumination_id
tblmicpy_tblmicsp	tblmicroscope	tblmicroscopy	microscope_id	microscope_id
tblmicpy_tblobj	tblobjective	tblmicroscopy	objective_id	objective_id

Foreign Keys - Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
tblmicpyft_tblmicpy	tblmicroscopy	tblmicroscopy_filter	microscopy_id	microscopy_id

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