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