FinanceFerret/2.0/sql/Trx Lists

About

• Purpose: storage of ordered transaction lists so that editing will not affect which transactions are displayed (or the order thereof). Storing the lists with a unique ID also allows sharing of lists between users. Each entry in this table corresponds to a transaction set.
  • Note that we will eventually probably want a methodical way of pruning these tables, as they will tend to accumulate unused data.
  • Requires: Trx_List_Items
• History:
  • 2019-02-12 design started; table created for development work

SQL

CREATE TABLE `Trx_Lists` (
  `ID`          INT(4) NOT NULL auto_increment,
  `ID_User`     INT(4) NOT NULL,
  `WhenCreated` DATETIME NOT NULL,
  `WhenViewed`  DATETIME DEFAULT NULL,
  `Title`       VARCHAR(255),

  PRIMARY KEY (`ID`)
) ENGINE=InnoDB;