FinanceFerret/2.0/sql/Accounts: Difference between revisions
< FinanceFerret | 2.0 | sql
Jump to navigation
Jump to search
(Created page with "==History== * '''2018-05-10''' documenting schema as it now stands ==SQL== <syntaxhighlight lang=mysql> CREATE TABLE `Accounts` ( `ID` int(4) NOT NULL AUTO_INCREMENT, `Nam...") |
m (Woozle moved page FinanceFerret/tables/Accounts to FinanceFerret/2.0/sql/Accounts without leaving a redirect: renumbering - 1.0 is Access version) |
| (One intermediate revision by the same user not shown) | |
(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;