FinanceFerret/2.0/sql/Trx List Settings: Difference between revisions

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Jump to navigation Jump to search
m (1 revision imported: stuff I missed the first time)
m (Woozle moved page FinanceFerret/tables/Trx List Settings to FinanceFerret/2.0/sql/Trx List Settings without leaving a redirect: renumbering - 1.0 is Access version)
 
(No difference)

Latest revision as of 13:49, 2 March 2020

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;