use master
go
create database Taller_Mecanico
go
use Taller_Mecanico
SET DATEFORMAT DMY
go

create table Hojap(
id_hoja varchar(4) primary key not null,
concepto  varchar(50) not null,
cantidad varchar(50) not null,
id_rep varchar(4) not null,
id_mec varchar(4) not null)
go

create table Repuesto(
id_rep varchar(4) primary key not null,
descripcion varchar(50) not null,
costo_unit money not null,
precio_unit money not null)
go

create table Factura(
n_fact varchar(4) primary key not null,
fecha date not null,
imp_pesos money not null,
imp_dol money not null,
Rfc varchar(10) not null,
id_hoja varchar(4) not null)
go

create table Mecanico(
id_mec varchar(4) primary key not null,
nombre varchar(50) not null,
direccion varchar(50) not null,
telef numeric(9) not null,
costo_hora money not null)
go

create table Cliente(
Rfc varchar(10) primary key not null,
nombre varchar(50) not null,
direccion varchar(50) not null,
telef numeric(9) not null)
go

create table Vehiculo(
matricula varchar(6) primary key not null,
modelo varchar(50) not null,
color varchar(50) not null,
fecha_ent date not null,
hora_ent time not null,
Rfc varchar(10) not null,
id_mec varchar(4) not null)
go


alter table Factura
add constraint FK_Hojap_Factura
foreign key (id_hoja)
references Hojap(id_hoja)
go


alter table Hojap
add constraint FK_Repuesto_Hojap
foreign key (id_rep)
references Repuesto(id_rep)
go


alter table Hojap
add constraint FK_Mecanico_Hojap
foreign key (id_mec)
references Mecanico(id_mec)
go


alter table Factura
add constraint FK_Cliente_Factura
foreign key (Rfc)
references Cliente(Rfc)
go


alter table Vehiculo
add constraint FK_Cliente_Vehiculo
foreign key (Rfc)
references Cliente(Rfc)
go


alter table Vehiculo
add constraint FK_Mecanico_Vehiculo
foreign key (id_mec)
references Mecanico(id_mec)
go