Dumped on 2009-07-06

Index of database - randtag

View: experiment_to_lab

experiment_to_lab Structure
F-Key Name Type Description
researcher_id integer
experiment_id integer
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
lab_name character varying(30)
lab_address character varying(150)
lab_email_add character varying(30)
lab_phone_num character varying(30) 
SELECT experiment_to_researcher.researcher_id
, experiment_to_researcher.experiment_id
, experiment_to_researcher.exp_title
, experiment_to_researcher.exp_date
, experiment_to_researcher.researcher_name
, experiment_to_researcher.researcher_email_add
, experiment_to_researcher.researcher_phone_num
, tbllaboratory.laboratory_id
, tbllaboratory.lab_name
, tbllaboratory.lab_address
, tbllaboratory.lab_email_add
, tbllaboratory.lab_phone_num 
FROM tbllaboratory
, experiment_to_researcher 
WHERE (tbllaboratory.laboratory_id = experiment_to_researcher.laboratory_id);

Index - Schema public

View: experiment_to_researcher

experiment_to_researcher Structure
F-Key Name Type Description
researcher_id integer
experiment_id integer
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer 
SELECT tblexperiment.researcher_id
, tblexperiment.experiment_id
, tblexperiment.exp_title
, tblexperiment.exp_date
, tblresearcher.researcher_name
, tblresearcher.researcher_email_add
, tblresearcher.researcher_phone_num
, tblresearcher.laboratory_id 
FROM tblresearcher
, tblexperiment 
WHERE (tblexperiment.researcher_id = tblresearcher.researcher_id);

Index - Schema public

View: featureset_to_feature

featureset_to_feature Structure
F-Key Name Type Description
featureset_name character varying(100)
feature_id integer
feature_name character varying(80)
feature_description character varying(100)
num_dimensions integer
num_channels integer 
SELECT tblfeatureset.featureset_name
, tblfeatureset.feature_id
, tblfeature.feature_name
, tblfeature.feature_description
, tblfeature.num_dimensions
, tblfeature.num_channels 
FROM tblfeatureset
, tblfeature 
WHERE (tblfeatureset.feature_id = tblfeature.feature_id);

Index - Schema public

View: image_mf

image_mf Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
substance_id integer
time_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
label_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
lab_name character varying(30)
lab_address character varying(150)
lab_email_add character varying(30)
lab_phone_num character varying(30)
protocol_title character varying(100)
microscopy_filter_id integer
microscopy_id integer
microscopy_name character varying(60)
objective_name character varying(60)
objective_id integer
detector_name character varying(60)
detector_id integer
condenser_name character varying(60)
illumination_name character varying(60)
microscope_name character varying(60)
ex_filter_id integer
excitation_filter_angle double precision
em_filter_id integer
emission_filter_angle double precision
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT image_to_lab.image_id
, image_to_lab.image_url
, image_to_lab.stack_pos
, image_to_lab.x_dim
, image_to_lab.y_dim
, image_to_lab.z_coor
, image_to_lab.stack_id
, image_to_lab.substance_id
, image_to_lab.time_id
, image_to_lab.name
, image_to_lab.field_of_view_id
, image_to_lab.slide_id
, image_to_lab.experiment_id
, image_to_lab.protocol_id
, image_to_lab.label_id
, image_to_lab.cell_name
, image_to_lab.cell_organism
, image_to_lab.exp_title
, image_to_lab.exp_date
, image_to_lab.researcher_name
, image_to_lab.researcher_email_add
, image_to_lab.researcher_phone_num
, image_to_lab.laboratory_id
, image_to_lab.lab_name
, image_to_lab.lab_address
, image_to_lab.lab_email_add
, image_to_lab.lab_phone_num
, image_to_lab.protocol_title
, image_to_lab.microscopy_filter_id
, mf_microscopy.microscopy_id
, mf_microscopy.microscopy_name
, mf_microscopy.objective_name
, mf_microscopy.objective_id
, mf_microscopy.detector_name
, mf_microscopy.detector_id
, mf_microscopy.condenser_name
, mf_microscopy.illumination_name
, mf_microscopy.microscope_name
, mf_microscopy.ex_filter_id
, mf_microscopy.excitation_filter_angle
, mf_microscopy.em_filter_id
, mf_microscopy.emission_filter_angle
, image_to_lab.stack_description
, image_to_lab.x_coor
, image_to_lab.y_coor 
FROM image_to_lab
, mf_microscopy 
WHERE (image_to_lab.microscopy_filter_id = mf_microscopy.microscopy_filter_id);

Index - Schema public

View: image_to_celltype

image_to_celltype Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
cell_type_id integer
experiment_id integer
protocol_id integer
cell_name character varying(30)
cell_organism character varying(30)
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT image_to_slide.image_id
, image_to_slide.image_url
, image_to_slide.stack_pos
, image_to_slide.x_dim
, image_to_slide.y_dim
, image_to_slide.z_coor
, image_to_slide.stack_id
, image_to_slide.time_id
, image_to_slide.microscopy_filter_id
, image_to_slide.substance_id
, image_to_slide.name
, image_to_slide.field_of_view_id
, image_to_slide.slide_id
, image_to_slide.cell_type_id
, image_to_slide.experiment_id
, image_to_slide.protocol_id
, tblcell_type.cell_name
, tblcell_type.cell_organism
, image_to_slide.stack_description
, image_to_slide.x_coor
, image_to_slide.y_coor 
FROM image_to_slide
, tblcell_type 
WHERE (image_to_slide.cell_type_id = tblcell_type.cell_type_id);

Index - Schema public

View: image_to_experiment

image_to_experiment Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_id integer
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT image_to_celltype.image_id
, image_to_celltype.image_url
, image_to_celltype.stack_pos
, image_to_celltype.x_dim
, image_to_celltype.y_dim
, image_to_celltype.z_coor
, image_to_celltype.stack_id
, image_to_celltype.time_id
, image_to_celltype.microscopy_filter_id
, image_to_celltype.substance_id
, image_to_celltype.name
, image_to_celltype.field_of_view_id
, image_to_celltype.slide_id
, image_to_celltype.experiment_id
, image_to_celltype.protocol_id
, image_to_celltype.cell_name
, image_to_celltype.cell_organism
, tblexperiment.exp_title
, tblexperiment.exp_date
, tblexperiment.researcher_id
, image_to_celltype.stack_description
, image_to_celltype.x_coor
, image_to_celltype.y_coor 
FROM image_to_celltype
, tblexperiment 
WHERE (image_to_celltype.experiment_id = tblexperiment.experiment_id);

Index - Schema public

View: image_to_fieldview

