Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create database unihouse;
- use unihouse;
- /*- Inserts completos -*/
- create table endereco(
- ID_end smallint primary key not null,
- rua varchar(30),
- num_casa smallint,
- bairro varchar(30),
- cidade varchar(30),
- estado varchar(3),
- cep int
- );
- /*- inserts comletos-*/
- create table dispositivos(
- id_disp smallint primary key not null,
- nome_disp varchar(20),
- ip_disp varchar(20),
- hora_ini datetime,
- hora_fim datetime
- );
- /*- Inserts completos -*/
- create table banco(
- cod_banco smallint primary key not null,
- nome varchar(30)
- );
- /*- Inserts completos -*/
- create table cartao(
- ID_card int primary key not null,
- num_card varchar(30),
- validade date,
- cod_banco smallint,
- cod_agencia int,
- cvv smallint,
- foreign key(cod_banco) references banco(cod_banco)
- );
- /*- Inserts completos-*/
- create table cliente(
- cod_cliente int primary key not null,
- cpf varchar(20),
- nome varchar(30),
- apelido varchar(10),
- email varchar(50),
- telefone varchar(10),
- ID_end smallint,
- ID_disp smallint,
- ID_card int,
- foreign key(ID_end) references endereco(ID_end),
- foreign key(ID_disp) references dispositivos(ID_disp),
- foreign key(ID_card) references cartao(ID_card)
- );
- /*- Inserts completos-*/
- create table funcionario(
- matricula int primary key not null,
- nome varchar(30),
- telefone varchar(10),
- ID_end smallint,
- foreign key(ID_end) references endereco(ID_end)
- );
- /* -
- * - 0000 000000000 000000000 0000000000000 00000000000000 0000000000
- * - 0000 00000000000 000000000 0000 000000 00000000000000 00000000000000
- * - 0000 000 0000 0000000 00000000000000 000000
- * - 0000000 0000000000 00000000 0000 0000000 00000 00000000000
- * - 0000 0000000 00000000 00000 000000000 00000 00000000
- * - 0000 000000 0000 00000 000000 00000 0000000
- * - 0000 000000 000000000 00000 000000 00000 00000000
- * - 00000000 0000000 000000000 00000 000000 00000 0000000000
- - */
- insert into endereco values
- (1,"Travessa Maravilha tristeza",85,"Jardim Boa vista","São paulo","SP",5576100),
- (2,"Rua do corno",803,"São luiz","Maranhão","MA",65604450),
- (3,"Rua Tapaxanas",4,"Diadema","São paulo","SP",16050063),
- (4,"Rua deus te guarde",100,"Recife","Pernambuco","PE",55028490),
- (5,"Rua borboletas psicodélicas",2800,"Centro","São paulo","SP",03311060),
- (6,"Rua sessenta e nove",74,"Campo Grande","Rio de Janeiro","RJ",28894643),
- (7,"Rua arthur broxado",337,"Macaé","Rio de Janeiro","RJ",24720270),
- (8,"Travessa Mário cinco paus",18,"Macaé","Rio de Janeiro","RJ",25926756),
- (9,"Estrada pé do viado",723,"Itabaiana","Sergipe","SE",49009028),
- (10,"Rua Eduardo Mukdese",4619,"Vila Mariana","Aparecida de Goiânia","GO",74938100),
- (11,"Rua da feia",69,"Buzios","Rio de Janeiro","RJ",24474190),
- (12,"Vila Sarmieri",89,"Centro","Nilópolis","RJ",26525750),
- (13,"Rua das Pedras Preciosas",9,"Parque de Exposições","Parnamirim","RN",59146580),
- (14,"Quadra CLS 409 Bloco D",409,"Asa Sul","Brasília","DF",70258540),
- (15,"Rua Gonçalves Dias",77,"Mata de Itapera","São Luís","MA",65092134),
- (16,"Rua do Contorno ",2,"Carrascal","Quixadá","CE",63902265),
- (17,"Rua Tércio Rosado",69,"Aeroporto","Mossoró","RN",59607550),
- (18,"Rua Manoel Anastácio",24,"Jardim Cibeli","Araranguá","SC",88901270),
- (19,"Rua Professor Antônio Aleixo",684,"Jardim Vera Cruz","Anápolis","GO",75104770),
- (20,"Rua Tucandeira",771,"Tarumã-Açu","Manaus","AM",69022362);
- insert into dispositivos values
- (21,"ESTACAO01","192.168.1.1",'2018-08-11 10:18:0','2018-08-11 11:17:0'),
- (22,"ESTACAO02","192.168.1.2",'2018-08-12 09:18:0','2018-08-12 12:13:0'),
- (23,"ESTACAO03","192.168.1.3",'2018-08-13 08:18:0','2018-08-13 18:17:0'),
- (24,"ESTACAO04","192.168.1.4",'2018-08-11 10:00:0','2018-08-11 10:58:0'),
- (25,"ESTACAO05","192.168.1.5",'2018-08-11 17:01:0','2018-08-11 22:05:0'),
- (26,"IMP01","192.168.1.6",'2018-08-11 10:18:5','2018-08-11 10:22:5'),
- (27,"IMP02","192.168.1.7",'2018-08-13 08:18:0','2018-08-13 18:17:0'),
- (28,"IMP03","192.168.1.8",'2018-08-11 10:18:5','2018-08-11 11:17:5'),
- (29,"SCAN01","192.168.1.9",'2018-08-11 10:18:5','2018-08-11 11:17:5'),
- (30,"SCAN02","192.168.1.10",'2018-08-13 08:18:0','2018-08-13 18:17:0');
- insert into banco values
- (1,"Banco do Brasil S.A"),
- (33,"Banco Santander S.A"),
- (237,"Banco Bradesco S.A"),
- (341,"Itaú Unibanco S.A"),
- (104,"Caixa Econômica Federal");
- insert into cartao values
- (50,"5475 2598 2300 1968",'2019-10-29',33,78998,759),
- (51,"4576 3139 7940 9623",'2019-04-29',104,15015,307),
- (52,"4389 3565 5025 8148",'2019-10-29',341,30814,963),
- (53,"3551 8334 0824 4672",'2019-10-29',1,83013,443),
- (54,"2014 6169 0571 3181",'2020-02-29',104,23012,626),
- (55,"3422 7761 0533 7360",'2019-09-29',1,33011,665),
- (56,"4916 8512 9678 1421",'2019-08-29',237,43010,361),
- (57,"6011 0383 0658 5328",'2020-05-29',237,53317,759),
- (58,"5260 0264 3154 2561",'2029-08-29',104,66014,394),
- (59,"4556 6390 7959 6099",'2021-07-29',1,77013,709),
- (60,"4716 5387 7956 2608",'2022-01-29',33,89012,539),
- (61,"4223 7998 0096 8141",'2019-12-02',1,99816,975),
- (62,"5269 4111 4539 4510",'2018-11-08',1,74134,100),
- (63,"9168 5475 2598 2300",'2019-10-29',341,03014,222),
- (64,"3033 627 302 6528",'2018-12-31',33,87014,333),
- (65,"6011 0368 3650 5337",'2019-10-29',1,69017,759),
- (66,"2149 966 2178 3357",'2020-10-29',341,37013,559),
- (67,"4118 6091 3237 8927",'2021-10-29',33,70104,259),
- (68,"4454 5245 5029 2827",'2025-10-29',341,83018,509),
- (69,"4539 9620 4782 5230",'2031-10-29',237,50149,159);
- insert into cliente values
- (1,"190.923.760-43","Miguel Pereira Peixoto","Mipe","mppeixoto@unicarioca.edu.br","2222-0245",1,30,50),
- (2,"406.483.760-60","Manuela Angel da Silveira","Manu","manu@unicarioca.edu.br","3352-0045",2,21,51),
- (3,"571.180.680-71","Bernardo Santos","Mipe","bernardo@gmail.com","7232-5245",3,27,52),
- (4,"360.743.350-01","Daniel Ferreira","gueta","daniel@unicarioca.edu.br","2211-4001",4,30,53),
- (5,"590.965.150-13","Ana Julia","aninha","ana@unicentro.com.br","2882-5000",5,29,54),
- (6,"101.341.990-14","Yudi Tamashiro","Preyx","yudi@sbt.com.br","4002-8922",6,23,55),
- (7,"201.517.940-22","Rafaela Pereira","Faela","rafa@unicarioca.edu.br","2222-0245",7,25,56),
- (8,"443.046.620-31","Benjamin Scrowisck","ben","bens@hotmail.com","3245-8744",8,26,57),
- (9,"203.190.890-10","Maria Fernanda","mari","marife@unicarioca.edu.br","2217-1822",9,28,58),
- (10,"693.824.370-02","João Gabrie","gabriel","joao@sentivale.ch","2874-0245",10,22,59);
- insert into funcionario values
- (4118,"Isaac Renato Moura",'2215-5463',11),
- (6091,"Carlos Kauê Almeida",'3772-8877',12),
- (3237,"Luís Kaique João Ribeiro",'2545-1364',13),
- (8927,"Rita Heloisa Carvalho",'2759-7961',14),
- (4916,"Alícia Camila da Silva",'2178-4112',15),
- (4127,"Carla Luzia Eduarda Dias",'4004-8922',16),
- (7636,"Emanuelly Betina da Mata",'3675-4412',17),
- (9342,"César Hugo Vicente Carvalho",'3587-2019',18),
- (1234,"Lucca Victor Breno Gomes",'2018-2017',19),
- (4567,"Stefany Esther Farias",'2255-4788',20);
Add Comment
Please, Sign In to add comment