EXNJxQEu

1CREATE TABLE IF NOT EXISTS `fin_dec_db2019`.`user` (
2  `id_user` INT NOT NULL AUTO_INCREMENT,
3  `user_description` VARCHAR(45) NOT NULL,
4  `email` VARCHAR(45) NOT NULL,
5  `password` VARCHAR(125) NOT NULL,
6  `created_at` DATETIME NULL,
7  `updated_at` DATETIME NULL,
8  `user_state_id_user_state` INT NOT NULL,
9  `remember_token` VARCHAR(100) NULL,
10  PRIMARY KEY (`id_user`),
11  INDEX `fk_user_user_state1_idx` (`user_state_id_user_state` ASC) VISIBLE,
12  CONSTRAINT `fk_user_user_state1`
13    FOREIGN KEY (`user_state_id_user_state`)
14    REFERENCES `fin_dec_db2019`.`user_state` (`id_user_state`)
15    ON DELETE NO ACTION
16    ON UPDATE NO ACTION)
17ENGINE = InnoDB
18ROW_FORMAT = DEFAULT
19
20CREATE TABLE IF NOT EXISTS `fin_dec_db2019`.`account` (
21  `id_account` INT NOT NULL AUTO_INCREMENT,
22  `created_at` DATETIME NULL,
23  `updated_at` DATETIME NULL,
24  `comments` VARCHAR(125) NULL,
25  `type_account_id_type_account` INT NOT NULL,
26  `expiration_date` DATE NULL,
27  `client_position_idclient_position` INT NULL,
28  `user_id_user` INT NOT NULL,
29  PRIMARY KEY (`id_account`),
30  INDEX `fk_account_type_account1_idx` (`type_account_id_type_account` ASC) VISIBLE,
31  INDEX `fk_account_client_position1_idx` (`client_position_idclient_position` ASC) VISIBLE,
32  INDEX `fk_account_user1_idx` (`user_id_user` ASC) VISIBLE,
33  CONSTRAINT `fk_account_type_account1`
34    FOREIGN KEY (`type_account_id_type_account`)
35    REFERENCES `fin_dec_db2019`.`type_account` (`id_type_account`)
36    ON DELETE NO ACTION
37    ON UPDATE NO ACTION,
38  CONSTRAINT `fk_account_client_position1`
39    FOREIGN KEY (`client_position_idclient_position`)
40    REFERENCES `fin_dec_db2019`.`client_position` (`id_client_position`)
41    ON DELETE NO ACTION
42    ON UPDATE NO ACTION,
43  CONSTRAINT `fk_account_user1`
44    FOREIGN KEY (`user_id_user`)
45    REFERENCES `fin_dec_db2019`.`user` (`id_user`)
46    ON DELETE NO ACTION
47    ON UPDATE NO ACTION)
48ENGINE = InnoDB