FerretMyMoney/sql/fmmBankBals: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==About== * '''Purpose''': stores end-of-day balances as shown by the bank (online or statement) * '''History''': ** '''2012-02-20''' designed ==SQL== <section begin=sql /><my...") |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 4: | Line 4: | ||
** '''2012-02-20''' designed | ** '''2012-02-20''' designed | ||
==SQL== | ==SQL== | ||
< | <syntaxhighlight lang=mysql>CREATE TABLE `fmmTrxacts` ( | ||
ID_Acct VARCHAR(32) NOT NULL COMMENT "ID of KMM Account", | ID_Acct VARCHAR(32) NOT NULL COMMENT "ID of KMM Account", | ||
WhenBank DATETIME NOT NULL COMMENT "day for which this balance applies", | WhenBank DATETIME NOT NULL COMMENT "day for which this balance applies", | ||
| Line 10: | Line 10: | ||
PRIMARY KEY(`ID_Acct`,`WhenBank`) | PRIMARY KEY(`ID_Acct`,`WhenBank`) | ||
) | ) | ||
ENGINE = MYISAM; | ENGINE = MYISAM; | ||
< | </syntaxhighlight> | ||
Latest revision as of 21:48, 5 February 2025
About
- Purpose: stores end-of-day balances as shown by the bank (online or statement)
- History:
- 2012-02-20 designed
SQL
CREATE TABLE `fmmTrxacts` (
ID_Acct VARCHAR(32) NOT NULL COMMENT "ID of KMM Account",
WhenBank DATETIME NOT NULL COMMENT "day for which this balance applies",
Balance DECIMAL(9,2) NOT NULL COMMENT "balance as given by bank",
PRIMARY KEY(`ID_Acct`,`WhenBank`)
)
ENGINE = MYISAM;