Esta es mi base de datos ya terminada...
Código SQL
[-]CREATE DATABASE EVENTOS
GO
USE EVENTOS
GO
create TABLE CATEGORIA
(
idcategoria int identity(1,1) primary key,
nom_categoria varchar(100) not null
)
create TABLE TIPO_ITEM
(
idtipoitem int identity(1,1) primary key,
idcategoria int foreign key references CATEGORIA(idcategoria),
nom_tipoitem varchar(100) not null
)
create TABLE ITEM
(
iditem int identity(1,1) primary key,
idtipoitem int foreign key references TIPO_ITEM(idtipoitem),
des_item varchar(100) not null,
con_item varchar(20) not null,
sto_item int not null
)
create TABLE DETALLE_ITEM
(
iddetalleitem int identity(1,1) primary key,
idtipoitem int foreign key references TIPO_ITEM(idtipoitem),
med_detalleitem varchar(50) not null,
cap_detalleitem int not null,
dir_detalleitem varchar(100) not null
)
create TABLE PROVEEDOR
(
idproveedor int identity(1,1) primary key,
ruc_proveedor char(11) not null,
rzo_proveedor varchar(100) not null,
con_proovedor varchar(100) not null,
cel_proovedor varchar(12) not null,
dir_proovedor varchar(100) not null,
tel_proovedor varchar(11) null,
ema_proovedor varchar(80) null,
est_proovedor varchar(1) not null
)
create TABLE PERSONAL
(
idpersonal int identity(1,1) primary key,
nom_personal varchar(80) not null,
ape_personal varchar(100) not null,
dni_personal varchar(8) not null,
fna_personal date not null,
dir_personal varchar(100) not null,
tel_personal varchar(11) null,
cel_personal varchar(13) not null,
esc_personal varchar(25) not null,
ema_personal varchar(100) not null,
car_personal varchar(30) not null,
est_personal varchar(1) not null
)
create TABLE PRECIOS
(
idprecio int identity(1,1) primary key,
iditem int foreign key references ITEM(iditem),
idproveedor int foreign key references PROVEEDOR(idproveedor),
fec_precios date not null,
pco_precios double(6,2) not null,
pve_precios double(6,2) not null,
uti_precios double(6,2) not null
)
create TABLE COTIZACION
(
idcotizacion int identity(1,1) primary key,
sol_cotizacion varchar(150) not null,
tel_cotizacion varchar(13) not null,
des_cotizacion varchar(100) not null,
inv_cotizacion varchar(8) not null,
fec_cotizacion date not null,
idproveedor int foreign key references PROVEEDOR(idproveedor)
)
create TABLE EVENTO
(
idevento int identity(1,1) primary key,
idcotizacion int foreign key references COTIZACION(idcotizacion),
hin_evento date not null,
hfi_evento date not null,
est_evento varchar(15) not null,
dir_evento varchar(150) not null,
idpersonal int foreign key references PERSONAL(idpersonal),
tev_evento varchar(70) not null,
fec_evento date not null
)
create TABLE MENAJE
(
idmaneja int identity(1,1) primary key,
idcotizacion int foreign key references COTIZACION(idcotizacion),
iditem int foreign key references ITEM(iditem)
)
create TABLE CLIENTE
(
idcliente int identity(1,1) primary key,
tip_cliente char(1) not null,
tdo_cliente varchar(20) not null,
ndo_cliente varchar(11) not null,
nom_cliente varchar(150) not null,
dir_cliente varchar(150) not null,
tel_cliente varchar(13) not null,
ema_cliente varchar(100) null
)
create TABLE CONTRATO
(
idcontrato int identity(1,1) primary key,
idcliente int foreign key references CLIENTE(idcliente),
fec_contrato date not null,
est_contrato varchar(50) not null,
idevento int foreign key references EVENTO(idevento),
cuo_contrato int not null,
imp_contrato double not null,
ima_contrato image not null
)
create TABLE COMPRA
(
idcompra int identity(1,1) primary key,
idproovedor int foreign key references PROVEEDOR(idproveedor),
iditem int foreign key references ITEM(iditem),
ser_compra varchar(6) not null,
nco_compra varchar(8) not null
)
create TABLE ALQUILER
(
idalquiler int identity(1,1) primary key,
idproovedor int foreign key references PROVEEDOR(idproveedor),
iditem int foreign key references ITEM(iditem),
idcontrato int foreign key references CONTRATO(idcontrato)
)