Skip to main content

ENUM Data Types

The database utilizes the following ENUM data types throughout the tables:

string_boolean​

  • True
  • False

lab_test_statuses​

  • Fail
  • Pass
  • Required
  • Not Required
  • In Process

operations​

  • Insert
  • Update
  • Delete

strain_types​

  • Indica
  • Sativa
  • Hybrid

inventory_categories​

  • PropagationMaterial
  • HarvestedMaterial
  • IntermediateProduct
  • EndProduct

inventory_types​

  • Clones
  • Plant
  • Seed
  • Flower Lot
  • Flower Unlotted
  • Other Material Lot
  • Other Material Unlotted
  • Wet Flower
  • Cannabis Mix
  • CBD
  • Food Grade Solvent Concentrate
  • Infused Cooking Medium
  • Cannabis Mix Infused
  • Cannabis Mix Packaged
  • Capsule
  • CO2 Concentrate
  • Concentrate for Inhalation
  • Ethanol Concentrate
  • Hydrocarbon Concentrate
  • Liquid Edible
  • Non-Solvent Based Concentrate
  • Sample Jar
  • Solid Edible
  • Suppository
  • Tincture
  • Topical Ointment
  • Transdermal
  • Usable Cannabis
  • Waste

adjustment_reasons​

  • Destruction
  • Reconciliation
  • Lost
  • Seizure
  • Theft
  • Other