image_to_fieldview Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT image_to_time.image_id
, image_to_time.image_url
, image_to_time.stack_pos
, image_to_time.x_dim
, image_to_time.y_dim
, image_to_time.z_coor
, image_to_time.stack_id
, image_to_time.time_id
, image_to_time.microscopy_filter_id
, image_to_time.substance_id
, image_to_time.name
, image_to_time.field_of_view_id
, tblfield_of_view.slide_id
, image_to_time.stack_description
, tblfield_of_view.x_coor
, tblfield_of_view.y_coor 
FROM image_to_time
, tblfield_of_view 
WHERE (image_to_time.field_of_view_id = tblfield_of_view.field_of_view_id);

Index - Schema public

View: image_to_lab

image_to_lab Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
label_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
lab_name character varying(30)
lab_address character varying(150)
lab_email_add character varying(30)
lab_phone_num character varying(30)
protocol_title character varying(100)
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT image_to_slidelabel.image_id
, image_to_slidelabel.image_url
, image_to_slidelabel.stack_pos
, image_to_slidelabel.x_dim
, image_to_slidelabel.y_dim
, image_to_slidelabel.z_coor
, image_to_slidelabel.stack_id
, image_to_slidelabel.time_id
, image_to_slidelabel.microscopy_filter_id
, image_to_slidelabel.substance_id
, image_to_slidelabel.name
, image_to_slidelabel.field_of_view_id
, image_to_slidelabel.slide_id
, image_to_slidelabel.experiment_id
, image_to_slidelabel.protocol_id
, image_to_slidelabel.label_id
, image_to_slidelabel.cell_name
, image_to_slidelabel.cell_organism
, image_to_slidelabel.exp_title
, image_to_slidelabel.exp_date
, image_to_slidelabel.researcher_name
, image_to_slidelabel.researcher_email_add
, image_to_slidelabel.researcher_phone_num
, image_to_slidelabel.laboratory_id
, tbllaboratory.lab_name
, tbllaboratory.lab_address
, tbllaboratory.lab_email_add
, tbllaboratory.lab_phone_num
, image_to_slidelabel.protocol_title
, image_to_slidelabel.stack_description
, image_to_slidelabel.x_coor
, image_to_slidelabel.y_coor 
FROM image_to_slidelabel
, tbllaboratory 
WHERE (image_to_slidelabel.laboratory_id = tbllaboratory.laboratory_id);

Index - Schema public

View: image_to_protocol

image_to_protocol Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
protocol_title character varying(100)
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT image_to_researcher.image_id
, image_to_researcher.image_url
, image_to_researcher.stack_pos
, image_to_researcher.x_dim
, image_to_researcher.y_dim
, image_to_researcher.z_coor
, image_to_researcher.stack_id
, image_to_researcher.time_id
, image_to_researcher.microscopy_filter_id
, image_to_researcher.substance_id
, image_to_researcher.name
, image_to_researcher.field_of_view_id
, image_to_researcher.slide_id
, image_to_researcher.experiment_id
, image_to_researcher.protocol_id
, image_to_researcher.cell_name
, image_to_researcher.cell_organism
, image_to_researcher.exp_title
, image_to_researcher.exp_date
, image_to_researcher.researcher_name
, image_to_researcher.researcher_email_add
, image_to_researcher.researcher_phone_num
, image_to_researcher.laboratory_id
, tblprotocol.protocol_title
, image_to_researcher.stack_description
, image_to_researcher.x_coor
, image_to_researcher.y_coor 
FROM image_to_researcher
, tblprotocol 
WHERE (image_to_researcher.protocol_id = tblprotocol.protocol_id);

Index - Schema public

View: image_to_researcher

image_to_researcher Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_id integer
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT image_to_experiment.image_id
, image_to_experiment.image_url
, image_to_experiment.stack_pos
, image_to_experiment.x_dim
, image_to_experiment.y_dim
, image_to_experiment.z_coor
, image_to_experiment.stack_id
, image_to_experiment.time_id
, image_to_experiment.microscopy_filter_id
, image_to_experiment.substance_id
, image_to_experiment.name
, image_to_experiment.field_of_view_id
, image_to_experiment.slide_id
, image_to_experiment.experiment_id
, image_to_experiment.protocol_id
, image_to_experiment.cell_name
, image_to_experiment.cell_organism
, image_to_experiment.exp_title
, image_to_experiment.exp_date
, image_to_experiment.researcher_id
, tblresearcher.researcher_name
, tblresearcher.researcher_email_add
, tblresearcher.researcher_phone_num
, tblresearcher.laboratory_id
, image_to_experiment.stack_description
, image_to_experiment.x_coor
, image_to_experiment.y_coor 
FROM image_to_experiment
, tblresearcher 
WHERE (image_to_experiment.researcher_id = tblresearcher.researcher_id);

Index - Schema public

View: image_to_slide

image_to_slide Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
cell_type_id integer
experiment_id integer
protocol_id integer
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT image_to_fieldview.image_id
, image_to_fieldview.image_url
, image_to_fieldview.stack_pos
, image_to_fieldview.x_dim
, image_to_fieldview.y_dim
, image_to_fieldview.z_coor
, image_to_fieldview.stack_id
, image_to_fieldview.time_id
, image_to_fieldview.microscopy_filter_id
, image_to_fieldview.substance_id
, image_to_fieldview.name
, image_to_fieldview.field_of_view_id
, image_to_fieldview.slide_id
, tblslide.cell_type_id
, tblslide.experiment_id
, tblslide.protocol_id
, image_to_fieldview.stack_description
, image_to_fieldview.x_coor
, image_to_fieldview.y_coor 
FROM image_to_fieldview
, tblslide 
WHERE (image_to_fieldview.slide_id = tblslide.slide_id);

Index - Schema public

View: image_to_slidelabel

image_to_slidelabel Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
label_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
protocol_title character varying(100)
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT image_to_protocol.image_id
, image_to_protocol.image_url
, image_to_protocol.stack_pos
, image_to_protocol.x_dim
, image_to_protocol.y_dim
, image_to_protocol.z_coor
, image_to_protocol.stack_id
, image_to_protocol.time_id
, image_to_protocol.microscopy_filter_id
, image_to_protocol.substance_id
, image_to_protocol.name
, image_to_protocol.field_of_view_id
, image_to_protocol.slide_id
, image_to_protocol.experiment_id
, image_to_protocol.protocol_id
, tblslide_label.label_id
, image_to_protocol.cell_name
, image_to_protocol.cell_organism
, image_to_protocol.exp_title
, image_to_protocol.exp_date
, image_to_protocol.researcher_name
, image_to_protocol.researcher_email_add
, image_to_protocol.researcher_phone_num
, image_to_protocol.laboratory_id
, image_to_protocol.protocol_title
, image_to_protocol.stack_description
, image_to_protocol.x_coor
, image_to_protocol.y_coor 
FROM image_to_protocol
, tblslide_label 
WHERE (image_to_protocol.slide_id = tblslide_label.slide_id);

