FinanceFerret/2.0/sql/Trx List Settings
< FinanceFerret | 2.0 | sql
Jump to navigation
Jump to search
About
- Purpose: Stores filter settings that were used to generate a transaction list, so we can bring the filter form back up for modification
- Requires: Trx_Lists
- History:
- 2019-02-21: Design started, table created in development instance
SQL
CREATE TABLE `Trx_List_Settings` (
`ID_List` INT(4) NOT NULL COMMENT "Trx_Lists.ID",
`Name` VARCHAR(255),
`Value` VARCHAR(255),
PRIMARY KEY(`ID_List`,`Name`)
) ENGINE=InnoDB;