FinanceFerret/2.0/sql/Accounts: Difference between revisions
< FinanceFerret | 2.0 | sql
Jump to navigation
Jump to search
m (1 revision imported: stuff I missed the first time) |
m (Woozle moved page FinanceFerret/tables/Accounts to FinanceFerret/2.0/sql/Accounts without leaving a redirect: renumbering - 1.0 is Access version) |
(No difference)
| |
Latest revision as of 13:49, 2 March 2020
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;