Customer ID did not reset

[nus-se-script]

Steps to reproduce:

1. Add several customer and orders (in my case 3 customers)
2. clear the database
3. add new customer

Expected Result

Customer id of the new customer is 1

Actual Result

Customer id of the new customer is 4

Visual Proof

Environment/System

Java: Java 11.0.19 Azul JDK11 Chip: Apple M2 Pro Operating System: MacOS Ventura 13.6

---

_{[original: nus-cs2103-AY2324S1/pe-interim#3295] [original labels: severity.Low type.FeatureFlaw]}

[juliusgambe]

Team's Response

According to the UG, the ID is guranteed to be unique but not be consecutive and start from 1.

Our planned enhancements states that the ID generation is not consistent and may skip a few numbers, which you have observed, and we want to improve by ensuring that new deliveries or customers will have a more consistent ID generation.

Duplicate status (if any):

--