- 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
- 2019-02-12 design started; table created for development work
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;