serialnum_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
REV BIGINT 19 null
revinfo.id FKfbf48e6ib81j7ntkj2lotlo64 R
REVTYPE TINYINT 3 √ null
partTrackingId INT 10 √ null
serialId BIGINT 19 √ null
serial.id Implied Constraint R
serialNum VARCHAR 256 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc id + REV
FKfbf48e6ib81j7ntkj2lotlo64 Performance Asc REV

Relationships

Close relationships within degrees of separation