Is there a term for describing tables where only the last value should be used?

Question

My database has tables where each row represents an entity, and there are other tables in which the same object can appear several times, but only the last record is valid.

For example, I have a table customerwhere each row represents a client and another table customer_membership_statuswhere the same client can be referenced several times, but only the last record for each client is suppost to use. Data is never updated in customer_membership_status, only inserted.

Is there a term to describe this template? I ask because I would like to quickly and easily explain the intended use of the table to others.

Answer 1

Probably the best term would be CQRS and a source event.

Using the event stream as a recording repository, rather than actual data at a specific point in time, avoids update conflicts in a single aggregate and maximizes performance and scalability

Event Source Template

, , , , . . , -, , . , .

EDIT:

SCD ( ) 2.

, / . .

Answer 2

. , timestamp/version . temporal/version , .