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