blob: b17bc2e01f70fe98db3d6dcf4c0665469858da0f [file] [log] [blame]
create table `acc_rule_tags` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
`acc_rule_id` BIGINT(20) NOT NULL,
`tag_id` INT(11) NOT NULL,
`acc_type_enum` SMALLINT(5) NOT NULL,
primary key(`id`),
INDEX `FK_acc_accounting_rule_id` (`acc_rule_id`),
INDEX `FK_m_code_value_id` (`tag_id`),
CONSTRAINT `FK_acc_accounting_rule_id` FOREIGN KEY (`acc_rule_id`) REFERENCES `acc_accounting_rule` (`id`),
CONSTRAINT `FK_m_code_value_id` FOREIGN KEY (`tag_id`) REFERENCES `m_code_value` (`id`)
);