I am not a SharePoint designer, but am gathering data exported from it. I am designing a database table to hold periodic data-dumps posted from SharePoint, including the following fields:
- Document ID
- Version number
- Modified date
From my research, I see that SharePoint currently has major and minor version numbering of documents (1.0, 1.1 ...).
For the purpose of selecting the best data type for my database field, can anyone provide any insight as to whether versioning functionality will remain the same in future versions, or become any more sophisticated, e.g.
- 1a, 1b, 1c
- 1.0.0.1, 1.0.0.2
Is it even possible to create the above versioning (in the designer) to use instead of the default major/minor approach?
I appreciate this is an open question, but I've searched extensively today and have gained very little to help make an informed decision.