CREATE TABLE Donos (
Nome TEXT NOT NULL,
CPF TEXT UNIQUE NOT NULL, -- Impede CPFs repetidos
Email TEXT,
Saldo NUMERIC
);
INSERT INTO Clientes (Nome, CPF, Email, Renda_Estimada, Score_Serasa, DataNasc) VALUES
('Miguel Oliveira', '111.222.333-01', 'miguel.o@email.com', 4500.00, 720, '1985-05-15'),
('Arthur Silva', '111.222.333-02', 'arthur.s@email.com', 3200.50, 610, '1992-03-10'),
('Heitor Santos', '111.222.333-03', 'heitor.s@email.com', 12000.00, 890, '1978-11-22'),
('Helena Souza', '111.222.333-04', 'helena.s@email.com', 5400.00, 750, '1995-07-04'),
('Alice Ferreira', '111.222.333-05', 'alice.f@email.com', 2800.00, 430, '2000-01-30'),
('Theo Rodrigues', '111.222.333-06', 'theo.r@email.com', 9500.00, 820, '1988-09-12'),
('Laura Almeida', '111.222.333-07', 'laura.a@email.com', 15000.00, 950, '1982-12-05'),
('Gabriel Pereira', '111.222.333-08', 'gabriel.p@email.com', 4100.00, 580, '1990-06-18'),
('Bernardo Lima', '111.222.333-09', 'bernardo.l@email.com', 6700.00, 690, '1975-04-25'),
('Samuel Gomes', '111.222.333-10', 'samuel.g@email.com', 3300.00, 510, '1998-02-14'),
('Maria Eduarda', '111.222.333-11', 'madu@email.com', 11000.00, 880, '1991-08-30'),
('Sophia Costa', '111.222.333-12', 'sophia.c@email.com', 2200.00, 390, '2002-10-11'),
('Lorenzo Carvalho', '111.222.333-13', 'lorenzo.c@email.com', 5900.00, 710, '1986-03-22'),
('Valentina Rocha', '111.222.333-14', 'valentina.r@email.com', 8200.00, 780, '1994-11-08'),
('Enzo Gabriel', '111.222.333-15', 'enzo.g@email.com', 1800.00, 320, '2001-05-19'),
('Isabella Ribeiro', '111.222.333-16', 'isabella.r@email.com', 13500.00, 920, '1980-07-27'),
('Matheus Rezende', '111.222.333-17', 'matheus.r@email.com', 4800.00, 640, '1993-02-14'),
('Lívia Martins', '111.222.333-18', 'livia.m@email.com', 7300.00, 740, '1997-09-01'),
('Lucas Mendes', '111.222.333-19', 'lucas.m@email.com', 25000.00, 980, '1972-06-30'),
('Giovanna Cunha', '111.222.333-20', 'gio.c@email.com', 3600.00, 520, '1999-12-15'),
('Benjamin Barbosa', '111.222.333-21', 'benjamin.b@email.com', 9000.00, 810, '1984-04-03'),
('Cecília Castro', '111.222.333-22', 'cecilia.c@email.com', 5100.00, 660, '1996-08-20'),
('Joaquim Cardoso', '111.222.333-23', 'joaquim.c@email.com', 1200.00, 280, '2003-01-05'),
('Beatriz Dias', '111.222.333-24', 'beatriz.d@email.com', 14200.00, 940, '1979-10-12'),
('Rafael Moreira', '111.222.333-25', 'rafael.m@email.com', 6000.00, 700, '1987-05-24'),
('Eloá Farias', '111.222.333-26', 'eloa.f@email.com', 3800.00, 590, '1995-02-28'),
('Nicolas Vieira', '111.222.333-27', 'nicolas.v@email.com', 11500.00, 870, '1981-11-14'),
('Mariana Nunes', '111.222.333-28', 'mariana.n@email.com', 4700.00, 630, '1992-06-07'),
('Gustavo Machado', '111.222.333-29', 'gustavo.m@email.com', 8800.00, 790, '1983-09-19'),
('Manuela Fernandes', '111.222.333-30', 'manu.f@email.com', 2300.00, 410, '2000-04-12'),
('Murilo Ramos', '111.222.333-31', 'murilo.r@email.com', 7400.00, 715, '1989-01-25'),
('Lorena Moura', '111.222.333-32', 'lorena.m@email.com', 3500.00, 540, '1997-12-11'),
('Isaac Teixeira', '111.222.333-33', 'isaac.t@email.com', 12800.00, 910, '1980-05-30'),
('Lara Guimarães', '111.222.333-34', 'lara.g@email.com', 5600.00, 680, '1994-08-14'),
('Lucca Borges', '111.222.333-35', 'lucca.b@email.com', 1900.00, 350, '2001-09-02'),
('Heloísa Carvalho', '111.222.333-36', 'helo.c@email.com', 9300.00, 840, '1986-10-22'),
('Pedro Henrique', '111.222.333-37', 'pedro.h@email.com', 6100.00, 705, '1991-03-18'),
('Maitê Cavalcanti', '111.222.333-38', 'maite.c@email.com', 15500.00, 960, '1982-06-12'),
('Henry Silva', '111.222.333-39', 'henry.s@email.com', 4200.00, 620, '1993-07-04'),
('Maria Alice', '111.222.333-40', 'malice@email.com', 2700.00, 480, '2000-11-20'),
('João Miguel', '111.222.333-41', 'jmiguel@email.com', 11200.00, 895, '1981-02-14'),
('Isadora Porto', '111.222.333-42', 'isa.p@email.com', 3900.00, 570, '1998-04-09'),
('Luiz Otávio', '111.222.333-43', 'luiz.o@email.com', 8400.00, 775, '1984-08-27'),
('Maria Clara', '111.222.333-44', 'mclara@email.com', 5200.00, 695, '1995-10-01'),
('Davi Lucca', '111.222.333-45', 'davi.l@email.com', 1300.00, 310, '2003-12-15'),
('Maria Cecília', '111.222.333-46', 'mceci@email.com', 14800.00, 955, '1979-05-11'),
('Yuri Menezes', '111.222.333-47', 'yuri.m@email.com', 6500.00, 730, '1987-09-14'),
('Antonella Lima', '111.222.333-48', 'antone.l@email.com', 4100.00, 615, '1996-03-22'),
('Anthony Santos', '111.222.333-49', 'anthony.s@email.com', 11900.00, 885, '1982-12-05'),
('Emanuelly Paz', '111.222.333-50', 'manu.p@email.com', 4600.00, 645, '1992-02-28'),
('Bryan Souza', '111.222.333-51', 'bryan.s@email.com', 8600.00, 795, '1983-11-19'),
('Isis Pereira', '111.222.333-52', 'isis.p@email.com', 2100.00, 420, '1999-06-12'),
('Henrique Rocha', '111.222.333-53', 'henri.r@email.com', 7100.00, 725, '1988-08-25'),
('Clara Silveira', '111.222.333-54', 'clara.s@email.com', 3300.00, 550, '1997-01-11'),
('Cauã Almeida', '111.222.333-55', 'caua.a@email.com', 12500.00, 915, '1980-04-30'),
('Ana Júlia', '111.222.333-56', 'anaj@email.com', 5800.00, 685, '1994-07-14'),
('Pietro Duarte', '111.222.333-57', 'pietro.d@email.com', 2000.00, 360, '2001-08-02'),
('Mariana Lopes', '111.222.333-58', 'mari.l@email.com', 9100.00, 835, '1986-11-22'),
('Gustavo Henrique', '111.222.333-59', 'ghenri@email.com', 6300.00, 710, '1991-04-18'),
('Vitória Regina', '111.222.333-60', 'vitoria.r@email.com', 15800.00, 965, '1982-05-12'),
('Vitor Hugo', '111.222.333-61', 'vitor.h@email.com', 4300.00, 625, '1993-06-04'),
('Ana Luísa', '111.222.333-62', 'analu@email.com', 2900.00, 490, '2000-10-20'),
('Leonardo Martins', '111.222.333-63', 'leo.m@email.com', 11400.00, 905, '1981-01-14'),
('Larissa Santos', '111.222.333-64', 'lari.s@email.com', 3800.00, 575, '1998-05-09'),
('Felipe Augusto', '111.222.333-65', 'felipe.a@email.com', 8200.00, 785, '1984-07-27'),
('Beatriz Helena', '111.222.333-66', 'bia.h@email.com', 5100.00, 690, '1995-11-01'),
('Nathan Lima', '111.222.333-67', 'nathan.l@email.com', 1400.00, 315, '2003-11-15'),
('Maria Vitória', '111.222.333-68', 'mavi@email.com', 14900.00, 950, '1979-06-11'),
('Augusto Cesar', '111.222.333-69', 'augusto.c@email.com', 6700.00, 735, '1987-08-14'),
('Maria Helena', '111.222.333-70', 'mhelena@email.com', 4200.00, 620, '1996-04-22'),
('Ícaro Gomes', '111.222.333-71', 'icaro.g@email.com', 12100.00, 890, '1982-11-05'),
('Sarah Silva', '111.222.333-72', 'sarah.s@email.com', 4500.00, 650, '1992-01-28'),
('Enzo Moreira', '111.222.333-73', 'enzo.m@email.com', 8500.00, 790, '1983-12-19'),
('Alícia Nunes', '111.222.333-74', 'alicia.n@email.com', 2200.00, 425, '1999-07-12'),
('Thiago Barros', '111.222.333-75', 'thiago.b@email.com', 7200.00, 720, '1988-07-25'),
('Esther Souza', '111.222.333-76', 'esther.s@email.com', 3400.00, 555, '1997-02-11'),
('Joaquim Neto', '111.222.333-77', 'joaquim.n@email.com', 12700.00, 920, '1980-03-30'),
('Ana Liz', '111.222.333-78', 'analiz@email.com', 5900.00, 690, '1994-06-14'),
('Eduardo Silva', '111.222.333-79', 'eduardo.s@email.com', 2100.00, 365, '2001-07-02'),
('Mirella Santos', '111.222.333-80', 'mirella.s@email.com', 9200.00, 830, '1986-12-22'),
('Danilo Souza', '111.222.333-81', 'danilo.s@email.com', 6400.00, 715, '1991-05-18'),
('Lara Maria', '111.222.333-82', 'lara.m@email.com', 15900.00, 970, '1982-04-12'),
('Clarice Lima', '111.222.333-83', 'clarice.l@email.com', 4400.00, 630, '1993-05-04'),
('Otávio Luiz', '111.222.333-84', 'otavio.l@email.com', 2800.00, 495, '2000-09-20'),
('Maria Fernanda', '111.222.333-85', 'mafer@email.com', 11500.00, 910, '1981-12-14'),
('Rebeca Dias', '111.222.333-86', 'rebeca.d@email.com', 3900.00, 580, '1998-06-09'),
('Francisco Gil', '111.222.333-87', 'fran.g@email.com', 8300.00, 790, '1984-06-27'),
('Isabeli Farias', '111.222.333-88', 'isabeli.f@email.com', 5200.00, 695, '1995-12-01'),
('Renan Cardoso', '111.222.333-89', 'renan.c@email.com', 1500.00, 320, '2003-10-15'),
('Rosa Maria', '111.222.333-90', 'rosa.m@email.com', 15100.00, 955, '1979-07-11'),
('Téo Costa', '111.222.333-91', 'teo.c@email.com', 6800.00, 740, '1987-07-14'),
('Olívia Santos', '111.222.333-92', 'olivia.s@email.com', 4300.00, 625, '1996-05-22'),
('Levi Silva', '111.222.333-93', 'levi.s@email.com', 12200.00, 895, '1982-10-05'),
('Jade Ferreira', '111.222.333-94', 'jade.f@email.com', 4600.00, 655, '1992-02-28'),
('Bento Lima', '111.222.333-95', 'bento.l@email.com', 8600.00, 795, '1983-11-19'),
('Zoe Santos', '111.222.333-96', 'zoe.s@email.com', 2300.00, 430, '1999-08-12'),
('Caleb Moura', '111.222.333-97', 'caleb.m@email.com', 7300.00, 725, '1988-06-25'),
('Ayla Ribeiro', '111.222.333-98', 'ayla.r@email.com', 3500.00, 560, '1997-03-11'),
('Martim Souza', '111.222.333-99', 'martim.s@email.com', 12900.00, 925, '1980-02-30'),
('Maya Lima', '111.222.333-00', 'maya.l@email.com', 6000.00, 695, '1994-05-14');
0 comentários:
Postar um comentário