FinanceFerret/2.0/sql/Trx List Items: Difference between revisions
< FinanceFerret | 2.0 | sql
Jump to navigation
Jump to search
(Created page with "==About== * '''Purpose''': individual transactions within a transaction list ** '''Requires''': {{l/same|Trx_Lists}} * '''History''': ** '''2019-02-12''' design started; table...") |
m (Woozle moved page FinanceFerret/tables/Trx List Items to FinanceFerret/2.0/sql/Trx List Items without leaving a redirect: renumbering - 1.0 is Access version) |
| (One intermediate revision by the same user not shown) | |
(No difference)
| |
Latest revision as of 13:49, 2 March 2020
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;