FinanceFerret/2.0/sql/Accounts: Difference between revisions

From Woozle Writes Code
< 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 (1 revision imported: stuff I missed the first time)
(No difference)

Revision as of 13:45, 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;