Crate entities tables models for inventory

[Norbbs]

As a Data Owner I want to create a entity model So that I can assure my data will have the quality required for the product

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

Create an entity model with these following:

1. inventories

Property	Key	Type	Nullable	Limit	Example
id	PRIMARY	INTEGER	NOT NULL	AUTO INCREMENT	1
house_id	MS	INTEGER	NOT NULL	AANG	1
house_description	MS	TEXT(30)	NOT NULL	AANG	BEACH HOUSE
quantity		DECIMAL(10, 2)	NOT NULL	99999999.99	500.00
uom_id	MS	INTEGER	NOT NULL	TOPH	1
uom_abbrevation	MS	TEXT(12)	NOT NULL	TOPH	KG
purchase_date		DATE	NOT NULL	NOT FUTURE DATE	15-12-2024
expiration_date		DATE		NOT PAST DATE	15-12-2024
catalog_id	MS	INTEGER	NOT NULL	ZUKO	1
catalog_description	MS	TEXT(150)	NOT NULL	ZUKO	PRODUCT TYPE + PRESENTATION
brand_name	MS	TEXT(30)	NOT NULL	ZUKO	Soprole
category_name	MS	TEXT(30)	NOT NULL	ZUKO	Dairy
product_status_id	FOREIGN	INTEGER	NOT NULL	product_status	1

Out of scope

1. Any others tables not indicating in the scope

Acceptance Criteria

		AC	GIVEN	WHEN	THEN
- [ ]	1	Entity model review	a entities/tables described in the scope section	Data Owner goes to database model	the tables will appear deployed successfully in google cloud console

Definition of Done (DoD)

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