Index - Schema public

View: image_to_stack

image_to_stack Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
target_id integer
stack_description character varying(50) 
SELECT tblimage.image_id
, tblimage.image_url
, tblimage.stack_pos
, tblimage.x_dim
, tblimage.y_dim
, tblimage.z_coor
, tblimage.stack_id
, tblstack.time_id
, tblstack.microscopy_filter_id
, tblstack.target_id
, tblstack.stack_description 
FROM tblimage
, tblstack 
WHERE (tblimage.stack_id = tblstack.stack_id);

Index - Schema public

View: image_to_substance

image_to_substance Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
stack_description character varying(50) 
SELECT image_to_stack.image_id
, image_to_stack.image_url
, image_to_stack.stack_pos
, image_to_stack.x_dim
, image_to_stack.y_dim
, image_to_stack.z_coor
, image_to_stack.stack_id
, image_to_stack.time_id
, image_to_stack.microscopy_filter_id
, tblsubstance.substance_id
, tblsubstance.name
, image_to_stack.stack_description 
FROM tblsubstance
, image_to_stack 
WHERE (image_to_stack.target_id = tblsubstance.substance_id);

Index - Schema public

View: image_to_time

image_to_time Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
stack_description character varying(50) 
SELECT image_to_substance.image_id
, image_to_substance.image_url
, image_to_substance.stack_pos
, image_to_substance.x_dim
, image_to_substance.y_dim
, image_to_substance.z_coor
, image_to_substance.stack_id
, image_to_substance.time_id
, image_to_substance.microscopy_filter_id
, image_to_substance.substance_id
, image_to_substance.name
, tbltime.field_of_view_id
, image_to_substance.stack_description 
FROM image_to_substance
, tbltime 
WHERE (image_to_substance.time_id = tbltime.time_id);

Index - Schema public

View: image_with_region_mf

image_with_region_mf Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
mask_url character varying(120)
mask_x_dim integer
mask_y_dim integer
stack_id integer
substance_id integer
time_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
label_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
lab_name character varying(30)
lab_address character varying(150)
lab_email_add character varying(30)
lab_phone_num character varying(30)
protocol_title character varying(100)
microscopy_filter_id integer
microscopy_id integer
microscopy_name character varying(60)
objective_name character varying(60)
objective_id integer
detector_name character varying(60)
detector_id integer
condenser_name character varying(60)
illumination_name character varying(60)
microscope_name character varying(60)
ex_filter_id integer
excitation_filter_angle double precision
em_filter_id integer
emission_filter_angle double precision
stack_description character varying(50)
x_coor double precision
y_coor double precision
region_id integer
region_generator_id integer
parameter character varying(200)
segmenter character varying(100)
generate_time timestamp without time zone 
SELECT image_mf.image_id
, image_mf.image_url
, image_mf.stack_pos
, image_mf.x_dim
, image_mf.y_dim
, image_mf.z_coor
, tblmask.mask_url
, tblmask.mask_x_dim
, tblmask.mask_y_dim
, image_mf.stack_id
, image_mf.substance_id
, image_mf.time_id
, image_mf.name
, image_mf.field_of_view_id
, image_mf.slide_id
, image_mf.experiment_id
, image_mf.protocol_id
, image_mf.label_id
, image_mf.cell_name
, image_mf.cell_organism
, image_mf.exp_title
, image_mf.exp_date
, image_mf.researcher_name
, image_mf.researcher_email_add
, image_mf.researcher_phone_num
, image_mf.laboratory_id
, image_mf.lab_name
, image_mf.lab_address
, image_mf.lab_email_add
, image_mf.lab_phone_num
, image_mf.protocol_title
, image_mf.microscopy_filter_id
, image_mf.microscopy_id
, image_mf.microscopy_name
, image_mf.objective_name
, image_mf.objective_id
, image_mf.detector_name
, image_mf.detector_id
, image_mf.condenser_name
, image_mf.illumination_name
, image_mf.microscope_name
, image_mf.ex_filter_id
, image_mf.excitation_filter_angle
, image_mf.em_filter_id
, image_mf.emission_filter_angle
, image_mf.stack_description
, image_mf.x_coor
, image_mf.y_coor
, tblregion.region_id
, tblregion_generator.region_generator_id
, tblregion_generator.parameter
, tblregion_generator.segmenter
, tblregion_generator.generate_time 
FROM image_mf
, tblregion
, tblmask
, tblregion_generator 
WHERE (
     (
           (image_mf.image_id = tblregion.image_id)
         AND (tblregion.mask_id = tblmask.mask_id)
     )
   AND (tblregion_generator.region_generator_id = tblmask.generator_id)
);

Index - Schema public

View: mf_microscopy

mf_microscopy Structure
F-Key Name Type Description
microscopy_id integer
microscopy_name character varying(60)
objective_name character varying(60)
detector_name character varying(60)
detector_id integer
objective_id integer
condenser_name character varying(60)
illumination_name character varying(60)
microscope_name character varying(60)
microscopy_filter_id integer
ex_filter_id integer
excitation_filter_angle double precision
em_filter_id integer
emission_filter_angle double precision 
SELECT microscopy_all.microscopy_id
, microscopy_all.microscopy_name
, microscopy_all.objective_name
, microscopy_all.detector_name
, microscopy_all.detector_id
, microscopy_all.objective_id
, microscopy_all.condenser_name
, microscopy_all.illumination_name
, microscopy_all.microscope_name
, tblmicroscopy_filter.microscopy_filter_id
, tblmicroscopy_filter.ex_filter_id
, tblmicroscopy_filter.excitation_filter_angle
, tblmicroscopy_filter.em_filter_id
, tblmicroscopy_filter.emission_filter_angle 
FROM microscopy_all
, tblmicroscopy_filter 
WHERE (microscopy_all.microscopy_id = tblmicroscopy_filter.microscopy_id);

Index - Schema public

View: microscopy_all

microscopy_all Structure
F-Key Name Type Description
microscopy_id integer
microscopy_name character varying(60)
objective_name character varying(60)
objective_id integer
detector_name character varying(60)
detector_id integer
condenser_name character varying(60)
illumination_name character varying(60)
microscope_name character varying(60) 
SELECT tblmicroscopy.microscopy_id
, tblmicroscopy.microscopy_name
, tblobjective.objective_name
, tblobjective.objective_id
, tbldetector.detector_name
, tbldetector.detector_id
, tblcondenser.condenser_name
, tblillumination.illumination_name
, tblmicroscope.microscope_name 
FROM tblmicroscopy
, tblobjective
, tbldetector
, tblcondenser
, tblillumination
, tblmicroscope 
WHERE (
     (
           (
                 (
                       (tblmicroscopy.objective_id = tblobjective.objective_id)
                     AND (tblmicroscopy.detector_id = tbldetector.detector_id)
                 )
               AND (tblmicroscopy.condenser_id = tblcondenser.condenser_id)
           )
         AND (tblmicroscopy.illumination_id = tblillumination.illumination_id)
     )
   AND (tblmicroscopy.microscope_id = tblmicroscope.microscope_id)
);

