routingoperations_snapshot_20260213133332

efacdb_full · Backups, snapshots and deleted-row stores

Type

BASE TABLE

Rows est.

96,842

Size

23.56 MB

Updated

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	partid	text	-	YES	-	-
2	methodid	text	-	YES	-	-
3	operationnumber	text	-	YES	-	-
4	workcentreid	text	-	YES	-	-
5	operatorskill	text	-	YES	-	-
6	settime	text	-	YES	-	-
7	runtime	text	-	YES	-	-
8	transfertime	text	-	YES	-	-
9	perquantity	text	-	YES	-	-
10	description	text	-	YES	-	-
11	drawingreference	text	-	YES	-	-
12	overlappercentage	text	-	YES	-	-
13	alternativeoperation	text	-	YES	-	-
14	alternativeoperationpreference	text	-	YES	-	-
15	losspercentage	text	-	YES	-	-
16	numberofoperators	text	-	YES	-	-
17	fixedsubcontractcost	text	-	YES	-	-
18	unitsubcontractcost	text	-	YES	-	-
19	numberofsetters	text	-	YES	-	-
20	setterskill	text	-	YES	-	-
21	fiscalstandardsettime	text	-	YES	-	-
22	fiscalstandardruntime	text	-	YES	-	-
23	fiscalstandardperquantity	text	-	YES	-	-
24	fiscalstandardnumberofsetters	text	-	YES	-	-
25	fiscalstdnumberofoperators	text	-	YES	-	-
26	fiscalstdfixedsubcontractcost	text	-	YES	-	-
27	fiscalstdunitsubcontractcost	text	-	YES	-	-
28	goingtosettime	text	-	YES	-	-
29	goingtoruntime	text	-	YES	-	-
30	goingtoperquantity	text	-	YES	-	-
31	goingtonumberofsetters	text	-	YES	-	-
32	goingtonumberofoperators	text	-	YES	-	-
33	goingtofixedsubcontractcost	text	-	YES	-	-
34	goingtounitsubcontractcost	text	-	YES	-	-
35	standardoperation	text	-	YES	-	-
36	createdby	text	-	YES	-	-
37	createddate	text	-	YES	-	-
38	modifiedby	text	-	YES	-	-
39	modifieddate	text	-	YES	-	-
40	auditoperation	text	-	YES	-	-
41	modifiedtimestamp	text	-	YES	-	-
42	companyid	text	-	YES	-	-
43	olversionnumber	text	-	YES	-	-

Name	Unique	Columns
No indexes found.

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.