Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // ------- Tabela Usuários -------
- CREATE TABLE IF NOT EXISTS `usuarios`(
- `id` int NOT NULL AUTO_INCREMENT,
- `nome` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
- `sobrenome` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
- `email` varchar(220) COLLATE utf8mb4_general_ci NOT NULL,
- `senha` varchar(60) COLLATE utf8mb4_general_ci NOT NULL,
- `image` varchar(220) COLLATE utf8mb4_general_ci NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE = INNODB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
- // ------- Tabela controle de despesas -------
- CREATE TABLE IF NOT EXISTS `controles_despesas`(
- `id` int NOT NULL AUTO_INCREMENT,
- `descricao` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
- `valor` double(6,2) NOT NULL,
- `tipo` ENUM('E', 'S') NOT NULL,
- `despesa` ENUM('F', 'V') NOT NULL,
- `categoria_id` int NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE = INNODB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
- // ------- Tabela categorias -------
- CREATE TABLE IF NOT EXISTS `categorias`(
- `id` int NOT NULL AUTO_INCREMENT,
- `nome` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE = INNODB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
- // --- Explicando aqui estes dois campos, como está na tabela, vai salvar somente as iniciais.
- // tipo(E = Entrada, S = Saída)
- // despesa(F = Fixa, V = Variada)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement