Desafio proposto ao fim da segunda Sprint do Programa de Bolsas de NodeJS da Compass.uol.
- Introdução ao SQL com MySQL: Manipule e consulte dados
- Consultas SQL: Avançando no SQL com MySQL
- Modelagem de banco de dados: entidades, relacionamentos e atributos
- MongoDB: Uma alternativa aos bancos relacionais tradicionais
![scrum proccess](https://user-images.githubusercontent.com/65569815/179436690-c9a463b4-f509-4986-9de6-8f8533ab9170.png)
FieldName | Type | Required | Unique |
---|---|---|---|
cleaner_id |
Integer | true | true |
cpf |
Varchar | true | true |
name |
Varchar | true | false |
FieldName | Type | Required | Unique |
---|---|---|---|
responsible_id |
Integer | true | true |
cpf |
Varchar | true | true |
name |
Varchar | true | false |
FieldName | Type | Required | Unique |
---|---|---|---|
size_id |
Integer | true | true |
description |
Varchar | true | false |
cleaning_price |
Float | true | false |
FieldName | Type | Required | Unique | Primary Key | Foreign Key |
---|---|---|---|---|---|
residence_id |
Integer | true | true | true | false |
city |
Varchar | true | false | false | false |
neighborhood |
Varchar | true | false | false | false |
street |
Varchar | true | false | false | false |
complement |
Varchar | false | false | false | false |
size_id |
Integer | true | false | false | true |
responsible_id |
Integer | true | false | false | true |
FieldName | Type | Required | Unique | Primary Key | Foreign Key |
---|---|---|---|---|---|
cleaning_id |
Integer | true | true | true | false |
scheduled_date |
Date | false | false | false | false |
realization_date |
Date | false | false | false | false |
must_be_paid |
Bit | false | false | false | false |
was_paid |
Bit | true | false | false | false |
responsible_evaluation |
Enum | false | false | false | false |
responsible_feedback |
Varchar | false | false | false | false |
cleaner_id |
Integer | true | false | false | true |
residence_id |
Integer | true | false | false | true |