receipt


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
receiptitem.receiptId FKhgu7j8jnv2c6h0sraqh2pqqph R
receiptitem_aud.receiptId Implied Constraint R
locationGroupId INT 10 null
locationgroup.id FK55lrc8meneoxaotygksohs5oe R
orderTypeId INT 10 null
ordertype.id FK7w54h7mqa2k5kr3v6yepe8701 R
poId INT 10 √ null
po.id FKk8sytdefvbkrsflw0969hegxk R
soId INT 10 √ null
so.id FK9rp80kxbn28aau62wg4m9lgis R
statusId INT 10 null
receiptstatus.id FKiidqfkahcig0igvswl71v1sc8 R
typeId INT 10 null
receipttype.id FK7tn7vgikqjafs5v89fid1q0tx R
userId INT 10 null
sysuser.id FKjbkawab714fdfmel9ixnf0mkm R
xoId INT 10 √ null
xo.id FK3c01r7gtw2181lirbcbkrpr2p R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK3c01r7gtw2181lirbcbkrpr2p Performance Asc xoId
FK55lrc8meneoxaotygksohs5oe Performance Asc locationGroupId
FK7tn7vgikqjafs5v89fid1q0tx Performance Asc typeId
FK7w54h7mqa2k5kr3v6yepe8701 Performance Asc orderTypeId
FK9rp80kxbn28aau62wg4m9lgis Performance Asc soId
FKiidqfkahcig0igvswl71v1sc8 Performance Asc statusId
FKjbkawab714fdfmel9ixnf0mkm Performance Asc userId
FKk8sytdefvbkrsflw0969hegxk Performance Asc poId

Relationships

Close relationships within degrees of separation