Add house

[Norbbs]

As a Data Owner I want to add a house to the other users So that they can access and utilize the data related to the house for their respective needs

Definition Of Ready (DoR)

	Definition	Observations
- [x]	The story meet the INVEST and SMART criteria
- [x]	Dependencies identified and resolved
- [x]	Written acceptance criteria with test scenarios, understood by the team and agreed upon
- [x]	The user story was understood and agreed upon in a refinement session with the dev team
- [x]	The team has an idea of how to make the demonstration of the finished story

Scope

1. Build an entity "House" with the following fields:

   • id (integer, mandatory).
   • description (string, mandatory, max 30 chatacters).
   • city_id (foreign key)

2. Create an entity "Cities"

   • Id (integer, mandatory)
   • description (string, mandatory)

3. Add a new entity to the table "houses".
4. Build an entity "PersonHouse" with the following fields:> -personId (integer, mandatory).

   • houseId (integer, mandatory).
   • isDefault (boolean, mandatory).

5. Add a new register to the table "persons_houses"with the following:

   -personId: Person selected id. -houseId: ID of the newly created 'house' entity. -isDefault: boolean field with the value selected.

Out of scope

1. Any other process other than adding houses
2. For the cities entity: province, region and country are out of scope.

Acceptance Criteria

		AC	GIVEN	WHEN	THEN
- [x]	1	Add new house successfully	a house description correctly	the house registration process is triggered	a new house will be added to the table houses.
- [ ]	2	Add new house successfully	a house description correctly	the house registration process is triggered	a new house and person will be added to the table _personshouses .
- [x]	3	Add new house successfully with isDefault property is true	a house description correctly and isDefault property is true	the house registration process is triggered	a new person will be added to the table houses with isDefault property true.
- [x]	4	Add new house successfully with isDefault property is true	a house description correctly and isDefault property is false	the house registration process is triggered AND the person has NOT any house registered	a new house will be added to the table houses with isDefault property true.
- [x]	5	Add new house successfully with isDefault property is true	a house description correctly and isDefault property is true	the house registration process is triggered AND the person has at least one house registered	a new house will be added to the table houses with isDefault property true AND set the isDefault property false and the old one will be updated with isDefault property false.
- [x]	6	Add new house successfully with isDefault property is false	a house description correctly and isDefault property is false	the house registration process is triggered AND the person has at least one house registered	a new house will be added to the table houses with isDefault property false.
- [x]	7	No add new house because of lack of description	a house description null or empty	the house registration process is triggered	a new house WON'T be added to the table houses niether _housespersons.
- [x]	8	No add new house because of maximum characters allows	a house description with more than 30 characters	the house registration process is triggered	a new house WON'T be added to the table houses niether _housespersons.
- [x]	9	No add new house because of data duplication	a house description correctly AND person has one house with the SAME description in the SAME city registered	the house registration process is triggered	a new house WON'T be added to the table houses niether _housespersons.
- [x]	10	No add new house because of lack of city	a house's city is null or empty	the house registration process is triggered	a new house WON'T be added to the table houses niether _housespersons.
- [ ]	11	Add new house NOT because of data duplication	a house description correctly AND person has one house with the SAME description but NOT in the SAME city registered	the house registration process is triggered	a new house will be added to the table houses AND _housespersons.
- [ ]	12	Add new house NOT because of data duplication	a house description correctly AND person has one house with a DIFFERENT description but in the SAME city registered	the house registration process is triggered	a new house will be added to the table houses AND _housespersons.
- [ ]	13	Add new house NOT because of data duplication	a house description correctly AND person has one house with a DIFFERENT description in a DIFFERENT city registered	the house registration process is triggered	a new house will be added to the table houses AND _housespersons.

Definition of Done (DoD)

	Definition	Result
- [x]	All acceptance criteria have been met
- [x]	No significant or critical defects
- [x]	Deskcheck ceremony has been made
- [x]	Keep minimum test coverage of 80% over the necessary code and components
- [x]	Technical documentation published
- [x]	Spike, PoC or benchmarks findings documented