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