Schema Request - Additional Fields & Custom Tables

[bhumikaguptaa]

Is your feature request related to a problem? Please describe.

SDU have exhausted the available standard text and numeric fields within their current CollectionObject, CollectionObjectAttribute, and CollectionObjectProperty tables. They also require two new tables for smooth workflow.

Describe the solution you'd like

They request a schema extension to add specific fields to existing tables and the creation of two entirely new tables linked to the Collection Object.

1. Expand Existing Tables:
   Collection Object: Add 2 additional Text fields and 12 additional Numeric fields. (Target Total: 10 Text, 20 Numeric).
   Collection Object Attribute: Add 38 additional Numeric fields. (Target Total: 10 Text, 80 Numeric).
   Collection Object Property: Add 50 additional Numeric fields. (Target Total: 20 Text, 80 Numeric).

2. Create two new tables like CollectionObjectData1 and CollectionObjectData2 that share the same relationship logic as CollectionObjectAttribute (linked to the Collection Object). Each table must contain 20 Text fields and 80 Numeric fields.

Reported By
Tanja Lemby Madsen, University of Southern Denmark, https://specifysoftware.bolddesk.com/agent/tickets/509