FinanceFerret/2.0/sql/Trx Lists: Difference between revisions
< FinanceFerret | 2.0 | sql
Jump to navigation
Jump to search
(Created page with "==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...") |
m (Woozle moved page FinanceFerret/tables/Trx Lists to FinanceFerret/2.0/sql/Trx Lists without leaving a redirect: renumbering - 1.0 is Access version) |
(One intermediate revision by the same user not shown) | |
(No difference)
|
Latest revision as of 13:49, 2 March 2020
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;