Index - Schema public

View: stack_mf

stack_mf Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
label_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
lab_name character varying(30)
lab_address character varying(150)
lab_email_add character varying(30)
lab_phone_num character varying(30)
protocol_title character varying(100)
microscopy_filter_id integer
microscopy_id integer
microscopy_name character varying(60)
objective_name character varying(60)
objective_id integer
detector_name character varying(60)
detector_id integer
condenser_name character varying(60)
illumination_name character varying(60)
microscope_name character varying(60)
ex_filter_id integer
excitation_filter_angle double precision
em_filter_id integer
emission_filter_angle double precision
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT stack_to_lab.image_id
, stack_to_lab.image_url
, stack_to_lab.stack_pos
, stack_to_lab.x_dim
, stack_to_lab.y_dim
, stack_to_lab.z_coor
, stack_to_lab.stack_id
, stack_to_lab.time_id
, stack_to_lab.substance_id
, stack_to_lab.name
, stack_to_lab.field_of_view_id
, stack_to_lab.slide_id
, stack_to_lab.experiment_id
, stack_to_lab.protocol_id
, stack_to_lab.label_id
, stack_to_lab.cell_name
, stack_to_lab.cell_organism
, stack_to_lab.exp_title
, stack_to_lab.exp_date
, stack_to_lab.researcher_name
, stack_to_lab.researcher_email_add
, stack_to_lab.researcher_phone_num
, stack_to_lab.laboratory_id
, stack_to_lab.lab_name
, stack_to_lab.lab_address
, stack_to_lab.lab_email_add
, stack_to_lab.lab_phone_num
, stack_to_lab.protocol_title
, stack_to_lab.microscopy_filter_id
, mf_microscopy.microscopy_id
, mf_microscopy.microscopy_name
, mf_microscopy.objective_name
, mf_microscopy.objective_id
, mf_microscopy.detector_name
, mf_microscopy.detector_id
, mf_microscopy.condenser_name
, mf_microscopy.illumination_name
, mf_microscopy.microscope_name
, mf_microscopy.ex_filter_id
, mf_microscopy.excitation_filter_angle
, mf_microscopy.em_filter_id
, mf_microscopy.emission_filter_angle
, stack_to_lab.stack_description
, stack_to_lab.x_coor
, stack_to_lab.y_coor 
FROM stack_to_lab
, mf_microscopy 
WHERE (stack_to_lab.microscopy_filter_id = mf_microscopy.microscopy_filter_id);

Index - Schema public

View: stack_to_celltype

stack_to_celltype Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
cell_type_id integer
experiment_id integer
protocol_id integer
cell_name character varying(30)
cell_organism character varying(30)
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT stack_to_slide.image_id
, stack_to_slide.image_url
, stack_to_slide.stack_pos
, stack_to_slide.x_dim
, stack_to_slide.y_dim
, stack_to_slide.z_coor
, stack_to_slide.stack_id
, stack_to_slide.time_id
, stack_to_slide.microscopy_filter_id
, stack_to_slide.substance_id
, stack_to_slide.name
, stack_to_slide.field_of_view_id
, stack_to_slide.slide_id
, stack_to_slide.cell_type_id
, stack_to_slide.experiment_id
, stack_to_slide.protocol_id
, tblcell_type.cell_name
, tblcell_type.cell_organism
, stack_to_slide.stack_description
, stack_to_slide.x_coor
, stack_to_slide.y_coor 
FROM stack_to_slide
, tblcell_type 
WHERE (stack_to_slide.cell_type_id = tblcell_type.cell_type_id);

Index - Schema public

View: stack_to_experiment

stack_to_experiment Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_id integer
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT stack_to_celltype.image_id
, stack_to_celltype.image_url
, stack_to_celltype.stack_pos
, stack_to_celltype.x_dim
, stack_to_celltype.y_dim
, stack_to_celltype.z_coor
, stack_to_celltype.stack_id
, stack_to_celltype.time_id
, stack_to_celltype.microscopy_filter_id
, stack_to_celltype.substance_id
, stack_to_celltype.name
, stack_to_celltype.field_of_view_id
, stack_to_celltype.slide_id
, stack_to_celltype.experiment_id
, stack_to_celltype.protocol_id
, stack_to_celltype.cell_name
, stack_to_celltype.cell_organism
, tblexperiment.exp_title
, tblexperiment.exp_date
, tblexperiment.researcher_id
, stack_to_celltype.stack_description
, stack_to_celltype.x_coor
, stack_to_celltype.y_coor 
FROM stack_to_celltype
, tblexperiment 
WHERE (stack_to_celltype.experiment_id = tblexperiment.experiment_id);

Index - Schema public

View: stack_to_fieldview

stack_to_fieldview Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT stack_to_time.image_id
, stack_to_time.image_url
, stack_to_time.stack_pos
, stack_to_time.x_dim
, stack_to_time.y_dim
, stack_to_time.z_coor
, stack_to_time.stack_id
, stack_to_time.time_id
, stack_to_time.microscopy_filter_id
, stack_to_time.substance_id
, stack_to_time.name
, stack_to_time.field_of_view_id
, tblfield_of_view.slide_id
, stack_to_time.stack_description
, tblfield_of_view.x_coor
, tblfield_of_view.y_coor 
FROM stack_to_time
, tblfield_of_view 
WHERE (stack_to_time.field_of_view_id = tblfield_of_view.field_of_view_id);

Index - Schema public

View: stack_to_image

stack_to_image Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
target_id integer
stack_description character varying(50) 
SELECT tblimage.image_id
, tblimage.image_url
, tblimage.stack_pos
, tblimage.x_dim
, tblimage.y_dim
, tblimage.z_coor
, tblstack.stack_id
, tblstack.time_id
, tblstack.microscopy_filter_id
, tblstack.target_id
, tblstack.stack_description 
FROM tblstack
, tblimage 
WHERE (tblstack.stack_id = tblimage.stack_id);

Index - Schema public

View: stack_to_lab

