image_with_region_mf - View
HomeTablesDiagramsForeign KeysIndexes

Nameimage_with_region_mf
SQL
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.detector_name, 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