CREATE TABLE Rol(
	id INTEGER PRIMARY KEY IDENTITY,
	nombre varchar(100),
)

CREATE TABLE Local(
	id INTEGER PRIMARY KEY IDENTITY,
	ciudad varchar(100),
	pais varchar(100),
	direccion varchar(100),
)


CREATE TABLE Usuario(
	id INTEGER PRIMARY KEY IDENTITY,
	nombre varchar(100),
	apellido varchar(100),
	password varchar(100),
	email varchar(100),
	username varchar(100),
	rol_id integer FOREIGN KEY REFERENCES Rol(id),
	local_id integer FOREIGN KEY REFERENCES Local(id),
)


CREATE TABLE Producto(
	id INTEGER PRIMARY KEY IDENTITY,
	nombre varchar(100),
)

CREATE TABLE Size(
	id INTEGER PRIMARY KEY IDENTITY,
	nombre varchar(100),
	precio decimal,
)

CREATE TABLE VarProd(
	id INTEGER PRIMARY KEY IDENTITY,
	nombre varchar(100),
	precio decimal,
	image varchar(100),
	product_id integer FOREIGN KEY REFERENCES Producto(id),
	size_id integer FOREIGN KEY REFERENCES Size(id),
)

CREATE TABLE Combo(
	id INTEGER PRIMARY KEY IDENTITY,
	nombre varchar(100),
	validoHasta datetime,
	precio decimal,
	image varchar(100),
	size_id integer FOREIGN KEY REFERENCES Size(id),
)


CREATE TABLE Combo_VarProd_Rel(
	id INTEGER PRIMARY KEY IDENTITY,
	combo_id integer FOREIGN KEY REFERENCES Combo(id) ON DELETE CASCADE,
	varprod_id integer FOREIGN KEY REFERENCES VarProd(id) ON DELETE CASCADE,
)



CREATE TABLE ComboDia(
	id INTEGER PRIMARY KEY IDENTITY,
	dia varchar(100),
	precio decimal,
	combo_id integer FOREIGN KEY REFERENCES Combo(id),
)


CREATE TABLE Cupon(
	id INTEGER PRIMARY KEY IDENTITY,
	codigo int,
	activo bit,
	cantidad int,
	descuento decimal,
	combo_id integer FOREIGN KEY REFERENCES Combo(id),
)

DROP TABLE Cupon;