fda erd_(gs1+espr)
Tables (6)
Cooling_CTE
- siteOfNextRecipient_businessName — VARCHAR(255)
- siteOfNextRecipient_phoneNumber — VARCHAR(20)
- siteOfNextRecipient_region — VARCHAR(50)
- siteOfNextRecipient_postalCode — VARCHAR(20)
- siteOfNextRecipient_country — VARCHAR(50)
- siteOfNextRecipient_address — VARCHAR(255)
- siteOfNextRecipient_city — VARCHAR(50)
- siteOfNextRecipient_GLN — VARCHAR(20)
- siteOfCooledFood_businessName — VARCHAR(255)
- siteOfCooledFood_phoneNumber — VARCHAR(20)
- siteOfCooledFood_address — VARCHAR(255)
- siteOfCooledFood_city — VARCHAR(50)
- siteOfCooledFood_region — VARCHAR(50)
- siteOfCooledFood_postalCode — VARCHAR(20)
- siteOfCooledFood_country — VARCHAR(50)
- siteOfCooledFood_GLN — VARCHAR(20)
- siteOfFarm_businessName — VARCHAR(255)
- siteOfFarm_phoneNumber — VARCHAR(20)
- siteOfFarm_address — VARCHAR(255)
- siteOfFarm_city — VARCHAR(50)
- siteOfFarm_region — VARCHAR(50)
- siteOfFarm_postalCode — VARCHAR(20)
- siteOfFarm_country — VARCHAR(50)
- siteOfFarm_GLN — VARCHAR(20)
- commodityCode — VARCHAR(50) — NOT NULL
- commodityName — VARCHAR(100) — NOT NULL
- variety — VARCHAR(100)
- quantity — DECIMAL(10,2) — NOT NULL
- unitOfMeasure — VARCHAR(20) — NOT NULL
- coolingDate — DATE — NOT NULL
- refDocumentType — VARCHAR(50)
- refDocumentNumber — VARCHAR(50)
- GTIN — VARCHAR(20)
- batchNumber — VARCHAR(50)
- SGTIN — VARCHAR(50)
- productionSiteGLN — VARCHAR(20)
- certifications — VARCHAR(255)
- digitalLinkURI — VARCHAR(255)
- nullable — BOOLEAN
Harvesting_CTE
- siteOfNextRecipient_businessName — VARCHAR(255)
- siteOfNextRecipient_phoneNumber — VARCHAR(20)
- siteOfNextRecipient_region — VARCHAR(50)
- siteOfNextRecipient_postalCode — VARCHAR(20)
- siteOfNextRecipient_country — VARCHAR(50)
- siteOfNextRecipient_address — VARCHAR(255)
- siteOfNextRecipient_city — VARCHAR(50)
- siteOfNextRecipient_GLN — VARCHAR(20)
- siteOfHarvestedFarm_businessName — VARCHAR(255)
- siteOfHarvestedFarm_phoneNumber — VARCHAR(20)
- siteOfHarvestedFarm_address — VARCHAR(255)
- siteOfHarvestedFarm_city — VARCHAR(50)
- siteOfHarvestedFarm_region — VARCHAR(50)
- siteOfHarvestedFarm_postalCode — VARCHAR(20)
- siteOfHarvestedFarm_country — VARCHAR(50)
- siteOfHarvestedFarm_GLN — VARCHAR(20)
- commodityCode — VARCHAR(50) — NOT NULL
- commodityName — VARCHAR(100) — NOT NULL
- variety — VARCHAR(100)
- quantity — DECIMAL(10,2) — NOT NULL
- unitOfMeasure — VARCHAR(20) — NOT NULL
- farmingArea — VARCHAR(100)
- harvestDate — DATE — NOT NULL
- refDocumentType — VARCHAR(50)
- refDocumentNumber — VARCHAR(50)
- GTIN — VARCHAR(20)
- batchNumber — VARCHAR(50)
- SGTIN — VARCHAR(50)
- productionSiteGLN — VARCHAR(20)
- certifications — VARCHAR(255)
- digitalLinkURI — VARCHAR(255)
- nullable — BOOLEAN
InitialPacking_CTE
- harvesting_commodityCode — VARCHAR(50) — NOT NULL
- harvesting_commodityName — VARCHAR(100) — NOT NULL
- harvesting_variety — VARCHAR(100)
- harvesting_quantity — DECIMAL(10,2) — NOT NULL
- harvesting_unitOfMeasure — VARCHAR(20) — NOT NULL
- harvesting_receiveDate — DATE
- harvesting_siteOfHarvestedFarm_siteCode — VARCHAR(50)
- harvesting_siteOfHarvestedFarm_businessName — VARCHAR(255)
- harvesting_siteOfHarvestedFarm_phoneNumber — VARCHAR(20)
- harvesting_siteOfHarvestedFarm_address — VARCHAR(255)
- harvesting_siteOfHarvestedFarm_city — VARCHAR(50)
- harvesting_siteOfHarvestedFarm_region — VARCHAR(50)
- harvesting_siteOfHarvestedFarm_postalCode — VARCHAR(20)
- harvesting_siteOfHarvestedFarm_country — VARCHAR(50)
- harvesting_farmingArea — VARCHAR(100)
- harvesting_siteOfHarvest_siteCode — VARCHAR(50)
- harvesting_siteOfHarvest_businessName — VARCHAR(255)
- harvesting_siteOfHarvest_phoneNumber — VARCHAR(20)
- harvesting_harvestDate — DATE
- harvesting_refDocumentType — VARCHAR(50)
- harvesting_refDocumentNumber — VARCHAR(50)
- harvesting_refDocumentType2 — VARCHAR(50)
- harvesting_refDocumentNumber2 — VARCHAR(50)
- cooling_commodityCode — VARCHAR(50) — NOT NULL
- cooling_commodityName — VARCHAR(100) — NOT NULL
- cooling_variety — VARCHAR(100)
- cooling_quantity — DECIMAL(10,2) — NOT NULL
- cooling_unitOfMeasure — VARCHAR(20) — NOT NULL
- cooling_receiveDate — DATE
- cooling_siteOfCooledFood_siteCode — VARCHAR(50)
- cooling_siteOfCooledFood_businessName — VARCHAR(255)
- cooling_siteOfCooledFood_phoneNumber — VARCHAR(20)
- cooling_siteOfCooledFood_address — VARCHAR(255)
- cooling_siteOfCooledFood_city — VARCHAR(50)
- cooling_siteOfCooledFood_region — VARCHAR(50)
- cooling_siteOfCooledFood_postalCode — VARCHAR(20)
- cooling_siteOfCooledFood_country — VARCHAR(50)
- cooling_coolingDate — DATE
- cooling_siteOfFarm_siteCode — VARCHAR(50)
- cooling_siteOfFarm_businessName — VARCHAR(255)
- cooling_siteOfFarm_phoneNumber — VARCHAR(20)
- cooling_siteOfFarm_address — VARCHAR(255)
- cooling_siteOfFarm_city — VARCHAR(50)
- cooling_siteOfFarm_region — VARCHAR(50)
- cooling_siteOfFarm_postalCode — VARCHAR(20)
- cooling_siteOfFarm_country — VARCHAR(50)
- cooling_refDocumentType — VARCHAR(50)
- cooling_refDocumentNumber — VARCHAR(50)
- cooling_refDocumentType2 — VARCHAR(50)
- cooling_refDocumentNumber2 — VARCHAR(50)
- tlc — VARCHAR(50) — NOT NULL
- tlcSourceReference — VARCHAR(50)
- product_productCode — VARCHAR(50) — NOT NULL
- product_productName — VARCHAR(100) — NOT NULL
- product_brandName — VARCHAR(100)
- product_commodity — VARCHAR(100)
- product_variety — VARCHAR(100)
- product_packagingSize — VARCHAR(50)
- product_packagingStyle — VARCHAR(50)
- product_quantity — DECIMAL(10,2)
- … +22
Receiving_CTE
- tlc — VARCHAR(50) — NOT NULL
- tlcSourceReference — VARCHAR(50)
- quantity — DECIMAL(10,2) — NOT NULL
- unitOfMeasure — VARCHAR(20) — NOT NULL
- product_productName — VARCHAR(100) — NOT NULL
- product_brandName — VARCHAR(100)
- product_commodity — VARCHAR(100)
- product_variety — VARCHAR(100)
- product_packagingSize — VARCHAR(50)
- product_packagingStyle — VARCHAR(50)
- siteOfPreviousSource_siteCode — VARCHAR(50)
- siteOfPreviousSource_businessName — VARCHAR(255)
- siteOfPreviousSource_phoneNumber — VARCHAR(20)
- siteOfPreviousSource_address — VARCHAR(255)
- siteOfPreviousSource_city — VARCHAR(50)
- siteOfPreviousSource_region — VARCHAR(50)
- siteOfPreviousSource_postalCode — VARCHAR(20)
- siteOfPreviousSource_country — VARCHAR(50)
- siteOfPreviousSource_GLN — VARCHAR(20)
- siteOfFoodReceived_siteCode — VARCHAR(50)
- siteOfFoodReceived_businessName — VARCHAR(255)
- siteOfFoodReceived_phoneNumber — VARCHAR(20)
- siteOfFoodReceived_address — VARCHAR(255)
- siteOfFoodReceived_city — VARCHAR(50)
- siteOfFoodReceived_region — VARCHAR(50)
- siteOfFoodReceived_postalCode — VARCHAR(20)
- siteOfFoodReceived_country — VARCHAR(50)
- siteOfFoodReceived_GLN — VARCHAR(20)
- receiveDate — DATE — NOT NULL
- refDocumentType — VARCHAR(50)
- refDocumentNumber — VARCHAR(50)
- refDocumentType2 — VARCHAR(50)
- refDocumentNumber2 — VARCHAR(50)
- GTIN — VARCHAR(20)
- SGTIN — VARCHAR(50)
- batchNumber — VARCHAR(50)
- productionSiteGLN — VARCHAR(20)
- certifications — VARCHAR(255)
- digitalLinkURI — VARCHAR(255)
- SSCC — VARCHAR(50)
- nullable — BOOLEAN
Shipping_CTE
- tlc — VARCHAR(50) — NOT NULL
- tlcSourceReference — VARCHAR(50)
- quantity — DECIMAL(10,2) — NOT NULL
- unitOfMeasure — VARCHAR(20) — NOT NULL
- product_productName — VARCHAR(100) — NOT NULL
- product_brandName — VARCHAR(100)
- product_commodity — VARCHAR(100)
- product_variety — VARCHAR(100)
- product_packagingSize — VARCHAR(50)
- product_packagingStyle — VARCHAR(50)
- siteOfNextRecipient_businessName — VARCHAR(255)
- siteOfNextRecipient_phoneNumber — VARCHAR(20)
- siteOfNextRecipient_address — VARCHAR(255)
- siteOfNextRecipient_city — VARCHAR(50)
- siteOfNextRecipient_region — VARCHAR(50)
- siteOfNextRecipient_postalCode — VARCHAR(20)
- siteOfNextRecipient_country — VARCHAR(50)
- siteOfNextRecipient_GLN — VARCHAR(20)
- siteOfFoodShipped_businessName — VARCHAR(255)
- siteOfFoodShipped_phoneNumber — VARCHAR(20)
- siteOfFoodShipped_address — VARCHAR(255)
- siteOfFoodShipped_city — VARCHAR(50)
- siteOfFoodShipped_region — VARCHAR(50)
- siteOfFoodShipped_postalCode — VARCHAR(20)
- siteOfFoodShipped_country — VARCHAR(50)
- siteOfFoodShipped_GLN — VARCHAR(20)
- siteOfTLCSource_businessName — VARCHAR(255)
- siteOfTLCSource_phoneNumber — VARCHAR(20)
- siteOfTLCSource_address — VARCHAR(255)
- siteOfTLCSource_city — VARCHAR(50)
- siteOfTLCSource_region — VARCHAR(50)
- siteOfTLCSource_postalCode — VARCHAR(20)
- siteOfTLCSource_country — VARCHAR(50)
- siteOfTLCSource_GLN — VARCHAR(20)
- shippingDate — DATE — NOT NULL
- refDocumentType — VARCHAR(50)
- refDocumentNumber — VARCHAR(50)
- refDocumentType2 — VARCHAR(50)
- refDocumentNumber2 — VARCHAR(50)
- GTIN — VARCHAR(20)
- SGTIN — VARCHAR(50)
- batchNumber — VARCHAR(50)
- productionSiteGLN — VARCHAR(20)
- certifications — VARCHAR(255)
- digitalLinkURI — VARCHAR(255)
- SSCC — VARCHAR(50)
- nullable — BOOLEAN
Transformation_CTE
- tlc — VARCHAR(50) — NOT NULL
- product_productName — VARCHAR(255) — NOT NULL
- product_brandName — VARCHAR(100)
- product_commodity — VARCHAR(100)
- product_variety — VARCHAR(100)
- product_packagingSize — VARCHAR(50)
- product_packagingStyle — VARCHAR(50)
- product_quantity — DECIMAL(10,2)
- product_unitOfMeasure — VARCHAR(20)
- siteOfFoodTransformed_siteCode — VARCHAR(50)
- siteOfFoodTransformed_businessName — VARCHAR(255)
- siteOfFoodTransformed_phoneNumber — VARCHAR(20)
- siteOfFoodTransformed_address — VARCHAR(255)
- siteOfFoodTransformed_city — VARCHAR(50)
- siteOfFoodTransformed_region — VARCHAR(50)
- siteOfFoodTransformed_postalCode — VARCHAR(20)
- siteOfFoodTransformed_country — VARCHAR(50)
- siteOfFoodTransformed_GLN — VARCHAR(20)
- transformationCompletionDate — DATE — NOT NULL
- refDocumentType — VARCHAR(50)
- refDocumentNumber — VARCHAR(50)
- refDocumentType2 — VARCHAR(50)
- refDocumentNumber2 — VARCHAR(50)
- GTIN — VARCHAR(20)
- SGTIN — VARCHAR(50)
- batchNumber — VARCHAR(50)
- productionSiteGLN — VARCHAR(20)
- certifications — VARCHAR(255)
- digitalLinkURI — VARCHAR(255)
- SSCC — VARCHAR(50)
- nullable — BOOLEAN