FinanceFerret/2.0/sql/Accounts
< FinanceFerret | 2.0 | sql
Jump to navigation
Jump to search
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;