| Field Name | Data Type | Description |
|---|---|---|
| breed_id | INTEGER (PK) | Unique identifier ng mango breed |
| common_name | VARCHAR(100) | Karaniwang pangalan ng mangga |
| scientific_name | VARCHAR(150) | Scientific name (Mangifera indica) |
| origin_country | VARCHAR(100) | Bansang pinagmulan |
| origin_region | VARCHAR(100) | Rehiyon / probinsya ng pinagmulan |
| skin_color | VARCHAR(50) | Kulay ng balat |
| flesh_color | VARCHAR(50) | Kulay ng laman |
| taste_profile | VARCHAR(100) | Matamis, maasim, balanced, etc. |
| fiber_level | ENUM (Low, Medium, High) | Antas ng hibla |
| average_weight_g | DECIMAL(6,2) | Karaniwang bigat (grams) |
| harvest_season | VARCHAR(50) | Panahon ng anihan |
| tree_height_m | DECIMAL(4,2) | Karaniwang taas ng puno |
| shelf_life_days | INTEGER | Tinatayang shelf life |
| main_uses | VARCHAR(150) | Fresh, dried, juice, processing |
| export_quality | BOOLEAN | Angkop sa export |
| notes | TEXT | Karagdagang detalye |
| Field Name | Data Type | Description |
|---|---|---|
| farm_id | INTEGER (PK) | Unique farm identifier |
| farm_name | VARCHAR(150) | Pangalan ng farm |
| location | VARCHAR(150) | Lokasyon |
| area_hectares | DECIMAL(6,2) | Lawak ng sakahan |
| Field Name | Data Type |
|---|---|
| farm_id | INTEGER (FK) |
| breed_id | INTEGER (FK) |
1breed_id: 1
2common_name: Carabao Mango
3scientific_name: Mangifera indica
4origin_country: Philippines
5origin_region: Guimaras
6skin_color: Yellow
7flesh_color: Golden Yellow
8taste_profile: Very Sweet
9fiber_level: Low
10average_weight_g: 350
11harvest_season: March–May
12tree_height_m: 10
13shelf_life_days: 14
14main_uses: Fresh, Export
15export_quality: true