ttqdXcPa

1CREATE TABLE IF NOT EXISTS `TableOfAccounts` (
2  `id_conta_interno` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'Codigo do plano de contas interno',
3  `id_tipo` INT NOT NULL,
4  `idCurrency` INT NOT NULL,
5  `cod` INT(11) NOT NULL COMMENT 'Codigo do plano de contas interno',
6  `des` VARCHAR(100) CHARACTER SET 'utf8' NOT NULL COMMENT 'Descricao do plano de contas interno (Portugues)',
7  `niv_1` VARCHAR(11) CHARACTER SET 'utf8' NOT NULL COMMENT 'Nivel 1',
8  `niv_2` VARCHAR(11) CHARACTER SET 'utf8' NULL DEFAULT 0 COMMENT 'Nivel 2',
9  `niv_3` VARCHAR(11) CHARACTER SET 'utf8' NULL DEFAULT 0 COMMENT 'Nivel 3',
10  `niv_4` VARCHAR(11) CHARACTER SET 'utf8' NULL DEFAULT 0 COMMENT 'Nivel 4',
11  `niv_5` VARCHAR(11) CHARACTER SET 'utf8' NULL DEFAULT 0 COMMENT 'Nivel 5',
12  `stat` TINYINT(4) NOT NULL DEFAULT 1 COMMENT 'Situacao do Registro (1-Ativo 0-Excluido)',
13  `created` DATETIME NOT NULL COMMENT 'data de criacao do registro',
14  `modified` DATETIME NOT NULL COMMENT 'data de exclusao do registro',
15  PRIMARY KEY (`id_conta_interno`),
16  INDEX `idx_1` (`cod` ASC, `stat` ASC),
17  INDEX `fk_TableOfAccounts_1_idx` (`idCurrency` ASC),
18  INDEX `fk_TableOfAccounts_2_idx` (`id_tipo` ASC),
19  UNIQUE INDEX `cod_UNIQUE` (`cod` ASC),
20  CONSTRAINT `fk_TableOfAccounts_1`
21    FOREIGN KEY (`idCurrency`)
22    REFERENCES `Currency` (`idCurrency`)
23    ON DELETE NO ACTION
24    ON UPDATE NO ACTION,
25  CONSTRAINT `fk_TableOfAccounts_2`
26    FOREIGN KEY (`id_tipo`)
27    REFERENCES `AccountType` (`id_tipo`)
28    ON DELETE NO ACTION
29    ON UPDATE NO ACTION);