id,summary,reporter,owner,description,type,status,priority,milestone,component,resolution,keywords,cc,rd_points,sprint,story_priority 8084,Database - Consolidated Changes,ajpatterson,jamoore,"These changes are a combination of those from meeting notes, tickets, and the page [wiki:OmeModel/DatabaseComparison] * ROI: * Add ""markerstart"" to ""shape"" table * Add ""markerend"" to ""shape"" table * Add ""name"" to ""roi"" table * Rename ""textvalue"" in ""shape"" table to ""text"" * Rename ""visibility"" in ""shape"" table to ""visible"" * Rename ""rx"" in ""shape"" table to ""radiusx"" * Rename ""ry"" in ""shape"" table to ""radiusy"" * Delete ""cx"" in ""shape"" (now use ""x"") * Delete ""cy"" in ""shape"" (now use ""y"") * Delete ""g"" in ""shape"" table * Delete ""fontWeight"" in shape table (value needs to be merged with ""fontStyle"" see #8119) * Delete ""fontStretch"" in ""shape"" table * Delete ""fontVariant"" in ""shape"" table * Delete ""strokeDashOffset"" in ""shape"" table * Delete ""strokeLineJoin"" in ""shape"" table * Delete ""strokeMiterLimit"" in ""shape"" table * Delete ""vectorEffect"" in ""shape"" table * Delete ""keywords"" in ""roi"" table * Delete ""pixels"" in ""roi"" table * Change ""namespaces"" in ""roi"" table, which is currently a list of namespaces to be a single namespace called ""namespace"" * Add six floats to ""shape"" ""a00"",""a10"",""a10"",""a11"",""a02"",""a12"", to replace ""transform"" * SPW: * Rename ""posX"" in ""wellsample"" table to ""x"" * Rename ""posY"" in ""wellsample"" table to ""y"" * Keep ""type"" and merge in values from ""status"" in ""well"" table * Delete ""status"" in ""well"" table * Add ""UNIQUE"" to ""wellsample"" child - see #2577 * Change ""image"" in ""wellsample"" to be optional - see #8048 * Rename ""defaultSample"" in ""plate"" to ""FieldIndex"" * Acquisition: * Rename ""mode"" in ""channel"" table to ""acquisitionmode"" * Rename ""emissionWave"" in ""channel"" table to ""emissionwavelength"" * Rename ""excitationWave"" in ""channel"" table to ""excitationwavelength"" * Rename ""illumination"" in ""channel"" table to ""illuminationtype"" * Rename ""offsetvalue"" in ""detector"" table to ""offset"" * Rename ""offsetvalue"" in ""detectorsettings"" table to ""offset"" * Rename ""positionX"" in ""stagelabel"" table to ""x"" * Rename ""positionY"" in ""stagelabel"" table to ""y"" * Rename ""positionZ"" in ""stagelabel"" table to ""z"" * Delete ""otf"" table and all associated columns * ""pinHoleSize"" to ""pinholeSize"" * `Image/Pixels` * Rename ""pixelstype"" in ""pixels"" table to ""type"" * Delete ""relatedto"" in ""pixels"" table * Delete ""methodology"" in ""pixels"" table * Delete ""waveIncrement"" in ""pixels"" table * Delete ""waveStart"" in ""pixels"" table * Remove ""archived"" in ""image"" * Delete ""partial"" in ""image"" * Add the link table between image and microbeammanipulation - see #7954 * `Group/Experimenter` * Rename ""omename"" in ""experimenter"" table to ""username"" * `Channel/LogicalChannel` merge photometric interpretation has been removed from the model in 2008. Removed entry from DB when merging `LogicalChannel` into `Channel`. * `ExperimentType/MicrobeamManipulationType` * Add storage for **lists** of types to Experiment and !MicrobeamManipulation - see #2883 ---- * Deprecate pixels in DB (in next release move contents up to image)",story,accepted,critical,GatherReqs,General,,"dbmodelcompare, schema",jamoore jburel,,,