routingoperations_prededup_20260507_123357

efacdb_full ยท Backups, snapshots and deleted-row stores
Back to EFACS Browser
Type
BASE TABLE
Rows est.
97,920
Size
34.08 MB
Updated
-

Columns

Full schema, no data mutation.
#NameTypeKeyNullableDefaultComment
1partidvarchar(30)MULNO--
2methodidvarchar(8)-NO--
3operationnumbersmallint-NO--
4workcentreidvarchar(8)-YES--
5operatorskillsmallint-NO--
6settimedouble-NO--
7runtimedouble-NO--
8transfertimedouble-NO--
9perquantitysmallint-NO--
10descriptionvarchar(255)-YES--
11drawingreferencevarchar(14)-YES--
12overlappercentagesmallint-NO--
13alternativeoperationvarchar(1)-YES--
14alternativeoperationpreferencesmallint-NO--
15losspercentagedouble-NO--
16numberofoperatorsdouble-NO--
17fixedsubcontractcostdouble-NO--
18unitsubcontractcostdouble-NO--
19numberofsettersdouble-NO--
20setterskillsmallint-NO--
21fiscalstandardsettimedouble-NO--
22fiscalstandardruntimedouble-NO--
23fiscalstandardperquantitysmallint-YES--
24fiscalstandardnumberofsettersdouble-NO--
25fiscalstdnumberofoperatorsdouble-NO--
26fiscalstdfixedsubcontractcostdouble-NO--
27fiscalstdunitsubcontractcostdouble-NO--
28goingtosettimedouble-NO--
29goingtoruntimedouble-NO--
30goingtoperquantitysmallint-NO--
31goingtonumberofsettersdouble-NO--
32goingtonumberofoperatorsdouble-NO--
33goingtofixedsubcontractcostdouble-NO--
34goingtounitsubcontractcostdouble-NO--
35standardoperationvarchar(30)-YES--
36createdbyvarchar(36)-YES--
37createddatedatetime(6)-YES--
38modifiedbyvarchar(36)-YES--
39modifieddatedatetime(6)-YES--
40auditoperationvarchar(8)-YES--
41modifiedtimestampbinary(8)-NO--
42companyidvarchar(30)-YES--
43olversionnumberint-NO--

Indexes

NameUniqueColumns
idx_routeops_mergeNopartid, methodid, operationnumber

Foreign Keys

EFACS has few enforced keys; many relationships are conventional.
ColumnReferences
No enforced foreign keys found for this table.