Changes between Version 1 and Version 2 of RelationalDesign


Ignore:
Timestamp:
12/02/24 02:57:14 (3 days ago)
Author:
211101
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v1 v2  
    1010- USER (**__user_id__**, **user_name**, **email**, **password**)
    1111- TRANSACTION_ACCOUNT (__**transaction_account_id**__, account_name, balance, user_id* (USER))
    12 - TRANSACTION (__**transaction_id__**, transaction_name, **amount**, net_amount, day_id* (DAY), tag_id* (TAG))
     12- TRANSACTION (__**transaction_id__**, transaction_name, **amount**, net_amount, **date**, tag_id* (TAG))
    1313- TRANSACTION_BREAKDOWN (__**transaction_breakdown_id__**, transaction_id* (TRANSACTION), transaction_account_id* (TRANSACTION_ACCOUNT), spent_amount, earned_amount)
    14 - YEAR (__**year_id__**, **year_name**)
    15 - MONTH (__**month_id__**, year_id* (YEAR), **month_name**)
    16 - DAY (__**day_id__**, month_id* (MONTH), day_number, day_name)
    1714- TAG (__**tag_id__**, **tag_name**)
    1815