subscriptioncontract

22 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
contact.subscriptionContract_id FK_4C62E638244DF37R
subscriptioncontract_objectgroup.subscriptioncontract_id FK_A1F6C8F984D850E0C
subscriptioncontractitem.subscriptionContract_id FK_992A6E5F244DF37R
subscriptioncontractpaymentfield.subscriptionContract_id FK_75E8D0FD244DF37R
subscriptioncontractupload.subscriptionContract_id FK_1FD18672244DF37R
customer_id VARCHAR 36 √ null
customer.id FK_EED229BF9395C3F3R
status_id VARCHAR 36 √ null
entitystatus.id FK_EED229BF6BF700BDR
payment_id VARCHAR 36 √ null
payment.id FK_EED229BF4C3A3BBR
client_id VARCHAR 36 √ null
client.id FK_EED229BF19EB6921R
created DATETIME 19 null
contractDate DATE 10 √ null
terminatedDate DATE 10 √ null
signDate DATE 10 √ null
title VARCHAR 255 null
number BIGINT 19 null
note LONGTEXT 2147483647 √ null
contractGroup_id VARCHAR 36 √ null
contractgroup.id FK_EED229BF7B3B27A4R
subscriptionPaymentTerm VARCHAR 255 √ null
shipping_id VARCHAR 36 √ null
shipping.id FK_EED229BF4887F3F8R
nettoMode BIT 1 null
percentDiscount DECIMAL 10,2 √ null
deliveryCost DECIMAL 10,2 √ null
paymentCost DECIMAL 10,2 √ null
fixDiscount DECIMAL 10,2 √ null
currency_id VARCHAR 36 √ null
currency.id FK_EED229BF38248176R
contractPeriod INT 10 √ null
lastPaymentDate DATETIME 19 √ null
remindDate DATE 10 √ null
remindCount INT 10 null
billFromDate DATE 10 √ null
paymentTermDate VARCHAR 255 √ null
lastOrder_id VARCHAR 36 √ null
orders.id FK_EED229BF662DD25BR
pricesAsNetto BIT 1 null
blocked BIT 1 null
subscriptionNotifyEventTerm VARCHAR 255 √ null
subscriptionPaymentTermFromDate DATE 10 √ null
paypalSubscriptionId VARCHAR 255 √ null
paypalSubscriptionTerminatedDate DATETIME 19 √ null
paypalContractCheckDate DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_EED229BF19EB6921 Performance Asc client_id
IDX_EED229BF38248176 Performance Asc currency_id
IDX_EED229BF4887F3F8 Performance Asc shipping_id
IDX_EED229BF4C3A3BB Performance Asc payment_id
IDX_EED229BF662DD25B Performance Asc lastOrder_id
IDX_EED229BF6BF700BD Performance Asc status_id
IDX_EED229BF7B3B27A4 Performance Asc contractGroup_id
IDX_EED229BF9395C3F3 Performance Asc customer_id

Relationships

Close relationships within degrees of separation