LIMS

Tables (3)

RECIPE_SUPPLIES_USAGE (Untitled3)

  • PK (RSU_ID) — Primary key — NOT NULL
  • FK (RECIPE_ID) — INT — Foreign key → Recipe.PK — NOT NULL
  • PK (REAGENT_ID) — INT — Foreign key → Reagent.PK — NOT NULL
  • Field (USAGE) — DECIMAL

Reagent (Untitled2)

  • PK (REAGENT_ID) — INT — Primary key — NOT NULL
  • Field (REAGENT_NAME) — NVARCHAR
  • Field (UNITS) — NVARCHAR
  • Field (USAGE) — DECIMAL
  • Field (STATUS) — BOOL

Recipe (Untitled)

  • PK (RECIPE_ID) — INT — Primary key — NOT NULL
  • Field (RECIPE_NAME) — NVARCHAR
  • Field (STATUS) — NVARCHAR
  • Field (DESCRIPTION) — NVARCHAR