posterminal

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
cashjournal.posTerminal_id FK_A7F52B64BE3C43ER
orders.posTerminal_id FK_E52FFDEE4BE3C43ER
posterminal_priceuser.posterminal_id FK_4692CEFCCD7F4BE9C
posterminal_user.posterminal_id FK_8A4CDD1DCD7F4BE9C
user_posterminal.posterminal_id FK_3F25404FCD7F4BE9C
user_posterminalprice.posterminal_id FK_ED271B4BCD7F4BE9C
model_id VARCHAR 36 √ null
posterminalmodel.id FK_963E89DA7975B7E7R
number VARCHAR 255 null
lastReceiptNumber INT 10 null
paperWidth INT 10 √ null
receiptTemplate LONGTEXT 2147483647 √ null
retailStore_id VARCHAR 36 √ null
retailstore.id FK_963E89DAC413DC35R
cashBoxNumber VARCHAR 255 √ null
active BIT 1 null
receiptNumberRange VARCHAR 255 √ null
defaultReturnLocation_id VARCHAR 36 √ null
warehousestoragelocation.id FK_963E89DA20917B0AR
lastECReceiptNumber INT 10 null
lastVoucherReceiptNumber INT 10 null
fontSize DOUBLE 22 √ null
lineHeight DOUBLE 22 √ null
wawilistener_id VARCHAR 36 √ null
wawilistener.id FK_963E89DA5DBC5E14R
bookingAccount VARCHAR 255 √ null
bookReturnsInFixStorageLocations BIT 1 null
lastSignature VARCHAR 255 √ null
lastECSignature VARCHAR 255 √ null
lastVoucherSignature VARCHAR 255 √ null
customerDisplayActive BIT 1 null
ecTerminalSettings LONGTEXT 2147483647 √ null
usezvt INT 10 null
printECTransaction INT 10 null
allowOpenCash BIT 1 null
tseCertificate LONGTEXT 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_963E89DA20917B0A Performance Asc defaultReturnLocation_id
IDX_963E89DA5DBC5E14 Performance Asc wawilistener_id
IDX_963E89DA7975B7E7 Performance Asc model_id
IDX_963E89DAC413DC35 Performance Asc retailStore_id

Relationships

Close relationships within degrees of separation