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