FinanceFerret/tables/Trx Types

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, 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

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;