I am glad having finished archiving the database of my customer, one of the biggest online whole sellers in Taiwan, and deleted 2,397,870 aged products successfully!
I designed this entity-relationship model (ER model) for my customer 5 years ago. A single product (entity) is stored in 16 database tables with data integrity enforcement:
- Entity integrity: Primary Key constraint
- Semantic integrity: Data Types and length
- Referential integrity: Foreign Key constraint/relationship
PS. It’s a master/details structure. The name of the Details tables is removed.