a

Tables (9)

facility

  • faciliy_id — BIGINT — Primary key — NOT NULL
  • end_time — DATE
  • start_time — DATE — NOT NULL
  • work_plan_id — BIGINT — Foreign key → work_plan.work_plan_id
  • duration — VARCHAR(255) — NOT NULL
  • input_materials — VARCHAR(255)
  • semi_product — VARCHAR(255)
  • facilitys — ENUM('StickMachine1', 'StickMachine2', 'boxMachine', 'extractor1', 'extractor2', 'filter', 'juiceMachine1', 'juiceMachine2', 'metalDetector', 'mixer', 'sterilizer1', 'sterilizer2', 'washer') — NOT NULL

lot_code

  • lot_code — VARCHAR(255) — Primary key — NOT NULL
  • next_lot — VARCHAR(255)
  • perv_lot — VARCHAR(255)

mes_order

  • order_id — BIGINT — Primary key — NOT NULL
  • individual — BIT(1) — NOT NULL
  • quantity — INT — NOT NULL
  • urgency — BIT(1) — NOT NULL
  • orderer_id — BIGINT — Foreign key → orderer.orderer_id
  • process_plan_id — BIGINT — Foreign key → process_plan.process_plan_id
  • expected_delivery_date — VARCHAR(255) — NOT NULL
  • product — ENUM('BLACK_GARLIC_JUICE', 'CABBAGE_JUICE', 'PLUM_JELLY_STICK', 'POMEGRANATE_JELLY_STICK') — NOT NULL
  • INDEX — `FK5wl055hitf1dpyfeub88fhkhr`
  • INDEX — `FK5ddyj9ys21pdq5v48oj7hrmjo`

orderer

  • orderer_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(255) — NOT NULL

process_plan

  • process_plan_id — BIGINT — Primary key — NOT NULL

raws

  • raws_id — VARCHAR(255) — Primary key — NOT NULL
  • dead_line — DATE
  • expected_import_date — DATE
  • export_date — DATE
  • import_date — DATE
  • order_date — DATE — NOT NULL
  • quantity — INT — NOT NULL
  • partner — VARCHAR(255) — NOT NULL
  • product — ENUM('BLACK_GARLIC', 'BOX', 'CABBAGE', 'COLLAGEN', 'HONEY', 'PLUM', 'POMEGRANATE', 'WRAPPING_PAPER') — NOT NULL
  • raws_reason — ENUM('DISPOSE', 'PROCESS_INPUT')

shipment

  • shipment_id — BIGINT — Primary key — NOT NULL
  • is_disable — BIT(1) — NOT NULL
  • is_shipping — BIT(1) — NOT NULL
  • shipping_date — DATE
  • order_id — BIGINT — Foreign key → mes_order.order_id

stock

  • stock_id — BIGINT — Primary key — NOT NULL
  • create_date — DATE — NOT NULL
  • export_date — DATE
  • is_export — BIT(1) — NOT NULL
  • quantity — INT — NOT NULL
  • work_plan_id — BIGINT — Foreign key → work_plan.work_plan_id

work_plan

  • work_plan_id — BIGINT — Primary key — NOT NULL
  • end_time — DATE
  • process_completion_time — DATE
  • start_time — DATE — NOT NULL
  • process_plan_id — BIGINT — Foreign key → process_plan.process_plan_id
  • lot_code — VARCHAR(255) — Foreign key → lot_code.lot_code
  • raws_codes — VARCHAR(255)
  • worker — VARCHAR(255) — NOT NULL
  • process — ENUM('A1', 'A2', 'A3', 'A4', 'A5', 'A6', 'A7', 'A8', 'B1', 'B2', 'B3', 'B4', 'B5', 'B6', 'B7')
  • INDEX — `FKt59412m7c51hj9488lnlwycf7`