FinanceFerret/2.0/sql/Trx List Items

About

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

SQL

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`)
) ENGINE=InnoDB;