As for storing history in the database, is it better to use DateEnd (example 1) or duration (example 2)?
Or please, feel free to even suggest a different approach that would be most effective.
Are there other changes that I should make to one of these examples, if it turns out that this is the right approach? DB is used by MySQL, although I do not think it is relevant to the approach here.
: -, -? "" - "", "" .. , -, . , "subscription_type", .
. , , , . , , , (, , ), End < targetDate, , .
, ( ) . , ( ) .
, " ".
" " , : - WHERE END_DATE > CURRENTSYSTEMDATE(). , , , "" .
, . , . .
, , .
, - , , , , - subscription_hist, , last_modified_date last_person_changed_by. . , , . , , , , .