21 reputation
3
bio website
location
age
visits member for 1 year, 6 months
seen Feb 18 at 16:37

Feb
27
comment Design strategies for storing and validating serial numbers
So I'm curious about why this method is more benefitial when reporitng on subfields. In either method aren't you still going to be getting a subfield based on the positions of the characters in the string? So the only effect it would have is the indices of the characters you wish to report on?
Feb
26
awarded  Supporter
Feb
26
comment Design strategies for storing and validating serial numbers
I don't want to make this more complex than it needs to, but I'm not sure that my proposed design is any less future-proof. If a new format comes along, we'd just add a new schema entry, and then validations could be done against both old and new schemas, right? When you say: "you face the possibility that the new serial number format will be something that your mechanism can't cope with," would you explain an example where this wouldn't work?
Feb
26
awarded  Editor
Feb
26
awarded  Student
Feb
26
comment Design strategies for storing and validating serial numbers
Yes, absolutely. I've updated my question to include an example. Oh and I completely forgot they have five sets.
Feb
26
revised Design strategies for storing and validating serial numbers
added 54 characters in body
Feb
26
asked Design strategies for storing and validating serial numbers