FinanceFerret/2.0/sql/Trx List Settings

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

  • Purpose: Stores filter settings that were used to generate a transaction list, so we can bring the filter form back up for modification
  • 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;