cm_tree_contracts.go 2.1 KB

12345678910111213141516171819202122232425262728293031
  1. package models
  2. import (
  3. "time"
  4. )
  5. type CmTreeContracts struct {
  6. Id int `xorm:"not null pk autoincr comment('自增ID') INT(11)"`
  7. TreeType int `xorm:"not null default 0 comment('项目节类型(0收入,1支出)') TINYINT(1)"`
  8. TreeId int `xorm:"not null comment('树ID') INT(11)"`
  9. ParentId int `xorm:"not null default 0 comment('父级ID') INT(11)"`
  10. Name string `xorm:"not null comment('名称') VARCHAR(64)"`
  11. Code string `xorm:"comment('项目节编号') VARCHAR(32)"`
  12. Depth int `xorm:"not null default 0 comment('深度') TINYINT(4)"`
  13. Serial int `xorm:"not null default 0 comment('序号') INT(11)"`
  14. Attribution string `xorm:"comment('归属') VARCHAR(32)"`
  15. Sort int `xorm:"not null default 0 comment('排序') TINYINT(4)"`
  16. ProjectId int `xorm:"not null default 0 comment('项目ID') INT(11)"`
  17. BidsectionId int `xorm:"comment('标段ID') INT(11)"`
  18. ContractId int `xorm:"not null default 0 comment('合同ID') INT(11)"`
  19. ContractName string `xorm:"comment('合同名称') VARCHAR(64)"`
  20. ContractCode string `xorm:"comment('合同编号') VARCHAR(32)"`
  21. ContractPrice string `xorm:"not null default 0.00 comment('合同金额') DECIMAL(12,2)"`
  22. ContractReturned string `xorm:"not null default 0.00 comment('回款金额') DECIMAL(12,2)"`
  23. ContractsPaid string `xorm:"not null default 0.00 comment('合同已支付金额') DECIMAL(12,2)"`
  24. ContractDeductionTotal string `xorm:"not null default 0.00 comment('扣款金额合计') DECIMAL(12,2)"`
  25. ContractStatus int `xorm:"not null default 0 comment('合同状态(0履行中1待关闭2正常关闭)') TINYINT(1)"`
  26. ContractLocking int `xorm:"not null default 0 comment('合同锁定(0未锁定1锁定)') TINYINT(1)"`
  27. SettlementCode string `xorm:"comment('结算书编号') VARCHAR(255)"`
  28. CreateTime time.Time `xorm:"comment('创建时间') DATETIME"`
  29. }