Task #4317 (new)
Opened 13 years ago
Last modified 12 years ago
ROI model-database alignment — at Initial Version
Reported by: | wmoore | Owned by: | ajpatterson |
---|---|---|---|
Priority: | major | Milestone: | OMERO-Beta4.3 |
Component: | Model | Keywords: | n.a. |
Cc: | jburel, ajpatterson, jamoore | Story Points: | n.a. |
Sprint: | n.a. | Importance: | n.a. |
Total Remaining Time: | 0.0d | Estimated Remaining Time: | n.a. |
Description
Some differences between what the model supports and what the database contains or clients write to DB.
Looking at the Shape table:
- Does not have 'marker' column ('arrow' etc in the model)
- 'path' is not supported
- Line is not supported by measurement tool. Uses polyline.
- 'transform' model says this should be a String with 6 numbers. Database contains strings such as "rotate(0, 100,50)"
- font weight (not used?)
- 'Verdana' in DB, not in model.
Database shape table:
Column | Type | Modifiers --------------------------+------------------------+----------- discriminator | character varying(31) | not null id | bigint | not null permissions | bigint | not null fillcolor | integer | - no e.g. fillrule | character varying(255) | - no e.g. fontfamily | character varying(255) | fontsize | integer | fontstretch | character varying(255) | fontstyle | character varying(255) | fontvariant | character varying(255) | fontweight | character varying(255) | g | character varying(255) | locked | boolean | strokecolor | integer | strokedasharray | character varying(255) | strokedashoffset | integer | strokelinecap | character varying(255) | strokelinejoin | character varying(255) | strokemiterlimit | integer | strokewidth | integer | thec | integer | thet | integer | thez | integer | transform | character varying(255) | vectoreffect | character varying(255) | version | integer | visibility | boolean | points | text | textvalue | text | cx | double precision | cy | double precision | anchor | character varying(255) | baselineshift | character varying(255) | decoration | character varying(255) | direction | character varying(255) | glyphorientationvertical | integer | writingmode | character varying(255) | x | double precision | y | double precision | d | text | height | double precision | rx | double precision | width | double precision | bytes | bytea | ry | double precision | x1 | double precision | x2 | double precision | y1 | double precision | y2 | double precision | creation_id | bigint | not null external_id | bigint | group_id | bigint | not null owner_id | bigint | not null update_id | bigint | not null roi | bigint | not null pixels | bigint | roi_index | integer | not null pg_geom | polygon |
Note: See
TracTickets for help on using
tickets.
You may also have a look at Agilo extensions to the ticket.