stack_to_lab Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
label_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
lab_name character varying(30)
lab_address character varying(150)
lab_email_add character varying(30)
lab_phone_num character varying(30)
protocol_title character varying(100)
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT stack_to_label.image_id
, stack_to_label.image_url
, stack_to_label.stack_pos
, stack_to_label.x_dim
, stack_to_label.y_dim
, stack_to_label.z_coor
, stack_to_label.stack_id
, stack_to_label.time_id
, stack_to_label.microscopy_filter_id
, stack_to_label.substance_id
, stack_to_label.name
, stack_to_label.field_of_view_id
, stack_to_label.slide_id
, stack_to_label.experiment_id
, stack_to_label.protocol_id
, stack_to_label.label_id
, stack_to_label.cell_name
, stack_to_label.cell_organism
, stack_to_label.exp_title
, stack_to_label.exp_date
, stack_to_label.researcher_name
, stack_to_label.researcher_email_add
, stack_to_label.researcher_phone_num
, stack_to_label.laboratory_id
, tbllaboratory.lab_name
, tbllaboratory.lab_address
, tbllaboratory.lab_email_add
, tbllaboratory.lab_phone_num
, stack_to_label.protocol_title
, stack_to_label.stack_description
, stack_to_label.x_coor
, stack_to_label.y_coor 
FROM stack_to_label
, tbllaboratory 
WHERE (stack_to_label.laboratory_id = tbllaboratory.laboratory_id);

Index - Schema public

View: stack_to_label

stack_to_label Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
label_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
protocol_title character varying(100)
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT stack_to_protocol.image_id
, stack_to_protocol.image_url
, stack_to_protocol.stack_pos
, stack_to_protocol.x_dim
, stack_to_protocol.y_dim
, stack_to_protocol.z_coor
, stack_to_protocol.stack_id
, stack_to_protocol.time_id
, stack_to_protocol.microscopy_filter_id
, stack_to_protocol.substance_id
, stack_to_protocol.name
, stack_to_protocol.field_of_view_id
, stack_to_protocol.slide_id
, stack_to_protocol.experiment_id
, stack_to_protocol.protocol_id
, tblslide_label.label_id
, stack_to_protocol.cell_name
, stack_to_protocol.cell_organism
, stack_to_protocol.exp_title
, stack_to_protocol.exp_date
, stack_to_protocol.researcher_name
, stack_to_protocol.researcher_email_add
, stack_to_protocol.researcher_phone_num
, stack_to_protocol.laboratory_id
, stack_to_protocol.protocol_title
, stack_to_protocol.stack_description
, stack_to_protocol.x_coor
, stack_to_protocol.y_coor 
FROM stack_to_protocol
, tblslide_label 
WHERE (stack_to_protocol.slide_id = tblslide_label.slide_id);

Index - Schema public

View: stack_to_protocol

stack_to_protocol Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
protocol_title character varying(100)
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT stack_to_researcher.image_id
, stack_to_researcher.image_url
, stack_to_researcher.stack_pos
, stack_to_researcher.x_dim
, stack_to_researcher.y_dim
, stack_to_researcher.z_coor
, stack_to_researcher.stack_id
, stack_to_researcher.time_id
, stack_to_researcher.microscopy_filter_id
, stack_to_researcher.substance_id
, stack_to_researcher.name
, stack_to_researcher.field_of_view_id
, stack_to_researcher.slide_id
, stack_to_researcher.experiment_id
, stack_to_researcher.protocol_id
, stack_to_researcher.cell_name
, stack_to_researcher.cell_organism
, stack_to_researcher.exp_title
, stack_to_researcher.exp_date
, stack_to_researcher.researcher_name
, stack_to_researcher.researcher_email_add
, stack_to_researcher.researcher_phone_num
, stack_to_researcher.laboratory_id
, tblprotocol.protocol_title
, stack_to_researcher.stack_description
, stack_to_researcher.x_coor
, stack_to_researcher.y_coor 
FROM stack_to_researcher
, tblprotocol 
WHERE (stack_to_researcher.protocol_id = tblprotocol.protocol_id);

Index - Schema public

View: stack_to_researcher

stack_to_researcher Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_id integer
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT stack_to_experiment.image_id
, stack_to_experiment.image_url
, stack_to_experiment.stack_pos
, stack_to_experiment.x_dim
, stack_to_experiment.y_dim
, stack_to_experiment.z_coor
, stack_to_experiment.stack_id
, stack_to_experiment.time_id
, stack_to_experiment.microscopy_filter_id
, stack_to_experiment.substance_id
, stack_to_experiment.name
, stack_to_experiment.field_of_view_id
, stack_to_experiment.slide_id
, stack_to_experiment.experiment_id
, stack_to_experiment.protocol_id
, stack_to_experiment.cell_name
, stack_to_experiment.cell_organism
, stack_to_experiment.exp_title
, stack_to_experiment.exp_date
, stack_to_experiment.researcher_id
, tblresearcher.researcher_name
, tblresearcher.researcher_email_add
, tblresearcher.researcher_phone_num
, tblresearcher.laboratory_id
, stack_to_experiment.stack_description
, stack_to_experiment.x_coor
, stack_to_experiment.y_coor 
FROM stack_to_experiment
, tblresearcher 
WHERE (stack_to_experiment.researcher_id = tblresearcher.researcher_id);

Index - Schema public

View: stack_to_slide

stack_to_slide Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
cell_type_id integer
experiment_id integer
protocol_id integer
stack_description character varying(50)
x_coor double precision
y_coor double precision 
SELECT stack_to_fieldview.image_id
, stack_to_fieldview.image_url
, stack_to_fieldview.stack_pos
, stack_to_fieldview.x_dim
, stack_to_fieldview.y_dim
, stack_to_fieldview.z_coor
, stack_to_fieldview.stack_id
, stack_to_fieldview.time_id
, stack_to_fieldview.microscopy_filter_id
, stack_to_fieldview.substance_id
, stack_to_fieldview.name
, stack_to_fieldview.field_of_view_id
, stack_to_fieldview.slide_id
, tblslide.cell_type_id
, tblslide.experiment_id
, tblslide.protocol_id
, stack_to_fieldview.stack_description
, stack_to_fieldview.x_coor
, stack_to_fieldview.y_coor 
FROM stack_to_fieldview
, tblslide 
WHERE (stack_to_fieldview.slide_id = tblslide.slide_id);

Index - Schema public

View: stack_to_substance

stack_to_substance Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
stack_description character varying(50) 
SELECT stack_to_image.image_id
, stack_to_image.image_url
, stack_to_image.stack_pos
, stack_to_image.x_dim
, stack_to_image.y_dim
, stack_to_image.z_coor
, stack_to_image.stack_id
, stack_to_image.time_id
, stack_to_image.microscopy_filter_id
, tblsubstance.substance_id
, tblsubstance.name
, stack_to_image.stack_description 
FROM tblsubstance
, stack_to_image 
WHERE (stack_to_image.target_id = tblsubstance.substance_id);

Index - Schema public

View: stack_to_time

stack_to_time Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
stack_id integer
time_id integer
microscopy_filter_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
stack_description character varying(50) 
SELECT stack_to_substance.image_id
, stack_to_substance.image_url
, stack_to_substance.stack_pos
, stack_to_substance.x_dim
, stack_to_substance.y_dim
, stack_to_substance.z_coor
, stack_to_substance.stack_id
, stack_to_substance.time_id
, stack_to_substance.microscopy_filter_id
, stack_to_substance.substance_id
, stack_to_substance.name
, tbltime.field_of_view_id
, stack_to_substance.stack_description 
FROM stack_to_substance
, tbltime 
WHERE (stack_to_substance.time_id = tbltime.time_id);

