FinanceFerret/2.0/sql/Accounts

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

History

  • 2018-05-10 documenting schema as it now stands

SQL

CREATE TABLE `Accounts` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) DEFAULT NULL,
  `Descr` varchar(255) DEFAULT NULL,
  `ID_Parent` int(4) DEFAULT NULL,
  `ID_Type` int(4) DEFAULT NULL,
  `ID_Owner` int(4) DEFAULT NULL,
  `ID_Alias` int(4) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB CHARSET=latin1;