TjYNNXmJ

1DROP TABLE IF EXISTS Cliente;
2DROP TABLE IF EXISTS Servico;
3DROP TABLE IF EXISTS Reserva;
4 
5CREATE TABLE Cliente
6(
7  IDCliente IDENTITY,
8  Nome VARCHAR(25) NOT NULL,
9  Sobrenome VARCHAR(25) NOT NULL,
10  Sexo TINYINT NOT NULL,
11  DataNascimento DATE NULL,
12  Profissao VARCHAR(30),
13  TelefoneFixo CHAR(14),
14  TelefoneCelular CHAR(14),
15  constraint pk_Cliente PRIMARY KEY(IDCliente) 
16);
17 
18CREATE TABLE Servico
19(
20  IDServico IDENTITY,
21  Tipo TINYINT NOT NULL,
22  Nome VARCHAR(30) NOT NULL,
23  Descricao VARCHAR(512) NOT NULL,
24  Preco DECIMAL (6,2),
25  constraint pk_Servico PRIMARY KEY(IDServico)
26);
27 
28CREATE TABLE Reserva
29(
30  IDReserva IDENTITY,
31  Estado TINYINT NOT NULL,
32  Data Date NOT NULL,
33  Hora Time NOT NULL,
34  IDCliente_Cliente BIGINT NOT NULL,
35  IDServico_Servico BIGINT NOT NULL,
36  constraint pk_Reserva PRIMARY KEY(IDReserva),
37  constraint fk_Reserva_pk_Cliente FOREIGN KEY (IDCliente_Cliente) 
38  	REFERENCES Cliente (IDCliente)
39  	ON DELETE NO ACTION
40  	ON UPDATE NO ACTION,  
41  constraint fk_Reserva_pk_Servico FOREIGN KEY (IDServico_Servico) 
42  	REFERENCES Servico (IDServico)
43  	ON DELETE NO ACTION
44  	ON UPDATE NO ACTION 
45)