test

Tables (13)

batch

  • batch_id — serial — NOT NULL
  • start_time — timestamp — NOT NULL
  • end_time — timestamp
  • recipe_ratio — varchar(10)
  • recipe_id — int
  • fermenter_id — int

fermenter

  • fermenter_id — serial — NOT NULL
  • fermenter_volume — int — NOT NULL
  • status — fermentation_status — NOT NULL
  • fermenter_line — varchar(100)

lot

  • lot_id — serial — NOT NULL
  • product_name — varchar(100) — NOT NULL
  • batch_id — int
  • lot_volume — int — NOT NULL

lot_history

  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • lot_id — int
  • notes — text
  • lot_location — VARCHAR(50)

product

  • product_id — serial — NOT NULL
  • product_name — varchar(100) — NOT NULL
  • price — int
  • category — varchar(50)
  • lot_id — int
  • created_at — TIMESTAMP
  • expiration_date — timestamp
  • bottling_date — timestamp
  • notification_number — varchar(30)
  • barcode — varchar(30)

raw_material

  • raw_material_id — serial — NOT NULL
  • raw_material_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • description — TEXT
  • unit — VARCHAR(10) — NOT NULL
  • supplier_name — varchar(100)
  • phone_number — varchar(15)
  • zip_code — varchar(6)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

raw_material_receipt

  • receipt_id — serial — NOT NULL
  • quantity — numeric(10, 2) — NOT NULL
  • unit_price — int — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • raw_material_id — int

raw_material_usage

  • usage_id — serial — NOT NULL
  • quantity_used — numeric(10, 2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • raw_material_id — int
  • batch_id — int

recipe

  • recipe_id — serial — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • recipe_detail — json
  • recipe_name — VARCHAR(100) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL

sale

  • sale_id — serial — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • quantity_sold — int — NOT NULL
  • sale_channel — VARCHAR(50)
  • commission_rate — NUMERIC(5,2)

sales_detail

  • sale_detail_id — serial — NOT NULL
  • payment_method — varchar(50) — NOT NULL
  • discount_yn — boolean — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • product_id — int
  • sale_id — int

sensor_measurement

  • data_id — bigserial — NOT NULL
  • co2_concentration — integer
  • brix — numeric(5, 3)
  • measured_time — timestamp
  • out_temperature — numeric(5, 3)
  • in_temperature — numeric(5, 3)
  • ph — numeric(4,2)
  • pressure_upper — numeric(10, 4)
  • pressure_lower — numeric(10, 4)
  • batch_id — int

tasting_note

  • tasting_note_id — serial — NOT NULL
  • fermentation_aroma — numeric — NOT NULL
  • foam — numeric(4,2) — NOT NULL
  • mouthfeel — numeric — NOT NULL
  • balance — numeric — NOT NULL
  • clarity — numeric — NOT NULL
  • sweetness — numeric — NOT NULL
  • acidity — numeric — NOT NULL
  • body — numeric — NOT NULL
  • grainy_aroma — numeric — NOT NULL
  • finish — numeric
  • evaluator_name — varchar(10) — NOT NULL
  • batch_id — int
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP