create database dbsoftdevquote;
go
use dbsoftdevquote;
go
create table tuser
(
idUser char(36) not null primary key,
email varchar(700) not null,
password varchar(max) not null
);
go
create table tprofessional
(
idProfessional char(36) not null primary key,
name varchar(700) not null,
monthPay decimal(20, 10) not null
);
go
create table tprojecttype
(
idProjectType char(36) not null primary key,
name varchar(700) not null
);
go
create table tprojecttypemechanism
(
idProjectTypeMechanism char(36) not null primary key,
idProjectType char(36) not null,
name varchar(700) not null,
devMonthsQuantity float not null,
foreign key(idProjectType) references tprojecttype(idProjectType)
on delete cascade on update cascade
);
go
create table tassignproject
(
idAssignProject char(36) not null primary key,
idProjectTypeMechanism char(36) not null,
idProfessional char(36) not null,
professionalMonthQuantity int null,
addProfessional bit not null,
addProfessionalReducedMonth float not null,
foreign key(idProjectTypeMechanism) references tprojecttypemechanism(idProjectTypeMechanism)
on delete cascade on update cascade,
foreign key(idProfessional) references tprofessional(idProfessional)
on delete cascade on update cascade
);