commissioncontract

42 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
commissioncontract_objectgroup.commissioncontract_id FK_F124D4423529572DC
commissioncontract_order.commissioncontract_id FK_6BF14E863529572DR
commissioncontractitem.commissionContract_id FK_7C4E2155B3B5D8FAR
commissioncontractpaymentfield.commissionContract_id FK_253ACC46B3B5D8FAR
commissioncontractupload.commissionContract_id FK_35DD79DB3B5D8FAR
liability.commissionContract_id FK_3B59ECCCB3B5D8FAR
offeritem.commissionContractReturn_id FK_7E455D7CAC08CBCR
product.commissionContract_id FK_D34A04ADB3B5D8FAR
customer_id VARCHAR 36 √ null
customer.id FK_34122FF49395C3F3R
client_id VARCHAR 36 √ null
client.id FK_34122FF419EB6921R
created DATETIME 19 null
number BIGINT 19 null
note LONGTEXT 2147483647 √ null
title VARCHAR 255 null
contractDate DATE 10 √ null
signDate DATE 10 √ null
percentFee DECIMAL 10,2 √ null
fixFee DECIMAL 10,2 √ null
feeFormula VARCHAR 255 √ null
payout BIT 1 null
returnShipping_id VARCHAR 36 √ null
shipping.id FK_34122FF466C42665R
contractGroup_id VARCHAR 36 √ null
contractgroup.id FK_34122FF47B3B27A4R
payment_id VARCHAR 36 √ null
payment.id FK_34122FF44C3A3BBR
status_id VARCHAR 36 √ null
entitystatus.id FK_34122FF46BF700BDR
customerNote LONGTEXT 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_34122FF419EB6921 Performance Asc client_id
IDX_34122FF44C3A3BB Performance Asc payment_id
IDX_34122FF466C42665 Performance Asc returnShipping_id
IDX_34122FF46BF700BD Performance Asc status_id
IDX_34122FF47B3B27A4 Performance Asc contractGroup_id
IDX_34122FF49395C3F3 Performance Asc customer_id

Relationships

Close relationships within degrees of separation