-- MySQL dump 10.13  Distrib 8.0.27, for Linux (x86_64)
--
-- Host: localhost    Database: essoildb
-- ------------------------------------------------------
-- Server version	8.0.27

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `plantpart`
--

DROP TABLE IF EXISTS `plantpart`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `plantpart` (
  `ppid` int NOT NULL AUTO_INCREMENT,
  `ppname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ppid`)
) ENGINE=InnoDB AUTO_INCREMENT=238 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plantpart`
--

LOCK TABLES `plantpart` WRITE;
/*!40000 ALTER TABLE `plantpart` DISABLE KEYS */;
INSERT INTO `plantpart` VALUES (1,'Aerial Parts'),(2,'Aerial parts'),(3,'Aerial parts & raw Seed'),(4,'Aerial parts & raw seeds'),(5,'Aerial parts ( leaves, stems, and flowers )'),(6,'Aerial parts (Female)'),(7,'Aerial parts(  Male)'),(8,'Air dried leaves'),(9,'Bark'),(10,'Basal leaves'),(11,'Blossoms (flowers)'),(12,'Branch'),(13,'Crushed clove bud'),(14,'Dried Fruit'),(15,'Dried husk'),(16,'Dry Aerial parts'),(17,'Dry Whole plant'),(18,'Dry leaves'),(19,'During flowering'),(20,'Female Bark'),(21,'Floral Buds'),(22,'Flower'),(23,'Flower and fruit'),(24,'Flower buds'),(25,'Flowering'),(26,'Flowering aerial parts'),(27,'Flowering branches'),(28,'Flowering tops'),(29,'Flowers'),(30,'Foliage'),(31,'Fresh Aerial parts'),(32,'Fresh flowers'),(33,'Fresh husk'),(34,'Fresh leaves'),(35,'Fresh needles'),(36,'Fresh rhizomes'),(37,'Fresh ripe fruits'),(38,'Fresh whole plant'),(39,'Fresh yellow flowers'),(40,'Fruit'),(41,'Full Opened Flowers'),(42,'Gra?'),(43,'Green Capsules'),(44,'Green leaves'),(45,'Heartwood'),(46,'Inflor.'),(47,'Inflorescence'),(48,'Leaf'),(49,'Leaf  flower  branches'),(50,'Leaf and Branch'),(51,'Leaf and flowers'),(52,'Leaf and inflorescence'),(53,'Leaf and twigs'),(54,'Leaf, flower, branches'),(55,'Leafy stem'),(56,'Leaves'),(57,'Leaves and Flowers'),(58,'Leaves and stems'),(59,'Male Bark'),(60,'Mature and fresh flowers'),(61,'Mature fresh leaves'),(62,'Mature fruits'),(63,'Mature stem barks'),(64,'Needles'),(65,'Pads (cladodes)'),(66,'Peels'),(67,'Phyllode'),(68,'Pod'),(69,'Post-flowering'),(70,'Rhizome'),(71,'Root'),(72,'Root Hairs'),(73,'Roots'),(74,'Samara (ripe fruit)'),(75,'Seed'),(76,'Seed (Grain)'),(77,'Seedling'),(78,'Shoot with floral buds and some young flowers'),(79,'Shoot with flowers'),(80,'Shoot with leaf  without flower'),(81,'Shoot with leaf, without flower'),(82,'Shoots with fruits'),(83,'Steam bark'),(84,'Stem'),(85,'Stem and leaf'),(86,'Stem bark'),(87,'Trunk'),(88,'Trunk bark'),(89,'Twig'),(90,'Underground stem'),(91,'Vegetative'),(92,'Whole Plant'),(93,'Whole Plant Parts'),(94,'Whole clove bud'),(95,'Whole plant'),(96,'Whole plant parts'),(97,'Wood'),(98,'Young stemsÃ¯Â¿Â½'),(99,'aerial'),(100,'aerial parts'),(101,'aerial shoots'),(102,'apex'),(103,'balsam'),(104,'bark'),(105,'bark wood'),(106,'branch'),(107,'branch with needle'),(108,'bud'),(109,'bulb'),(110,'buttwood'),(111,'calyx'),(112,'capitula'),(113,'commercial plant seed'),(114,'cone'),(115,'corolla'),(116,'female branch'),(117,'female branchlet'),(118,'female cone'),(119,'female cone branchlets'),(120,'female flower'),(121,'female foliage'),(122,'female leaf'),(123,'flower'),(124,'flower and fruit'),(125,'flower stalk'),(126,'flowering branch'),(127,'flowering shoot'),(128,'flowering top'),(129,'foliage and branch'),(130,'foliage of female plant'),(131,'foliage of male plant'),(132,'fresh leaf'),(133,'fruit'),(134,'fruit (3/4th yellow)'),(135,'fruit (color turn)'),(136,'fruit (dark green)'),(137,'fruit (full yellow)'),(138,'fruit (half yellow)'),(139,'fruit (juice extract)'),(140,'fruit (light green)'),(141,'fruit (soaked chopped)'),(142,'fruit (soaked grounded)'),(143,'fruit (unripe Intact)'),(144,'fruit (unripe cut)'),(145,'fruit peel'),(146,'fruits'),(147,'gall'),(148,'gum'),(149,'hairy root'),(150,'herb'),(151,'herb and fruit'),(152,'herbage'),(153,'herbal parts'),(154,'husk'),(155,'immature seed'),(156,'inflorescence'),(157,'inflorescence spikele'),(158,'inflorescence stem'),(159,'leaf'),(160,'leaf  stem  flower  fruit'),(161,'leaf and bark'),(162,'leaf and branch'),(163,'leaf and bud'),(164,'leaf and clove'),(165,'leaf and fertile branch'),(166,'leaf and flower'),(167,'leaf and fruit'),(168,'leaf and inflorescence'),(169,'leaf and shoot'),(170,'leaf and stalk'),(171,'leaf and terminal branch'),(172,'leaf and thin branch'),(173,'leaf and twig'),(174,'leaf flower branches'),(175,'leaf lamina'),(176,'leaf sheath'),(177,'leaf sheath and stem'),(178,'leaf, stem, flower, fruit'),(179,'leaflet'),(180,'leafy stem'),(181,'leaves and flowering top'),(182,'male branch'),(183,'male branchlet'),(184,'male flower'),(185,'male foliage'),(186,'male leaf'),(187,'market seed'),(188,'mature leaves'),(189,'mature seed'),(190,'needle'),(191,'ole-gum resin'),(192,'oleo-gum resin'),(193,'oleo-gum resin and latex'),(194,'oleo-resin'),(195,'parent root'),(196,'petal'),(197,'plant tissue'),(198,'pomace'),(199,'powdered rhizome'),(200,'resin'),(201,'rhizome'),(202,'ripe seed'),(203,'root'),(204,'root bark'),(205,'root wood'),(206,'rootstock'),(207,'seed'),(208,'seed and inflorescence'),(209,'shoot'),(210,'sliced rhizome'),(211,'specimen'),(212,'spike'),(213,'stalk'),(214,'stalk and leaves'),(215,'stem'),(216,'stem and flower'),(217,'stem and leaf'),(218,'stem bark'),(219,'stem wood'),(220,'stem wood chips'),(221,'stolon'),(222,'terminal branch'),(223,'terminal branch (non-woody)'),(224,'terminal branch (woody)'),(225,'trichome'),(226,'trunk'),(227,'trunk wood'),(228,'tuber'),(229,'twig'),(230,'twigs'),(231,'underground parts'),(232,'unripe seed'),(233,'vegetative parts'),(234,'whole plant'),(235,'wild plant seed'),(236,'wood'),(237,'wood chip');
/*!40000 ALTER TABLE `plantpart` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-07-28  7:55:59
