🍊 Data Model: Orange Breeds
Entity: Orange_Breed
| Field Name |
Data Type |
Description |
| breed_id |
INTEGER (PK) |
Unique identifier ng orange breed |
| common_name |
VARCHAR(100) |
Karaniwang pangalan ng orange |
| scientific_name |
VARCHAR(150) |
Scientific name (Citrus sinensis) |
| origin_country |
VARCHAR(100) |
Bansang pinagmulan |
| origin_region |
VARCHAR(100) |
Rehiyon ng pinagmulan |
| peel_color |
VARCHAR(50) |
Kulay ng balat |
| flesh_color |
VARCHAR(50) |
Kulay ng laman |
| taste_profile |
VARCHAR(100) |
Sweet, tart, balanced |
| juiciness_level |
ENUM (Low, Medium, High) |
Antas ng katas |
| average_weight_g |
DECIMAL(6,2) |
Karaniwang bigat (grams) |
| harvest_season |
VARCHAR(50) |
Panahon ng anihan |
| seed_count |
INTEGER |
Karaniwang dami ng buto |
| storage_life_days |
INTEGER |
Shelf/storage life |
| main_uses |
VARCHAR(150) |
Fresh, juice, marmalade |
| export_quality |
BOOLEAN |
Angkop sa export |
| climate_type |
VARCHAR(100) |
Subtropical, tropical |
| notes |
TEXT |
Karagdagang detalye |
Optional Entity: Orange_Orchard
| Field Name |
Data Type |
Description |
| orchard_id |
INTEGER (PK) |
Unique orchard identifier |
| orchard_name |
VARCHAR(150) |
Pangalan ng orchard |
| location |
VARCHAR(150) |
Lokasyon |
| area_hectares |
DECIMAL(6,2) |
Lawak ng taniman |
Junction Table: Orchard_Orange_Breed
| Field Name |
Data Type |
| orchard_id |
INTEGER (FK) |
| breed_id |
INTEGER (FK) |
Example Record
breed_id: 1
common_name: Valencia Orange
scientific_name: Citrus sinensis
origin_country: Spain
origin_region: Valencia
peel_color: Bright Orange
flesh_color: Orange
taste_profile: Sweet
juiciness_level: High
average_weight_g: 180
harvest_season: March–June
seed_count: 2
storage_life_days: 120
main_uses: Juice, Fresh
export_quality: true
climate_type: Subtropical
