liability

151 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
accountbooking.liability_id FK_3E0BC42E1E88FF9FR
hbci.liability_id FK_EE3BFE261E88FF9FR
liability_objectgroup.liability_id FK_62A9ED4F1E88FF9FC
liability_vendororder.liability_id FK_4D9803DE1E88FF9FC
liabilityitem.liability_id FK_590A525D1E88FF9FR
liabilitypayment.liability_id FK_153A78111E88FF9FR
liabilitypaymentfield.liability_id FK_B6B7F54B1E88FF9FR
liabilityupload.liability_id FK_28858571E88FF9FR
orders.agentLiability_id FK_E52FFDEEC8CACDD9R
voucher.liability_id FK_1392A5D81E88FF9FR
customer_id VARCHAR 36 √ null
customer.id FK_3B59ECCC9395C3F3R
country_id VARCHAR 36 √ null
country.id FK_3B59ECCCF92F3E70R
state_id VARCHAR 36 √ null
state.id FK_3B59ECCC5D83CC1R
client_id VARCHAR 36 √ null
client.id FK_3B59ECCC19EB6921R
payment_id VARCHAR 36 √ null
payment.id FK_3B59ECCC4C3A3BBR
created DATETIME 19 null
updated DATETIME 19 null
number INT 10 null
creditNoteNumber BIGINT 19 √ null
creditorInvoiceNumber VARCHAR 255 √ null
total DECIMAL 10,2 null
discount DECIMAL 10,2 √ null
deliveryCost DECIMAL 10,2 √ null
paymentCost DECIMAL 10,2 √ null
deliveryVat DECIMAL 10,2 √ null
additionalCost DECIMAL 10,2 √ null
additionalCost2 DECIMAL 10,2 √ null
additionalCost3 DECIMAL 10,2 √ null
additionalCost4 DECIMAL 10,2 √ null
additionalCost5 DECIMAL 10,2 √ null
status VARCHAR 50 √ null
email VARCHAR 255 √ null
salutation VARCHAR 255 √ null
company VARCHAR 255 √ null
firstName VARCHAR 255 √ null
lastName VARCHAR 255 √ null
street VARCHAR 255 √ null
street2 VARCHAR 255 √ null
vatId VARCHAR 50 √ null
city VARCHAR 200 √ null
zip VARCHAR 16 √ null
phone VARCHAR 128 √ null
fax VARCHAR 128 √ null
currency VARCHAR 32 √ null
note LONGTEXT 2147483647 √ null
internalNote LONGTEXT 2147483647 √ null
additionalInfo LONGTEXT 2147483647 √ null
additionalInfo2 LONGTEXT 2147483647 √ null
additionalInfo3 LONGTEXT 2147483647 √ null
paymentTransactionId VARCHAR 128 √ null
paidDate DATETIME 19 √ null
transactionStatus VARCHAR 128 √ null
nettoMode BIT 1 null
calcPlusTax BIT 1 null
voucherDiscount DECIMAL 10,2 √ null
additInfo VARCHAR 255 √ null
completed BIT 1 null
creditNoteDate DATETIME 19 √ null
creditorInvoiceDate DATE 10 √ null
completedDate DATETIME 19 √ null
paymentDueDate DATE 10 √ null
vendor_id VARCHAR 36 √ null
vendor.id FK_3B59ECCCF603EE73R
vendorOrder_id VARCHAR 36 √ null
vendororder.id FK_3B59ECCC1ED6D67CR
creditorInvoiceFile VARCHAR 255 √ null
lastupdated INT 10 null
account VARCHAR 12 √ null
bookingText VARCHAR 255 √ null
vatNumber VARCHAR 50 √ null
commissionContract_id VARCHAR 36 √ null
commissioncontract.id FK_3B59ECCCB3B5D8FAR
cashDiscount DECIMAL 10,2 √ null
liabilityStatus_id VARCHAR 36 √ null
entitystatus.id FK_3B59ECCCBB7A1966R
clerk_id INT 10 √ null
users.id FK_3B59ECCCD95C1FC6R
liabilityTemplate VARCHAR 128 √ null
pureAccountBooking BIT 1 null
language_id VARCHAR 36 √ null
language.id FK_3B59ECCC82F1BAF4R
totalnetto DECIMAL 10,2 null
shippingDate DATETIME 19 √ null
cashDiscountPercent DECIMAL 10,2 √ null
cashDiscountDays INT 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
created_idx Performance Asc created
IDX_3B59ECCC19EB6921 Performance Asc client_id
IDX_3B59ECCC1ED6D67C Performance Asc vendorOrder_id
IDX_3B59ECCC4C3A3BB Performance Asc payment_id
IDX_3B59ECCC5D83CC1 Performance Asc state_id
IDX_3B59ECCC82F1BAF4 Performance Asc language_id
IDX_3B59ECCC9395C3F3 Performance Asc customer_id
IDX_3B59ECCCB3B5D8FA Performance Asc commissionContract_id
IDX_3B59ECCCBB7A1966 Performance Asc liabilityStatus_id
IDX_3B59ECCCD95C1FC6 Performance Asc clerk_id
IDX_3B59ECCCF603EE73 Performance Asc vendor_id
IDX_3B59ECCCF92F3E70 Performance Asc country_id
template_idx Performance Asc liabilityTemplate

Relationships

Close relationships within degrees of separation