Index - Schema public

View: stack_with_region_mf

stack_with_region_mf Structure
F-Key Name Type Description
image_id integer
image_url character varying(250)
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision
mask_url character varying(120)
mask_x_dim integer
mask_y_dim integer
stack_id integer
time_id integer
substance_id integer
name character varying(500)
field_of_view_id integer
slide_id integer
experiment_id integer
protocol_id integer
label_id integer
cell_name character varying(30)
cell_organism character varying(30)
exp_title character varying(30)
exp_date character varying(30)
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)
laboratory_id integer
lab_name character varying(30)
lab_address character varying(150)
lab_email_add character varying(30)
lab_phone_num character varying(30)
protocol_title character varying(100)
microscopy_filter_id integer
microscopy_id integer
microscopy_name character varying(60)
objective_name character varying(60)
objective_id integer
detector_name character varying(60)
detector_id integer
condenser_name character varying(60)
illumination_name character varying(60)
microscope_name character varying(60)
ex_filter_id integer
excitation_filter_angle double precision
em_filter_id integer
emission_filter_angle double precision
stack_description character varying(50)
x_coor double precision
y_coor double precision
thrdregion_id integer
region_generator_id integer
parameter character varying(200)
segmenter character varying(100)
generate_time timestamp without time zone 
SELECT stack_mf.image_id
, stack_mf.image_url
, stack_mf.stack_pos
, stack_mf.x_dim
, stack_mf.y_dim
, stack_mf.z_coor
, tblmask.mask_url
, tblmask.mask_x_dim
, tblmask.mask_y_dim
, stack_mf.stack_id
, stack_mf.time_id
, stack_mf.substance_id
, stack_mf.name
, stack_mf.field_of_view_id
, stack_mf.slide_id
, stack_mf.experiment_id
, stack_mf.protocol_id
, stack_mf.label_id
, stack_mf.cell_name
, stack_mf.cell_organism
, stack_mf.exp_title
, stack_mf.exp_date
, stack_mf.researcher_name
, stack_mf.researcher_email_add
, stack_mf.researcher_phone_num
, stack_mf.laboratory_id
, stack_mf.lab_name
, stack_mf.lab_address
, stack_mf.lab_email_add
, stack_mf.lab_phone_num
, stack_mf.protocol_title
, stack_mf.microscopy_filter_id
, stack_mf.microscopy_id
, stack_mf.microscopy_name
, stack_mf.objective_name
, stack_mf.objective_id
, stack_mf.detector_name
, stack_mf.detector_id
, stack_mf.condenser_name
, stack_mf.illumination_name
, stack_mf.microscope_name
, stack_mf.ex_filter_id
, stack_mf.excitation_filter_angle
, stack_mf.em_filter_id
, stack_mf.emission_filter_angle
, stack_mf.stack_description
, stack_mf.x_coor
, stack_mf.y_coor
, tbl3dregion.thrdregion_id
, tblregion_generator.region_generator_id
, tblregion_generator.parameter
, tblregion_generator.segmenter
, tblregion_generator.generate_time 
FROM stack_mf
, tbl3dregion
, tblmask
, tblregion_generator 
WHERE (
     (
           (stack_mf.stack_id = tbl3dregion.stack_id)
         AND (tbl3dregion.mask_id = tblmask.mask_id)
     )
   AND (tblregion_generator.region_generator_id = tblmask.generator_id)
);

Index - Schema public

Table: tbl3dregion

tbl3dregion Structure
F-Key Name Type Description
thrdregion_id integer PRIMARY KEY DEFAULT nextval('thrdregion_seq'::regclass)
tblstack.stack_id stack_id integer
tblmask.mask_id mask_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tbl3dregion_sets

tbl3dregion_sets Structure
F-Key Name Type Description
set_id integer PRIMARY KEY DEFAULT nextval('thrdregionsets_seq'::regclass)
set_name character varying(100)
tbl3dregion.thrdregion_id thrdregion_id integer
removable integer
set_type integer
lock integer
timestamp character varying(30)
session character varying(40)
dbuser text

Index - Schema public

Table: tblcell_type

tblcell_type Structure
F-Key Name Type Description
cell_type_id integer PRIMARY KEY DEFAULT nextval('cell_seq'::regclass)
cell_name character varying(30)
cell_organism character varying(30)
atcc_number character varying(60)
cell_mesh_heading character varying(60)
cell_mesh_tree_number character varying(60)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblclassification

tblclassification Structure
F-Key Name Type Description
image_id integer
tblclassifier.classifier_id classifier_id integer
classified_prob double precision
class_index integer

Index - Schema public

Table: tblclassifier

tblclassifier Structure
F-Key Name Type Description
classifier_name character varying(100)
class_index integer
set_class_name character varying(100)
user_class_name character varying(100)
featureset_name character varying(100)
set_type integer
removable integer
lock integer
timestamp character varying(30)
session character varying(40)
classifier_id integer PRIMARY KEY DEFAULT nextval('classifier_seq'::regclass)
classifier_type integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblcondenser

tblcondenser Structure
F-Key Name Type Description
condenser_id integer PRIMARY KEY DEFAULT nextval('condenser_seq'::regclass)
condenser_name character varying(60)
cond_manufacturer character varying(60)
cond_model character varying(60)
cond_serial_number character varying(30)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tbldbuser

tbldbuser Structure
F-Key Name Type Description
username text
password text
matlabusertype text
accounttype text

Index - Schema public

Table: tbldetector

tbldetector Structure
F-Key Name Type Description
detector_id integer PRIMARY KEY DEFAULT nextval('detector_seq'::regclass)
detector_name character varying(60)
det_type character varying(30)
det_manufacturer character varying(30)
det_model character varying(30)
det_gain double precision
det_voltage double precision
det_offset double precision
det_x_res double precision
det_y_res double precision
det_bit_depth integer
det_serial_number character varying(30)
det_processing character varying(300)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tbldouble_3dregion_feature_values

tbldouble_3dregion_feature_values Structure
F-Key Name Type Description
double_3dregion_feature_values_id integer PRIMARY KEY DEFAULT nextval('d3dregfeat_seq'::regclass)
tbl3dregion.thrdregion_id thrdregion_id1 integer UNIQUE#1
tbl3dregion.thrdregion_id thrdregion_id2 integer UNIQUE#1
tblfeature.feature_id feature_id integer UNIQUE#1
d3_value double precision

Index - Schema public

Table: tbldouble_image_feature_values

