FinanceFerret/tables/Trx Lists

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

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;