Plots and sheds are resources that are continuously used, and production batches have their own beginning and end. Mixing the two into one name field will make crop rotation, batch change and historical query difficult to interpret. Resources and batches need their own stable identification.
Resource Ledger
Plots and sheds are relatively stable resources, while planting or breeding batches are business records that continue to change. Only by separating the two types of objects can you view the production status of the same location in different cycles.
Coding rules
The number should be convenient for on-site identification and system query, and avoid associating records with only freely entered names. When locations are merged, split, or deactivated, the historical correspondence should be retained and the source of the original production records should not be lost.
Field selection
Fields such as area, purpose and responsible person should serve actual management. It is not necessary to collect all the data without clear purpose. The key is whether the fields can help arrange tasks, query processes and explain exceptions.
Scene verification
You can select two consecutive production batches of a shed as an example to check whether the historical data can still be located after the resource name changes. Stable resources remain associated with staged production records, helping to avoid duplication of documentation and historical confusion.
Specific verification method
Create two batches in the same shed and check that their production records are not mixed; query the old batch after modifying the resource name, and the relationship can still be located; retain the past data after the resource is deactivated; and then check whether the new batch inherits the execution results of the previous batch by mistake.
The name is used for display, and the identifier is used for association. Resource changes are saved separately from the production stage, which not only supports the current arrangement, but also allows subsequent queries to restore the actual production location used by each batch.
