parttracking


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
parttotracking.partTrackingId FK7yn4fi6i9pcfx5axqpcvu3pcr R
serialnum.partTrackingId FKemjomf1r7725gwlxlle68g6ir R
tiinventorylog.partTrackingId FKla7kr9d4reefs1f6vp9ruegd0 R
tiinventorylogsn.partTrackingId FKissw9ju5ro3wpim9bttf6wx3e R
trackingdate.partTrackingId FK3gok40ou669ymluxvhg7ojbbh R
trackingdecimal.partTrackingId FK72tljagytq68fsc51loimf3u4 R
trackinginfo.partTrackingId FKll0swo2b0c8nd167nwo3739u1 R
trackinginfosn.partTrackingId FKbsp884qjk52j87bu6srkdtq23 R
trackinginteger.partTrackingId FK13iebryvmpp2fvaj1iigwyud4 R
trackingtext.partTrackingId FKby205ki7hj3vux8sywxt6p8q8 R
abbr VARCHAR 10 null
activeFlag BIT 1 null
description VARCHAR 256 √ null
name VARCHAR 41 null
sortOrder INT 10 null
typeId INT 10 null
parttrackingtype.id FKfba1dj8x87uf5vtgys8qfn3vi R
gs1Code INT 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKfba1dj8x87uf5vtgys8qfn3vi Performance Asc typeId
UK4hbx44i04nr6eujj263a9d7od Must be unique Asc name

Relationships

Close relationships within degrees of separation