FinanceFerret/2.0/sql/Trx List Items

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Jump to navigation Jump to search


  • Purpose: individual transactions within a transaction list
  • History:
    • 2019-02-12 design started; table created for development work


CREATE TABLE `Trx_List_Items` (
  ID_List INT(4) NOT NULL COMMENT "Trx_Lists.ID",
  ID_Trx INT(4)  NOT NULL COMMENT "Transactions.ID",
  Sort INT(4)    NOT NULL COMMENT "sorting order for this transaction within this list",

  PRIMARY KEY(`ID_List`,`ID_Trx`)