View column suggestions need to take into account multi-value lists and then suggest the appropriate column type

Description

View column suggestions need to take into account multi-value lists and then suggest the appropriate column type if >=2 values suggest STRING_LIST otherwise suggest STRING

We should also make the ANNOTATION_REPLICATION table store a column for maxSize of string list ,which is filled in during replication of an annotation to avoid full table-scan of all STRING_LIST columns.

Also should make the column suggestion an async job because it could take a long time to execute.

Environment

None

Assignee

Ziming Dong

Reporter

Ziming Dong

Labels

None

Validator

Xavier Schildwachter

Development Area

None

Release Version History

None

Fix versions

Priority

Major
Configure