-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathclientes.sql
61 lines (53 loc) · 12.1 KB
/
clientes.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
--Tabela exemplo do curso
-- MySQL dump 10.13 Distrib 8.0.26, for Win64 (x86_64)
--
-- Host: localhost Database: banco
-- ------------------------------------------------------
-- Server version 8.0.26
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `clientes`
--
DROP TABLE IF EXISTS `clientes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `clientes` (
`ID_Cliente` int DEFAULT NULL,
`Nome` text,
`Sobrenome` text,
`Data_Nascimento` text,
`Estado_Civil` text,
`Sexo` text,
`Email` text,
`Telefone` text,
`Renda_Anual` int DEFAULT NULL,
`Qtd_Filhos` int DEFAULT NULL,
`Escolaridade` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `clientes`
--
LOCK TABLES `clientes` WRITE;
/*!40000 ALTER TABLE `clientes` DISABLE KEYS */;
INSERT INTO `clientes` VALUES (1,'Ruben','Torres','1985-08-07','C','M','[email protected]','(85) 94132-1176',60000,3,'Pós-graduado'),(2,'Christy','Zhu','1988-02-10','S','F','[email protected]','(41) 96270-6086',70000,0,'Pós-graduado'),(3,'Elizabeth','Johnson','1988-08-03','S','F','[email protected]','(31) 92039-5832',80000,5,'Pós-graduado'),(4,'Julio','Ruiz','1985-07-31','S','M','[email protected]','(62) 93391-5891',70000,0,'Pós-graduado'),(5,'Janet','Alvarez','1985-12-01','S','F','[email protected]','(21) 93379-3743',70000,0,'Pós-graduado'),(6,'Marco','Mehta','1984-05-04','C','M','[email protected]','(85) 99019-3803',60000,3,'Pós-graduado'),(7,'Rob','Verhoff','1984-07-02','S','F','[email protected]','(11) 98162-4760',60000,4,'Pós-graduado'),(8,'Shannon','Carlson','1984-03-27','S','M','[email protected]','(85) 96795-9950',70000,0,'Pós-graduado'),(9,'Jacquelyn','Suarez','1984-02-01','S','F','[email protected]','(31) 98159-7254',70000,0,'Pós-graduado'),(10,'Curtis','Lu','1983-10-30','C','M','[email protected]','(71) 94509-1440',60000,4,'Pós-graduado'),(11,'Lauren','Walker','1988-01-13','C','F','[email protected]','(21) 93994-2382',100000,2,'Pós-graduado'),(12,'Ian','Jenkins','1988-08-01','C','M','[email protected]','(21) 95385-3393',100000,2,'Pós-graduado'),(13,'Sydney','Bennett','1988-05-04','S','F','[email protected]','(11) 92024-9186',100000,3,'Pós-graduado'),(14,'Chloe','Young','1999-02-22','S','F','[email protected]','(71) 96890-7150',30000,0,'Parcial'),(15,'Wyatt','Hill','1999-04-23','C','M','[email protected]','(71) 98644-2695',30000,0,'Parcial'),(16,'Shannon','Wang','1964-06-21','S','F','[email protected]','(71) 94496-1712',20000,4,'Ensino médio'),(17,'Clarence','Rai','1964-10-04','S','M','[email protected]','(21) 98923-7805',30000,2,'Parcial'),(18,'Jordan','King','1998-09-15','S','M','[email protected]','(31) 99592-6279',40000,0,'Ensino médio'),(19,'Destiny','Wilson','1998-08-29','S','F','[email protected]','(21) 99431-6061',40000,0,'Parcial'),(20,'Ethan','Zhang','1998-10-07','C','M','[email protected]','(11) 96440-6637',40000,0,'Parcial'),(21,'Seth','Edwards','1998-10-06','C','M','[email protected]','(41) 97012-3526',40000,0,'Parcial'),(22,'Russell','Xie','1998-09-12','C','M','[email protected]',NULL,60000,0,'Parcial'),(23,'Alejandro','Beck','1965-12-18','C','M','[email protected]','(85) 94492-9582',10000,2,'Parcial'),(24,'Harold','Sai','1966-03-29','S','M','[email protected]','(31) 95052-6286',30000,2,'Parcial'),(25,'Jessie','Zhao','1966-12-02','C','M','[email protected]','(41) 98751-8234',30000,2,'Parcial'),(26,'Jill','Jimenez','1966-04-06','C','F','[email protected]','(41) 97120-5603',30000,2,'Parcial'),(27,'Jimmy','Moreno','1966-12-16','C','M','[email protected]','(85) 92931-9277',30000,2,'Parcial'),(28,'Bethany','Yuan','1967-02-17','C','F','[email protected]','(62) 92998-6359',10000,2,'Parcial'),(29,'Theresa','Ramos','1967-08-17','C','F','[email protected]','(71) 92187-3667',20000,4,'Ensino médio'),(30,'Denise','Stone','1967-06-06','C','F','[email protected]','(62) 94170-5754',20000,4,'Ensino médio'),(31,'Jaime','Nath','1967-09-18','C','M','[email protected]','(21) 96759-5499',20000,4,'Ensino médio'),(32,'Ebony','Gonzalez','1967-06-14','C','F','[email protected]','(71) 99664-2156',20000,4,'Ensino médio'),(33,'Wendy','Dominguez','1968-02-19','C','F','[email protected]','(31) 97278-7135',10000,2,'Parcial'),(34,'Jennifer','Russell','1998-12-13','C','F','[email protected]','(21) 96714-5068',60000,0,'Parcial'),(35,'Chloe','Garcia','1997-11-22','S','F','[email protected]','(21) 94134-4552',40000,0,'Parcial'),(36,'Diana','Hernandez','1968-03-18','C','F','[email protected]','(85) 93094-3166',10000,2,'Parcial'),(37,'Marc','Martin','1968-12-12','C','M','[email protected]','(11) 92792-7732',30000,3,'Parcial'),(38,'Jesse','Murphy','1997-07-27','C','M','[email protected]','(62) 99674-9226',30000,0,'Parcial'),(39,'Amanda','Carter','1997-10-11','C','F','[email protected]','(71) 98283-7962',60000,0,'Parcial'),(40,'Megan','Sanchez','1997-06-08','C','F','[email protected]',NULL,70000,0,'Parcial'),(41,'Nathan','Simmons','1996-02-19','C','M','[email protected]','(11) 92589-9135',60000,0,'Parcial'),(42,'Adam','Flores','1969-05-19','C','M','[email protected]','(31) 95449-1170',20000,2,'Parcial'),(43,'Leonard','Nara','1970-05-14','S','M','[email protected]','(31) 93245-4616',30000,3,'Ensino médio'),(44,'Christine','Yuan','1970-03-17','C','F','[email protected]','(31) 95294-4775',30000,3,'Ensino médio'),(45,'Jaclyn','Lu','1970-02-22','C','F','[email protected]','(21) 95966-1607',30000,3,'Ensino médio'),(46,'Jeremy','Powell','1970-11-17','C','M','[email protected]','(11) 96739-1309',30000,3,'Ensino médio'),(47,'Carol','Rai','2000-07-13','S','F','[email protected]','(11) 94585-9364',40000,0,'Parcial'),(48,'Alan','Zheng','1971-09-02','C','M','[email protected]','(62) 96866-5250',30000,3,'Ensino médio'),(49,'Daniel','Johnson','1971-07-30','S','M','[email protected]','(31) 98422-3549',30000,3,'Ensino médio'),(50,'Heidi','Lopez','1971-08-02','S','F','[email protected]','(11) 92303-4933',40000,2,'Parcial'),(51,'Ana','Price','2000-08-15','C','F','[email protected]','(21) 99193-2686',60000,0,'Parcial'),(52,'Deanna','Munoz','1972-03-05','C','F','[email protected]','(85) 92440-1858',40000,2,'Parcial'),(53,'Gilbert','Raje','1972-02-29','C','M','[email protected]','(41) 95730-5711',40000,2,'Parcial'),(54,'Michele','Nath','1973-03-29','C','F','[email protected]','(62) 98188-6208',40000,3,'Parcial'),(55,'Carl','Andersen','1973-10-07','C','M','[email protected]','(11) 97180-1463',70000,2,'Graduação'),(56,'Marc','Diaz','1974-04-22','C','M','[email protected]','(41) 92126-6598',80000,2,'Parcial'),(57,'Ashlee','Andersen','1974-03-27','S','F','[email protected]','(85) 97355-1991',80000,2,'Parcial'),(58,'Jon','Zhou','1974-03-12','C','M','[email protected]','(85) 96675-4865',80000,2,'Parcial'),(59,'Todd','Gao','1974-02-22','C','M','[email protected]','(11) 96585-5605',80000,2,'Parcial'),(60,'Noah','Powell','1995-08-28','C','M','[email protected]','(85) 98162-6253',40000,0,'Ensino médio'),(61,'Angela','Murphy','1995-04-02','S','F','[email protected]',NULL,40000,0,'Ensino médio'),(62,'Chase','Reed','1995-12-02','C','M','[email protected]','',40000,0,'Ensino médio'),(63,'Jessica','Henderson','1993-10-04','C','F','[email protected]','(21) 93673-6903',60000,0,'Parcial'),(64,'Grace','Butler','1993-11-22','C','F','[email protected]',NULL,70000,0,'Parcial'),(65,'Caleb','Carter','1996-09-20','S','M','[email protected]','(31) 97809-1800',60000,0,'Parcial'),(66,'Tiffany','Liang','1975-09-18','S','F','[email protected]','(21) 97231-3503',80000,2,'Ensino médio'),(67,'Carolyn','Navarro','1975-09-16','S','F','[email protected]','(21) 94139-6777',80000,2,'Ensino médio'),(68,'Willie','Raji','1975-03-31','C','M','[email protected]','(71) 97614-1995',80000,2,'Ensino médio'),(69,'Linda','Serrano','1975-06-21','S','F','[email protected]','(21) 92428-2938',80000,2,'Ensino médio'),(70,'Casey','Luo','1975-02-01','S','F','[email protected]','(31) 96609-9916',80000,2,'Ensino médio'),(71,'Amy','Ye','1976-08-09','S','F','[email protected]','(41) 92958-3807',70000,2,'Ensino médio'),(72,'Levi','Arun','1976-08-23','S','M','[email protected]','(71) 92754-9983',70000,2,'Ensino médio'),(73,'Felicia','Jimenez','1977-11-11','S','F','[email protected]','(85) 95647-1806',80000,2,'Ensino médio'),(74,'Blake','Anderson','1977-07-08','S','M','[email protected]','(11) 98232-2736',80000,2,'Ensino médio'),(75,'Leah','Ye','1977-09-14','S','F','[email protected]','(31) 95663-3082',80000,2,'Ensino médio'),(76,'Gina','Martin','1994-01-05','S','F','[email protected]','(21) 96190-3171',40000,0,'Ensino médio'),(77,'Donald','Gonzalez','1979-03-06','S','M','[email protected]','(31) 96897-9735',160000,0,'Graduação'),(78,'Damien','Chander','1979-07-12','C','M','[email protected]','(11) 97494-2293',170000,0,'Graduação'),(79,'Savannah','Baker','1986-07-19','C','F','[email protected]','(11) 98574-8482',120000,2,'Pós-graduado'),(80,'Angela','Butler','1986-07-30','S','F','[email protected]','(31) 99100-6309',130000,0,'Graduação'),(81,'Alyssa','Cox','1986-03-10','C','F','[email protected]','(11) 94546-6962',130000,0,'Graduação'),(82,'Lucas','Phillips','1977-09-07','S','M','[email protected]','(62) 94668-3507',80000,2,'Parcial'),(83,'Emily','Johnson','1977-07-14','S','F','[email protected]','(11) 98332-4796',60000,2,'Ensino médio'),(84,'Ryan','Brown','1977-12-18','C','M','[email protected]','(85) 92637-3025',70000,2,'Parcial'),(85,'Tamara','Liang','1977-09-28','C','F','[email protected]','(62) 92170-6794',70000,3,'Parcial'),(86,'Hunter','Davis','1977-11-20','C','M','[email protected]','(85) 99032-4591',80000,2,'Pós-graduado'),(87,'Abigail','Price','1977-01-31','S','F','[email protected]','(62) 98956-4719',80000,2,'Pós-graduado'),(88,'Trevor','Bryant','1977-12-12','S','M','[email protected]',NULL,90000,2,'Parcial'),(89,'Dalton','Perez','1977-03-30','C','M','[email protected]','(21) 98302-8969',90000,2,'Parcial'),(90,'Cheryl','Diaz','1987-05-01','C','F','[email protected]','(71) 93757-3370',90000,2,'Pós-graduado'),(91,'Aimee','He','1987-09-05','C','F','[email protected]','(71) 94329-9879',100000,0,'Graduação'),(92,'Cedric','Ma','1982-03-27','S','M','[email protected]','(31) 95423-4764',70000,1,'Parcial'),(93,'Chad','Kumar','1982-08-27','S','M','[email protected]','(21) 98828-7409',70000,1,'Parcial'),(94,'Andrés','Anand','1982-08-05','C','M','andré[email protected]','(41) 92114-3295',60000,1,'Pós-graduado'),(95,'Edwin','Nara','1981-10-22','C','M','[email protected]','(71) 97194-6478',60000,1,'Parcial'),(96,'Mallory','Rubio','1981-04-26','S','F','[email protected]','(62) 93152-6617',60000,1,'Parcial'),(97,'Adam','Ross','1981-03-03','C','M','[email protected]','(31) 96502-3482',60000,1,'Pós-graduado'),(98,'Latasha','Navarro','1980-09-10','S','F','[email protected]',NULL,60000,1,'Parcial'),(99,'Abby','Sai','1985-05-03','S','F','[email protected]','(85) 98841-5381',70000,0,'Pós-graduado'),(100,'Julia','Nelson','1985-04-16','S','F','[email protected]','(41) 96066-9929',80000,5,'Pós-graduado');
/*!40000 ALTER TABLE `clientes` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2021-10-25 15:13:57