I am looking for a
Word for specific type of tables.
I have tried to search a lot, but I could not come up with best search terms for this.
Tables that hold some master information, such as products, users, customers, brands etc. for the system are called -
Tables that hold some transaction information, such as orders, deliveries, invoices etc. are called -
Tables that hold cross join (many to many relationship) information - are called
Third tables OR
Now, the tables I am looking the term for; stores the information for a specific time period. So, for example past 12 months data only. When a month is lapsed the last month data is wiped out and the current month data would start stacking up. Once the current month is lapsed again the 12th month data would be wiped out, making space for latest month data.
The best I have come up with is
Rolling Entry Tables, but I want to know if there already exists a common terminology for this.