FinanceFerret/2.0/sql/Trx Types: Difference between revisions
< FinanceFerret | 2.0 | sql
Jump to navigation
Jump to search
(updated syntax highlight tags) |
m (2 revisions imported: stuff I missed the first time) |
(No difference)
|
Revision as of 13:45, 2 March 2020
About
- Purpose: organizes different types of transactions
- Notes:
- Transaction amounts are generally entered as positive numbers; the direction in which the amount is moving is determined by the transaction type.
Future
- The name of this table should be changed later because "Types" is a keyword and confuses the syntax display parser; also, spaces in table names are usable but generally should be avoided
SQL
DROP TABLE IF EXISTS `Trx Types`;
CREATE TABLE `Trx Types` (
`Code` varchar(50) NOT NULL COMMENT "identifying abbreviation",
`Descr` varchar(50) default NULL COMMENT "description",
`IsDebit` BOOL NOT NULL DEFAULT FALSE COMMENT "TRUE = debits from source account; FALSE = credits to source account",
`IsEquity` BOOL NOT NULL DEFAULT FALSE COMMENT "TRUE = affects equity only; FALSE = regular transaction",
PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT;