Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Complete schema changes to add new tables and fields for MOTs #4981

Closed
Tracked by #4640
grantfitzsimmons opened this issue Jun 3, 2024 · 0 comments · Fixed by #5032
Closed
Tracked by #4640

Complete schema changes to add new tables and fields for MOTs #4981

grantfitzsimmons opened this issue Jun 3, 2024 · 0 comments · Fixed by #5032
Assignees
Labels
1 - Request A request made by a member of the community 2 - Database/Schema Issues that are related to the underlying database and schema
Milestone

Comments

@grantfitzsimmons
Copy link
Member

grantfitzsimmons commented Jun 3, 2024

Component of #4640

This would involve creating a new table and relationship field on Collection Object.

  • A new field would be added to Collection Object in the data model named objectType
  • A new table would be added named collectionobjecttype
  • This table would contain a number of fields used for application business logic
    • CollectionObjectTypeID (int) - Database ID
    • Name (text) - Name of the type (i.e. Fossil, Rock, Meteorite, etc.)
    • IsLoanable (boolean) - Indicates whether this type of material can have its preparations be transacted in interactions (to be reconsidered)
    • Version (int) - Version to identify which revision it is
    • TimestampCreated (datetime)
    • TimestampModified (datetime)
    • CreatedByAgentID (FK to Agent) - Created by agent
    • ModifiedByAgentID (FK to Agent) - Modified by agent
    • CollectionID (FK to Collection) - Used to scope the table to the collection it was created in
    • TaxonTreeDefID (FK to TaxonTreeDef) - Indicates which taxon tree definition contains the names associated with this object

We should also include a number of empty text fields just in case.

@grantfitzsimmons grantfitzsimmons added 1 - Request A request made by a member of the community 2 - Database/Schema Issues that are related to the underlying database and schema labels Jun 3, 2024
@grantfitzsimmons grantfitzsimmons added this to the 7.9.7 milestone Jun 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
1 - Request A request made by a member of the community 2 - Database/Schema Issues that are related to the underlying database and schema
Projects
None yet
2 participants