LMES Trace Database Design Document

📚 Database Table Directory

No.	Table Name	Table Description
1	__efmigrationshistoryforordermanagement
2	__efmigrationshistoryforproductionmanagement
3	__efmigrationshistoryforqualitymanagement
4	__efmigrationshistoryfortracemanagement
5	scms_flowinstancelogs_20251014	Flow Run Record
6	scms_flowinstancelogs_20251015	Flow Run Record
7	scms_materialrecords_202510	Material Handling Record
8	scms_materialrecords_202511	Material Handling Record
9	scms_order_segments	Associated Process Segment
10	scms_orders	Work Order
11	scms_production_records	Production Record Detail Table
12	scms_productionlineinfos	Production Line Info Table
13	scms_productionlineprocessinfos	Production Line Process Info Table
14	scms_productions	Production Record Table
15	scms_qualityjudgment_details	Product Judgment - Repair Detail Table
16	scms_qualityjudgment_sections	Product Judgment - Repair Process Table
17	scms_qualityjudgments	Product Judgment Record Table
18	scms_qualityunqualifiedreasons	Unqualified Reason Table
19	scms_qualityunqualifiedrecords	Unqualified Record Table
20	scms_repairroute_items	Repair Route Detail
21	scms_repairroute_worksections	Repair NG Process
22	scms_repairroutes	Repair Route
23	scms_traceprocesssettings	Process Setting Table
24	scms_traceproductmodelconfigs	Product Model Display Config Table
25	scms_tracesummarytable_products	Summary Table Config - Product Table
26	scms_tracesummarytable_worksections	Summary Table Config - Process Table
27	scms_tracesummarytables	Summary Table Config Table
28	trace_2025_0353e96d6baaeca59d4b3a103794992e
29	trace_2025_0409a17ea618854567143a103794992e
30	trace_unqualifieds
31	tracematerial_2025_0353e96d6baaeca59d4b3a103794992e
32	tracematerial_2025_0409a17ea618854567143a103794992e
33	traceparam_2025_0353e96d6baaeca59d4b3a103794992e
34	traceparam_2025_0409a17ea618854567143a103794992e

📒 Table Structure

Table Name: scms_flowinstancelogs_20251014

Description: Flow Run Record

No.	Column Name	Data Type	Length	PK	Auto	Nullable	Default	Description
1	Id	bigint		√	√
2	FlowType	int				√		Flow Type
3	FlowVersion	int				√		Flow Version
4	FlowName	varchar	(64)			√		Flow Name
5	FlowTag	int						Instance Status
6	StartTime	datetime						Start Time
7	FinishTime	datetime				√		Finish Time
8	WorkSectionId	char	(36)			√		Work Section Id
9	WorkSectionName	varchar	(64)			√		Work Section Name
10	WorkStationId	char	(36)			√		Work Station Id
11	WorkStationName	varchar	(64)			√		Work Station Name
12	ExtraProperties	longtext				√

(... Similar structure for other tables, translating "Description" field ...)

Table Name: scms_orders

Description: Work Order

No.	Column Name	Data Type	Length	PK	Auto	Nullable	Default	Description
1	Id	char	(36)	√
2	Code	varchar	(64)					Code
3	Sort	int						Sort
4	Source	varchar	(64)			√		Source
5	Product_Id	char	(36)			√		Product Id
6	Product_Name	varchar	(64)			√		Product Name
7	Product_Model	varchar	(64)			√		Product Model
8	Product_ShortNumber	varchar	(64)			√		Product Short Code
9	Formula_Id	char	(36)			√		Formula Id
10	Formula_Name	varchar	(64)			√		Formula Version
11	Formula_Code	varchar	(64)			√		Formula Code
12	Shift	varchar	(64)			√		Shift
13	PlanQty	bigint unsigned				√		Plan Qty
14	ProduceQty	bigint unsigned				√		Produced Qty
15	QualifiedQty	bigint unsigned				√		Qualified Qty
16	UnQualifiedQty	bigint unsigned				√		Unqualified Qty
17	PlanStartTime	datetime				√		Plan Start Time
18	PlanFinishTime	datetime				√		Plan Finish Time
19	Status_Name	varchar	(64)			√		Status Name
20	Status_Value	int						Status Value
21	Status_Description	varchar	(256)			√		Status Description
22	StartTime	datetime				√		Actual Start Time
23	FinishTime	datetime				√		Actual Finish Time
24	FinishReason	varchar	(64)			√		Finish Reason