commissioncontract

39 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