tbldouble_image_feature_values Structure
F-Key Name Type Description
double_image_feature_values_id integer PRIMARY KEY DEFAULT nextval('dimagefeat_seq'::regclass)
tblimage.image_id image_id1 integer UNIQUE#1
tblimage.image_id image_id2 integer UNIQUE#1
tblfeature.feature_id feature_id integer UNIQUE#1
di_value double precision

Index - Schema public

Table: tbldouble_region_feature_values

tbldouble_region_feature_values Structure
F-Key Name Type Description
double_region_feature_values_id integer PRIMARY KEY DEFAULT nextval('dregionfeat_seq'::regclass)
tblregion.region_id region_id1 integer UNIQUE#1
tblregion.region_id region_id2 integer UNIQUE#1
tblfeature.feature_id feature_id integer UNIQUE#1
dr_value double precision

Index - Schema public

Table: tbldouble_stack_feature_values

tbldouble_stack_feature_values Structure
F-Key Name Type Description
double_stack_feature_values_id integer PRIMARY KEY DEFAULT nextval('dstackfeat_seq'::regclass)
tblstack.stack_id stack_id1 integer UNIQUE#1
tblstack.stack_id stack_id2 integer UNIQUE#1
tblfeature.feature_id feature_id integer UNIQUE#1
ds_value double precision

Index - Schema public

Table: tbldye

tbldye Structure
F-Key Name Type Description
dye_id integer PRIMARY KEY DEFAULT nextval('dye_seq'::regclass)
dye_name character varying(30)
dye_mesh_heading character varying(60)
excitation_max integer
emission_max integer
tblsupplier.supplier_id supplier_id integer
supplier_part_number integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblexperiment

tblexperiment Structure
F-Key Name Type Description
experiment_id integer PRIMARY KEY DEFAULT nextval('exp_seq'::regclass)
tblresearcher.researcher_id researcher_id integer
exp_title character varying(30)
exp_date character varying(30)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblfeature

tblfeature Structure
F-Key Name Type Description
feature_id integer PRIMARY KEY DEFAULT nextval('feature_seq'::regclass)
feature_name character varying(80)
feature_description character varying(100)
num_dimensions integer
num_channels integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblfeatureset

tblfeatureset Structure
F-Key Name Type Description
featureset_name character varying(100)
set_index integer
tblfeature.feature_id feature_id integer
set_type integer

Index - Schema public

Table: tblfield_of_view

tblfield_of_view Structure
F-Key Name Type Description
field_of_view_id integer PRIMARY KEY DEFAULT nextval('fv_seq'::regclass)
tblslide.slide_id slide_id integer
x_coor double precision
y_coor double precision
nslice integer
ncolor integer
ntime integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblfilter

tblfilter Structure
F-Key Name Type Description
filter_id integer PRIMARY KEY DEFAULT nextval('filter_seq'::regclass)
filter_name character varying(60)
fi_pass_type character varying(60)
fi_upper integer
fi_lower integer
fi_thickness double precision
fi_spectrum character varying(300)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblillumination

tblillumination Structure
F-Key Name Type Description
illumination_id integer PRIMARY KEY DEFAULT nextval('illumination_seq'::regclass)
illumination_name character varying(60)
il_type character varying(60)
il_manufacturer character varying(60)
il_model character varying(60)
il_serial_number character varying(30)
il_spectrum character varying(300)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblimage

tblimage Structure
F-Key Name Type Description
image_id integer PRIMARY KEY DEFAULT nextval('image_seq'::regclass)
tblstack.stack_id stack_id integer
image_url character varying(250) NOT NULL
stack_pos integer
x_dim integer
y_dim integer
z_coor double precision

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblimage_sets

tblimage_sets Structure
F-Key Name Type Description
set_id integer
set_name character varying(100)
image_id integer
removable integer
set_type integer
lock integer
timestamp character varying(30)
session character varying(40)
dbuser text

Index - Schema public

Table: tblimage_sets_temp

tblimage_sets_temp Structure
F-Key Name Type Description
set_id integer
set_name character varying(100)
image_id integer
removable integer
set_type integer
lock integer
timestamp character varying(30)
session character varying(40)
dbuser text

Index - Schema public

Table: tbllabel

tbllabel Structure
F-Key Name Type Description
label_id integer PRIMARY KEY DEFAULT nextval('label_seq'::regclass)
tbldye.dye_id dye_id integer
label_name character varying(400)
tblsubstance.substance_id target_id integer
tblsubstance.substance_id ligand_class_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tbllaboratory

tbllaboratory Structure
F-Key Name Type Description
laboratory_id integer PRIMARY KEY DEFAULT nextval('lab_seq'::regclass)
lab_name character varying(30)
lab_address character varying(150)
lab_email_add character varying(30)
lab_phone_num character varying(30)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tbllocationclass

tbllocationclass Structure
F-Key Name Type Description

Index - Schema public

Table: tblmask

tblmask Structure
F-Key Name Type Description
mask_id integer PRIMARY KEY DEFAULT nextval('mask_seq'::regclass)
mask_url character varying(120)
mask_x_dim integer
mask_y_dim integer
tblregion_generator.region_generator_id generator_id integer
generate_count integer
removable integer
session character varying(40)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblmicroscope

tblmicroscope Structure
F-Key Name Type Description
microscope_id integer PRIMARY KEY DEFAULT nextval('microscope_seq'::regclass)
microscope_name character varying(60)
mi_manufacturer character varying(60)
mi_model character varying(60)
mi_serial_number character varying(30)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblmicroscopy

tblmicroscopy Structure
F-Key Name Type Description
microscopy_id integer PRIMARY KEY DEFAULT nextval('microscopy_seq'::regclass)
tblobjective.objective_id objective_id integer
tbldetector.detector_id detector_id integer
tblcondenser.condenser_id condenser_id integer
tblillumination.illumination_id illumination_id integer
tblmicroscope.microscope_id microscope_id integer
exposure_time character varying(30)
microscopy_name character varying(60)
emission_magnification double precision

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblmicroscopy_filter

tblmicroscopy_filter Structure
F-Key Name Type Description
microscopy_filter_id integer PRIMARY KEY DEFAULT nextval('mf_seq'::regclass)
tblmicroscopy.microscopy_id microscopy_id integer
tblfilter.filter_id ex_filter_id integer
excitation_filter_angle double precision
tblfilter.filter_id em_filter_id integer
emission_filter_angle double precision

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblobjective

tblobjective Structure
F-Key Name Type Description
objective_id integer PRIMARY KEY DEFAULT nextval('obj_seq'::regclass)
objective_name character varying(60)
obj_manufacturer character varying(60)
obj_model character varying(60)
obj_magnification integer
obj_num_app double precision
obj_serial_number character varying(30)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblprotocol

