Product Module | Database Design

## Database Design Review for `agrokart_core_java`

### Overview
The current database design for the `agrokart_core_java` project needs to be reviewed to ensure it aligns with the project's requirements.

### Table Structure

#### categories
- Columns: id (INT), name (VARCHAR)
- Relationships: None

#### units
- Columns: id (INT), unit (VARCHAR)
- Relationships: None

#### status
- Columns: id (INT), name (VARCHAR)
- Relationships: None

#### product
- Columns: id (INT), eng_name (VARCHAR), tam_name (VARCHAR), image_url (VARCHAR), category_id (INT), description (VARCHAR), created_date (DATE), created_time (TIME), updated_date (DATE), updated_time (TIME), status_id (INT)
- Relationships: category_id (references categories), status_id (references status)

#### product_available_stock
- Columns: id (INT), product_id (INT), weight (DOUBLE), unit_id (INT)
- Relationships: product_id (references product), unit_id (references units)

#### product_nutr
- Columns: id (INT), product_id (INT), protein (DOUBLE), protein_unit_id (INT), carbohydrates (DOUBLE), carbo_unit_id (INT), calories (DOUBLE), cal_unit_id (INT)
- Relationships: product_id (references product), protein_unit_id (references units), carbo_unit_id (references units), cal_unit_id (references units)

#### product_quantities_cat
- Columns: id (INT), product_id (INT), weight (DOUBLE), unit_id (INT), rupees (DOUBLE)
- Relationships: product_id (references product), unit_id (references units)

### Proposed Review Steps
1. **Review Relationships:** Validate that relationships between tables are accurately established.
2. **Constraints Check:** Ensure primary keys, foreign keys, and unique constraints are correctly defined.
3. **Data Types:** Verify that the data types chosen for each column are appropriate.
4. **Requirement Alignment:** Assess if the database design meets the functional requirements.

### Concerns
- **Data Duplication:** Review possible data duplication concerns in the `categories`, `units`, and `status` tables.

### Related Resources
- [Schema SQL File](https://github.com/fssa-batch3/sec_c_sec_c_hemanath.muralikrishnan__corejava_project_2/blob/main/src/main/sql/productscripts.sql)

### Labels
- database design
- code review