FinanceFerret/2.0/sql/Trx Types
< FinanceFerret | 2.0 | sql
Jump to navigation
Jump to search
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
<section begin=sql /><mysql>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;</mysql> <section end=sql />