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`