tblprotocol Structure
F-Key Name Type Description
protocol_id integer PRIMARY KEY DEFAULT nextval('protocol_seq'::regclass)
protocol_title character varying(100)
protocol_author character varying(100)
protocol_reference character varying(300)
fixation character varying(100)
permeabilization character varying(100)
substrate character varying(100)
temperature double precision
protocol_text character varying(3000)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblpslid_info

tblpslid_info Structure
F-Key Name Type Description
version character varying(20)
date character varying(20)
script character varying(50)
db_timestamp character varying(30)

Index - Schema public

Table: tblregion

tblregion Structure
F-Key Name Type Description
region_id integer PRIMARY KEY DEFAULT nextval('region_seq'::regclass)
tblimage.image_id image_id integer
tblmask.mask_id mask_id integer
x_coor integer
y_coor integer
removable integer
session character varying(40)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblregion_generator

tblregion_generator Structure
F-Key Name Type Description
region_generator_id integer PRIMARY KEY DEFAULT nextval('reggen_seq'::regclass)
segmenter character varying(100)
parameter character varying(200)
generate_time timestamp without time zone
removable integer
session character varying(40)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblregion_sets

tblregion_sets Structure
F-Key Name Type Description
set_id integer PRIMARY KEY DEFAULT nextval('regionsets_seq'::regclass)
set_name character varying(100)
tblregion.region_id region_id integer
removable integer
set_type integer
lock integer
timestamp character varying(30)
session character varying(40)
dbuser text

Index - Schema public

Table: tblresearcher

tblresearcher Structure
F-Key Name Type Description
researcher_id integer PRIMARY KEY DEFAULT nextval('researcher_seq'::regclass)
tbllaboratory.laboratory_id laboratory_id integer
researcher_name character varying(30)
researcher_email_add character varying(30)
researcher_phone_num character varying(30)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblsequencing_info

tblsequencing_info Structure
F-Key Name Type Description
seq_id integer PRIMARY KEY DEFAULT nextval('sequencing_seq'::regclass)
tblcell_type.cell_type_id cell_type_id integer
direction character varying(10)
enzyme character varying(20)
trace_file character varying(25)
hit character varying(100)
gene character varying(50)
sequence character varying(1500)
seq_date date
ensemble character varying(50)
code character varying(50)
matches character varying(50)
match_code character varying(50)
chr_info character varying(50)
seq_info character varying(250)
intron character varying(30)

Index - Schema public

Table: tblsession_log

tblsession_log Structure
F-Key Name Type Description
id text PRIMARY KEY
username text NOT NULL
client_name text
ip_address character varying(15) NOT NULL
started timestamp without time zone PRIMARY KEY DEFAULT now()
ended timestamp without time zone

Index - Schema public

Table: tblsets

tblsets Structure
F-Key Name Type Description
set_id integer PRIMARY KEY DEFAULT nextval('sets_seq'::regclass)
set_name character varying(100)
tblstack.stack_id stack_id integer
removable integer
set_type integer
lock integer
timestamp character varying(30)
session character varying(40)
dbuser text

Index - Schema public

Table: tblsingle_3dregion_feature_values

tblsingle_3dregion_feature_values Structure
F-Key Name Type Description
single_3dregion_feature_values_id integer PRIMARY KEY DEFAULT nextval('s3dregfeat_seq'::regclass)
tbl3dregion.thrdregion_id thrdregion_id integer UNIQUE#1
tblfeature.feature_id feature_id integer UNIQUE#1
s3_value double precision

Index - Schema public

Table: tblsingle_image_feature_values

tblsingle_image_feature_values Structure
F-Key Name Type Description
single_image_feature_values_id integer PRIMARY KEY DEFAULT nextval('simagefeat_seq'::regclass)
tblimage.image_id image_id integer UNIQUE#1
tblfeature.feature_id feature_id integer UNIQUE#1
si_value double precision

Index - Schema public

Table: tblsingle_region_feature_values

tblsingle_region_feature_values Structure
F-Key Name Type Description
single_region_feature_values_id integer PRIMARY KEY DEFAULT nextval('sregionfeat_seq'::regclass)
tblregion.region_id region_id integer UNIQUE#1
tblfeature.feature_id feature_id integer UNIQUE#1
sr_value double precision

Index - Schema public

Table: tblsingle_stack_feature_values

tblsingle_stack_feature_values Structure
F-Key Name Type Description
single_stack_feature_values_id integer PRIMARY KEY DEFAULT nextval('sstackfeat_seq'::regclass)
tblstack.stack_id stack_id integer UNIQUE#1
tblfeature.feature_id feature_id integer UNIQUE#1
ss_value double precision

Index - Schema public

Table: tblslide

tblslide Structure
F-Key Name Type Description
slide_id integer PRIMARY KEY DEFAULT nextval('slide_seq'::regclass)
tblcell_type.cell_type_id cell_type_id integer
tblexperiment.experiment_id experiment_id integer
tblprotocol.protocol_id protocol_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblslide_label

tblslide_label Structure
F-Key Name Type Description
tblslide.slide_id slide_id integer
tbllabel.label_id label_id integer

Index - Schema public

Table: tblstack

tblstack Structure
F-Key Name Type Description
stack_id integer PRIMARY KEY DEFAULT nextval('stack_seq'::regclass)
tblmicroscopy_filter.microscopy_filter_id microscopy_filter_id integer
tbltime.time_id time_id integer
tblsubstance.substance_id target_id integer
stack_description character varying(50)
tbldye.dye_id dye_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblsub2sub

tblsub2sub Structure
F-Key Name Type Description
sub2sub_id integer PRIMARY KEY DEFAULT nextval('sub2sub_seq'::regclass)
tblsubstance.substance_id child_id integer
tblsubstance.substance_id parent_id integer

Index - Schema public

Table: tblsubstance

tblsubstance Structure
F-Key Name Type Description
substance_id integer PRIMARY KEY DEFAULT nextval('substance_seq'::regclass)
name character varying(500)
source_organism_mesh_heading character varying(40)
source_organism_mesh_treenumber character varying(40)
tblsupplier.supplier_id supplier_id integer
supplier_part_number integer
substance_mesh_heading character varying(256)
substance_mesh_treenumber character varying(40)
uniprot_link character varying(100)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tblsupplier

tblsupplier Structure
F-Key Name Type Description
supplier_id integer PRIMARY KEY DEFAULT nextval('supplier_seq'::regclass)
supplier_name character varying(50)
supplier_url character varying(120)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: tbltime

tbltime Structure
F-Key Name Type Description
time_id integer PRIMARY KEY DEFAULT nextval('time_seq'::regclass)
tblfield_of_view.field_of_view_id field_of_view_id integer
time date

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Function: get_cell_type_id( x text )

Returns: integer

Language: SQL

select cell_type_id from tblcell_type where cell_name=$1

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict