This repo will try to talk with a PostgreSQL database to check and show requirements and materials to craft an item. Based on a simple interface and backend.
The interface may allow the user to:
- Show the current amount of a Product.
- Show the requirements to craft a Product using a Recipe.
- Show a % of materials obtained of the required to craft a Product using a Recipe.
- Show the % of materials obtained of the recursively required to craft a Product using a Recipe.
- Product may be crafted using a Recipe.
- All Recipes may need 1-4 Product types and an specific amount.
| Field | Type |
|---|---|
| id | int |
| name | text |
| craft | :fk:recipe_id |
| stock | int |
| Field | Type |
|---|---|
| id | int |
| result | :fk:product_id |
| req.1 | :fk:product_id |
| num.1 | int |
| req.2 | :fk:product_id |
| num.2 | int |
| req.3 | :fk:product_id |
| num.3 | int |
| req.4 | :fk:product_id |
| num.4 | int |