|
CustID |
CustName |
CustData |
|
456 |
Ann Art |
Premium |
|
567 |
Bob Burr |
Standard |
|
678 |
Kim Kat |
Legacy |
|
789 |
Jay Jar |
Standard |
|
ProdID |
ProdName |
ProdData |
|
111 |
Widget |
Volume |
|
112 |
Gadget |
One-Off |
|
115 |
Trinket |
Phase out |
|
117 |
Gizmo |
Opp Buy |
|
TransID |
CustID |
TransData |
|
20695 |
456 |
On-Line |
|
20696 |
567 |
In-Store |
|
20697 |
678 |
|
|
20698 |
789 |
In-Store |
|
TransID |
ProdID |
TransPrice |
|
20696 |
111 |
$1.00 |
|
20696 |
112 |
$1.00 |
|
20696 |
115 |
$3.00 |
|
20696 |
117 |
$1.00 |
When we phase out the Trinket, what happens to the data?
What if I delete the records from the database 2 years later