FinanceFerret/2.0/sql/Accounts

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;