Table EcASSOC

entity associantions (eg. BOM, Change Order/Item, …)

field

data type

description

id

bigint not null PK

record number

assoc_type

smallint not null

association type / entity relationship description:

BOM = 0, CoItem = 10, CoFile = 11, Attachment = 20,

LinkParCld = 30, Association = 40, ReverseAssoc = 50, Other = -1

ent_id_parent

bigint not null FK

parent entity – link to EcENTITY.id

ent_id_child

bigint not null FK

child entity – link to EcENTITY.id

qty_occ

int

BOM - number of component occurrences

qty_total

float

BOM - total quantity

position

nvarchar 6

BOM – position (item number)

row_number

nvarchar 6

according to EcASSOC.assoc_type field:

BOM: row number

Attachment: β€œPin” means pinned to a specific file version

Association: 0: Primary, 1: Secondary, 2: Tertiary, 3: StandardComponent,

4: PrimarySub, 5: SecondarySub (AWS.ItemFileLnkTyp Enum)

driven_by_cad

bit

for BOM: 1 = row is driven by CAD component

for Association: 1 = file is driven by Item