FinanceFerret/v3

SQL

Accounts

CREATE TABLE
  `Account` (
    `ID`          int(11) NOT NULL AUTO_INCREMENT,
    `ID_Parent`   int(11) DEFAULT NULL,
    `ID_Owner`    int(11) DEFAULT NULL,
    `Name`        varchar(127) DEFAULT NULL,
    `isTxactable` tinyint(1) DEFAULT NULL,
    `Abbr`        varchar(63) DEFAULT NULL,
    PRIMARY KEY (`ID`)
  ) ENGINE = InnoDB

Owners

CREATE TABLE
  `Owner` (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    `ID_Parent` int(11) DEFAULT NULL,
    `Name` varchar(127) NOT NULL,
    `Abbr` varchar(15) DEFAULT NULL,
    PRIMARY KEY (`ID`)
  ) ENGINE = InnoDB

Transactions

CREATE TABLE
  `Trxact` (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    `ID_Account` int(11) NOT NULL,
    `ID_Tuple` int(11) DEFAULT NULL,
    `RmtAbbr` varchar(64) DEFAULT NULL,
    `Amount` decimal(6, 2) DEFAULT NULL,
    `When` timestamp NULL DEFAULT NULL,
    `Seq` decimal(6, 2) DEFAULT NULL,
    `Tags` varchar(255) DEFAULT NULL,
    `What` varchar(127) DEFAULT NULL,
    `RmtConf` varchar(100) DEFAULT NULL,
    PRIMARY KEY (`ID`)
  ) ENGINE = InnoDB