lab02-db.sql

create database TienditaDeDonPepe
use TienditaDeDonPepe

create table customer(
customerId int primary key identity,
name varchar(45),
lastname varchar(45),
telephone int,
address varchar(75),
dni int)

create table purchaseHistory(
purchaseId int primary key identity,
purchaseDate datetime,
purchaseAmount money,
purchaseQuantity int,
purchaseMethod varchar(35),
ticketNumber int,
customerId int references customer(customerid),
productId int references product(productId),
)

create table product(
productId int primary key identity,
name varchar(35),
price money,
imageProduct image,
datasheet varchar(200),
description varchar(75),
brandId int references brand(brandId),
categoryId int references category(categoryId),
inventoryId int references inventory(inventoryId))

create table inventory(
inventoryId int primary key identity,
stock int,
lastUpdate datetime
)

create table brand(
brandId int primary key identity,
name varchar(50),
imageBrand image,
description varchar(150)
)

create table category(
categoryId int primary key identity,
name varchar(35),
detail varchar(100)
)