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