APS (simple version)
Tables (9)
Operation
- id — VARCHAR(100) — Primary key — NOT NULL
- name — VARCHAR(100)
- run_time — INT
- yeild — INT
- seq — INT
- sourcing_type — TINYINT
Part
- id — VARCHAR(50) — Primary key — NOT NULL
- name (code) — VARCHAR(100)
- type — VARCHAR(50)
- senario_id (scenario_id) — VARCHAR(50)
- routing_id — VARCHAR(100) — Foreign key → Routing.id — NOT NULL
ProductionOrder
- id — BIGINT
- product_id — VARCHAR(50)
- quantity — INT
- due_date — DATE
- routing_id — VARCHAR(50)
Routing
- id — VARCHAR(100) — Primary key — NOT NULL
- name — VARCHAR(100)
RoutingStep
- id — BIGINT
- routing_id — VARCHAR(50)
- operation_id — VARCHAR(50)
- step_no — INT
- process_time — FLOAT
Tool
- id — VARCHAR(50)
- name — VARCHAR(100)
- available — BOOLEAN
ToolMap
- id — BIGINT
- operation_id — VARCHAR(50)
- tool_id — VARCHAR(50)
WorkCenter
- id — VARCHAR(50)
- name — VARCHAR(100)
- capacity — INT
WorkcenterMap
- id — BIGINT
- operation_id — VARCHAR(50)
- workcenter_id — VARCHAR(50)